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, 760, 763, 798, 1197, 1543, 1847, 1852, 1931, 2000, 2001, 2002, 2003, 2004, 2111, 2113, 2114, 2116, 2118, 2120, 2121, 2122, 2124, 2125, 2132, 2444, 2445, 2661, 2663, 2664, 2731, 2732, 2735, 2736, 2737, 2738, 2740, 2741, 2749, 2750, 2751, 2752, 2753, 2862, 2863, 2943, 2946, 2948, 2956, 2957, 2958, 2959, 2960, 2961, 2964, 2965, 2966, 3205, 3214, 3228, 3322, 3323, 3367, 3376, 3410, 3411, 3428, 3429, 3430, 3435, 3437, 3441, 3445, 3452, 3580, 3657, 3674, 3697, 3711, 3717, 3718, 3719, 3720, 3721, 3722, 3723, 3735, 3736, 3737, 3738, 3773, 3774, 3813, 3814, 3832, 3835, 3844, 3900, 3901, 3978, 3981, 3988, 4003, 4007, 4022, 4023, 4024, 4054, 4056, 4057, 4058, 4060, 4061, 4062, 4063, 4064, 4188, 4192, 4194, 4195, 4201, 4294, 4314, 4380, 4459, 4474, 4475, 4476, 4609, 4670, 4671, 4694, 4730, 4731, 4879, 4929, 4930, 4931, 4932, 5078, 5087, 5088, 5125, 5127, 5128, 5133, 5135, 5136, 5142, 5147, 5152, 5154, 5155, 5185, 5186, 5204, 5211, 5357, 5447, 5476, 5477, 5478, 5481, 5495, 5496, 5497, 5589, 5590, 5591, 5592, 5625, 5626, 5627, 5635, 5640, 5641, 5642, 5679, 5691, 5694, 5708, 5709, 5867, 5868, 5873, 5880, 5976, 5992, 5995, 6021, 6022, 6029, 6030, 6031, 6032, 6208, 6284, 6433, 6434, 6435, 6436, 6440, 6441, 6442, 6443, 6444, 6488, 6710, 6974, 6983, 7021, 7030, 7031, 7032)) ORDER BY FIELD(`e`.`entity_id`, 5880, 5873, 5635, 5481, 5478, 4929, 3720, 3719, 3718, 3711, 3410, 3228, 3205, 1543, 7032, 7031, 7030, 7021, 6983, 6974, 6488, 6444, 6443, 6442, 6441, 6440, 6436, 6435, 6434, 6433, 6208, 6022, 5992, 5868, 5626, 5625, 5357, 5204, 4731, 4730, 4670, 4294, 3738, 3735, 3580, 2965, 2964, 2960, 2959, 2958, 2956, 2946, 2943, 2664, 2663, 2661, 2445, 2444, 1852, 798, 760, 516, 510, 6710, 6284, 6032, 6031, 6030, 6029, 6021, 5995, 5976, 5867, 5709, 5708, 5694, 5691, 5679, 5642, 5641, 5640, 5627, 5592, 5591, 5590, 5589, 5497, 5496, 5495, 5477, 5476, 5447, 5211, 5186, 5185, 5155, 5154, 5152, 5147, 5142, 5136, 5135, 5133, 5128, 5127, 5125, 5088, 5087, 5078, 4932, 4931, 4930, 4879, 4694, 4671, 4609, 4476, 4475, 4474, 4459, 4380, 4314, 4201, 4195, 4194, 4192, 4188, 4064, 4063, 4062, 4061, 4060, 4058, 4057, 4056, 4054, 4024, 4023, 4022, 4007, 4003, 3988, 3981, 3978, 3901, 3900, 3844, 3835, 3832, 3814, 3813, 3774, 3773, 3737, 3736, 3723, 3722, 3721, 3717, 3697, 3674, 3657, 3452, 3445, 3441, 3437, 3435, 3430, 3429, 3428, 3411, 3376, 3367, 3323, 3322, 3214, 2966, 2961, 2957, 2948, 2863, 2862, 2753, 2752, 2751, 2750, 2749, 2741, 2740, 2738, 2737, 2736, 2735, 2732, 2731, 2132, 2125, 2124, 2122, 2121, 2120, 2118, 2116, 2114, 2113, 2111, 2004, 2003, 2002, 2001, 2000, 1931, 1847, 1197, 763) ASC, `stock`.`stock_status` desc, `e`.`created_at` desc LIMIT 36
-
-
-
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:
95.000 ₫
Special Price
56.000 ₫
1543
-
-
-
-
-
-
-
-
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:
110.000 ₫
Special Price
90.000 ₫
4294
-
Giá thường:
220.000 ₫
Special Price
154.000 ₫
3735
-
Giá thường:
260.000 ₫
Special Price
195.000 ₫
3580
-
-
Giá thường:
245.000 ₫
Special Price
140.000 ₫
2959
-
Giá thường:
175.000 ₫
Special Price
99.000 ₫
2956
-
-
-
Giá thường:
650.000 ₫
Special Price
630.000 ₫
2663
-
-
-
-
Giá thường:
195.000 ₫
Special Price
90.000 ₫
1852