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(681, 1227, 2407, 2408, 2409, 2533, 2534, 2535, 2536, 2537, 2538, 2539, 2540, 2541, 2542, 2543, 2544, 2679, 2680, 2700, 2704, 2705, 2706, 2707, 2708, 2709, 2898, 2899, 2900, 2901, 2902, 2903, 2904, 2916, 2918, 2919, 2920, 2921, 2922, 2923, 2924, 2925, 2926, 3278, 3279, 3432, 3433, 3434, 3439, 3441, 3442, 3443, 3444, 3445, 3448, 3449, 3452, 3491, 3689, 3726, 3727, 3728, 3729, 3730, 3731, 3732, 3756, 3757, 3758, 3773, 3774, 3775, 3859, 3895, 4034, 4098, 4099, 4100, 4224, 4225, 4293, 4299, 4300, 4402, 4407, 4535, 4564, 4643, 4671, 4675, 4717, 4718, 4719, 4720, 4721, 4731, 4782, 4813, 4819, 4820, 4821, 4834, 4872, 4899, 4931, 4932, 4947, 4948, 4949, 4999, 5002, 5024, 5032, 5071, 5123, 5133, 5134, 5136, 5137, 5144, 5148, 5149, 5150, 5151, 5153, 5194, 5195, 5196, 5200, 5201, 5297, 5429, 5468, 5469, 5479, 5498, 5520, 5523, 5607, 5611, 5712, 5713, 5714, 5715, 5750, 5751, 5752, 5891, 5892, 5893, 5894, 5895, 5896, 5897, 5898, 5899, 5900, 5901, 5902, 5903, 5904, 5905, 5906, 5908, 5909, 5910, 5911, 6023, 6211, 6375, 6376, 6377, 6439, 6781, 6782, 6783, 6788, 6789, 6790, 6791, 6894, 6929, 6930, 6931, 6981, 7036, 7037)) ORDER BY FIELD(`e`.`entity_id`, 7037, 7036, 6981, 6931, 6930, 6929, 6894, 6791, 6790, 6789, 6788, 6783, 6782, 6781, 6439, 6377, 6375, 6211, 6023, 5902, 5901, 5900, 5897, 5896, 5895, 5894, 5893, 5892, 5891, 5752, 5751, 5750, 5715, 5714, 5713, 5712, 5611, 5607, 5498, 5469, 5032, 5002, 4948, 4947, 4731, 4407, 3731, 3730, 3729, 3726, 2540, 2538, 2408, 2407, 1227, 681, 6376, 5911, 5910, 5909, 5908, 5906, 5905, 5904, 5903, 5899, 5898, 5523, 5520, 5479, 5468, 5429, 5297, 5201, 5200, 5196, 5195, 5194, 5153, 5151, 5150, 5149, 5148, 5144, 5137, 5136, 5134, 5133, 5123, 5071, 5024, 4999, 4949, 4932, 4931, 4899, 4872, 4834, 4821, 4820, 4819, 4813, 4782, 4721, 4720, 4719, 4718, 4717, 4675, 4671, 4643, 4564, 4535, 4402, 4300, 4299, 4293, 4225, 4224, 4100, 4099, 4098, 4034, 3895, 3859, 3775, 3774, 3773, 3758, 3757, 3756, 3732, 3728, 3727, 3689, 3491, 3452, 3449, 3448, 3445, 3444, 3443, 3442, 3441, 3439, 3434, 3433, 3432, 3279, 3278, 2926, 2925, 2924, 2923, 2922, 2921, 2920, 2919, 2918, 2916, 2904, 2903, 2902, 2901, 2900, 2899, 2898, 2709, 2708, 2707, 2706, 2705, 2704, 2700, 2680, 2679, 2544, 2543, 2542, 2541, 2539, 2537, 2536, 2535, 2534, 2533, 2409) ASC, `stock`.`stock_status` desc, `e`.`created_at` desc LIMIT 36
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Giá thường:
350.000 ₫
Special Price
290.000 ₫
5032
-
Giá thường:
250.000 ₫
Special Price
98.000 ₫
5002
-
Giá thường:
380.000 ₫
Special Price
320.000 ₫
4947
-
-
Giá thường:
560.000 ₫
Special Price
460.000 ₫
4407
-
Giá thường:
220.000 ₫
Special Price
77.000 ₫
3726
-
Giá thường:
280.000 ₫
Special Price
196.000 ₫
2538
-
Giá thường:
210.000 ₫
Special Price
147.000 ₫
2407
-
Kèm theo
- Hộp quà nhung sang trọng
-
Giá thường:
50.000 ₫
Special Price
38.000 ₫
681
-
-
-
-
-
-
-
-
-
-
Giá thường:
250.000 ₫
Special Price
175.000 ₫
5479