SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `cat_index`.`position` AS `cat_index_position`, `stock`.`qty` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='1' AND cat_index.visibility IN(3, 4) AND cat_index.category_id = '2'
INNER JOIN `cataloginventory_stock_status` AS `stock` ON e.entity_id = stock.product_id WHERE (`e`.`entity_id` IN(510, 516, 684, 760, 763, 798, 968, 1115, 1197, 1543, 1847, 1852, 1931, 1967, 2000, 2001, 2002, 2003, 2004, 2038, 2039, 2040, 2111, 2113, 2114, 2116, 2118, 2120, 2121, 2122, 2124, 2125, 2132, 2151, 2153, 2159, 2160, 2444, 2445, 2530, 2661, 2663, 2664, 2731, 2732, 2735, 2736, 2737, 2738, 2740, 2741, 2749, 2750, 2751, 2752, 2753, 2862, 2863, 2940, 2941, 2943, 2946, 2948, 2956, 2957, 2958, 2959, 2960, 2961, 2964, 2965, 2966, 2972, 2975, 2976, 2977, 2978, 2979, 2980, 2981, 2998, 3205, 3214, 3228, 3322, 3323, 3367, 3376, 3397, 3406, 3407, 3410, 3411, 3428, 3429, 3430, 3435, 3437, 3441, 3445, 3452, 3500, 3565, 3566, 3567, 3568, 3572, 3580, 3587, 3657, 3674, 3697, 3711, 3717, 3718, 3719, 3720, 3721, 3722, 3723, 3735, 3736, 3737, 3738, 3773, 3774, 3795, 3796, 3797, 3798, 3799, 3800, 3813, 3814, 3832, 3835, 3844, 3854, 3856, 3900, 3901, 3977, 3978, 3980, 3981, 3988, 4003, 4007, 4022, 4023, 4024, 4054, 4056, 4057, 4058, 4060, 4061, 4062, 4063, 4064, 4115, 4116, 4118, 4122, 4188, 4192, 4194, 4195, 4201, 4289, 4290, 4293, 4294, 4299, 4314, 4380, 4459, 4474, 4475, 4476, 4480, 4498, 4505, 4506, 4508, 4509, 4535, 4609, 4670, 4671, 4694, 4700, 4707, 4709, 4710, 4711, 4713, 4730, 4731, 4738, 4767, 4784, 4789, 4879, 4883, 4884, 4885, 4886, 4887, 4888, 4889, 4890, 4929, 4930, 4931, 4932, 5036, 5037, 5038, 5044, 5046, 5052, 5068, 5069, 5070, 5078, 5087, 5088, 5125, 5127, 5128, 5133, 5135, 5136, 5142, 5144, 5147, 5148, 5149, 5152, 5154, 5155, 5185, 5186, 5204, 5211, 5215, 5234, 5235, 5236, 5237, 5255, 5291, 5336, 5338, 5357, 5415, 5447, 5468, 5476, 5477, 5478, 5481, 5495, 5496, 5497, 5516, 5517, 5518, 5519, 5520, 5521, 5522, 5581, 5582, 5583, 5584, 5585, 5586, 5589, 5590, 5591, 5592, 5625, 5626, 5627, 5635, 5640, 5641, 5642, 5679, 5691, 5694, 5708, 5709, 5812, 5815, 5829, 5831, 5832, 5867, 5868, 5873, 5880, 5944, 5947, 5949, 5976, 5992, 5995, 6021, 6022, 6029, 6030, 6031, 6032, 6043, 6144, 6184, 6186, 6208, 6230, 6231, 6271, 6284, 6339, 6341, 6345, 6429, 6433, 6434, 6435, 6436, 6440, 6441, 6442, 6443, 6444, 6488, 6655, 6656, 6699, 6701, 6710, 6827, 6974, 6983, 7021, 7030, 7031, 7032)) ORDER BY FIELD(`e`.`entity_id`, 1543, 5880, 5873, 5635, 5481, 5478, 4929, 3720, 3719, 3718, 3711, 3410, 3228, 3205, 2976, 1115, 7032, 7031, 7030, 7021, 6983, 6974, 6827, 6701, 6699, 6656, 6655, 6488, 6444, 6443, 6442, 6441, 6440, 6436, 6435, 6434, 6433, 6429, 6345, 6341, 6339, 6230, 6208, 6022, 5992, 5944, 5868, 5832, 5831, 5829, 5815, 5626, 5625, 5585, 5584, 5583, 5582, 5581, 5357, 5215, 5204, 5070, 5069, 5052, 5044, 5038, 5037, 5036, 4887, 4883, 4789, 4767, 4731, 4730, 4670, 4498, 4294, 3738, 3735, 3580, 2965, 2964, 2960, 2959, 2958, 2956, 2946, 2943, 2941, 2664, 2663, 2661, 2445, 2444, 2153, 1852, 798, 760, 516, 510, 6710, 6284, 6271, 6231, 6186, 6184, 6144, 6043, 6032, 6031, 6030, 6029, 6021, 5995, 5976, 5949, 5947, 5867, 5812, 5709, 5708, 5694, 5691, 5679, 5642, 5641, 5640, 5627, 5592, 5591, 5590, 5589, 5586, 5522, 5521, 5520, 5519, 5518, 5517, 5516, 5497, 5496, 5495, 5477, 5476, 5468, 5447, 5415, 5338, 5336, 5291, 5255, 5237, 5236, 5235, 5234, 5211, 5186, 5185, 5155, 5154, 5152, 5149, 5148, 5147, 5144, 5142, 5136, 5135, 5133, 5128, 5127, 5125, 5088, 5087, 5078, 5068, 5046, 4932, 4931, 4930, 4890, 4889, 4888, 4886, 4885, 4884, 4879, 4784, 4738, 4713, 4711, 4710, 4709, 4707, 4700, 4694, 4671, 4609, 4535, 4509, 4508, 4506, 4505, 4480, 4476, 4475, 4474, 4459, 4380, 4314, 4299, 4293, 4290, 4289, 4201, 4195, 4194, 4192, 4188, 4122, 4118, 4116, 4115, 4064, 4063, 4062, 4061, 4060, 4058, 4057, 4056, 4054, 4024, 4023, 4022, 4007, 4003, 3988, 3981, 3980, 3978, 3977, 3901, 3900, 3856, 3854, 3844, 3835, 3832, 3814, 3813, 3800, 3799, 3798, 3797, 3796, 3795, 3774, 3773, 3737, 3736, 3723, 3722, 3721, 3717, 3697, 3674, 3657, 3587, 3572, 3568, 3567, 3566, 3565, 3500, 3452, 3445, 3441, 3437, 3435, 3430, 3429, 3428, 3411, 3407, 3406, 3397, 3376, 3367, 3323, 3322, 3214, 2998, 2981, 2980, 2979, 2978, 2977, 2975, 2972, 2966, 2961, 2957, 2948, 2940, 2863, 2862, 2753, 2752, 2751, 2750, 2749, 2741, 2740, 2738, 2737, 2736, 2735, 2732, 2731, 2530, 2160, 2159, 2151, 2132, 2125, 2124, 2122, 2121, 2120, 2118, 2116, 2114, 2113, 2111, 2040, 2039, 2038, 2004, 2003, 2002, 2001, 2000, 1967, 1931, 1847, 1197, 968, 763, 684) ASC, `stock`.`stock_status` desc, `e`.`created_at` desc LIMIT 36
-
Giá thường:
95.000 ₫
Special Price
56.000 ₫
1543
-
-
-
Giá thường:
119.000 ₫
Special Price
99.000 ₫
5635
-
Giá thường:
85.000 ₫
Special Price
59.000 ₫
5481
-
Giá thường:
95.000 ₫
Special Price
66.000 ₫
5478
-
Giá thường:
980.000 ₫
Special Price
588.000 ₫
4929
-
Giá thường:
200.000 ₫
Special Price
140.000 ₫
3711
-
Giá thường:
250.000 ₫
Special Price
160.000 ₫
3228
-
-
-
-
-
-
-
-
-
-
Giá thường:
580.000 ₫
Special Price
550.000 ₫
6429
-
-
-
Giá thường:
970.000 ₫
Special Price
945.000 ₫
5944
-
Giá thường:
2.500.000 ₫
Special Price
2.180.000 ₫
5868
-
-
-
-
-
-
-
Kèm theo
- Túi đựng quà sang trọng
-
Giá thường:
650.000 ₫
Special Price
430.000 ₫
5215
Khuyến Mại
>> Đặt qua shopee chỉ còn 589k
>> Miễn phí vận chuyển toàn quốc
-
Giá thường:
260.000 ₫
Special Price
182.000 ₫
5069
-
Giá thường:
200.000 ₫
Special Price
126.000 ₫
5052
-
Giá thường:
420.000 ₫
Special Price
180.000 ₫
5044
-
Giá thường:
380.000 ₫
Special Price
145.000 ₫
5036
-
Giá thường:
520.000 ₫
Special Price
420.000 ₫
4883