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(558, 561, 562, 681, 896, 1045, 1227, 1864, 2407, 2408, 2409, 2446, 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, 3086, 3087, 3278, 3279, 3281, 3432, 3433, 3434, 3439, 3441, 3442, 3443, 3444, 3445, 3448, 3449, 3452, 3488, 3489, 3490, 3491, 3492, 3493, 3494, 3676, 3677, 3678, 3679, 3680, 3689, 3726, 3727, 3728, 3729, 3730, 3731, 3732, 3756, 3757, 3758, 3773, 3774, 3775, 3813, 3847, 3859, 3895, 3982, 3990, 3991, 3992, 4004, 4005, 4006, 4034, 4043, 4044, 4045, 4049, 4050, 4051, 4069, 4070, 4072, 4073, 4074, 4075, 4085, 4087, 4098, 4099, 4100, 4124, 4161, 4181, 4204, 4224, 4225, 4263, 4264, 4265, 4266, 4267, 4293, 4299, 4300, 4309, 4310, 4311, 4312, 4313, 4345, 4369, 4390, 4391, 4392, 4393, 4394, 4402, 4407, 4429, 4467, 4478, 4535, 4564, 4635, 4642, 4643, 4651, 4671, 4675, 4679, 4684, 4690, 4717, 4718, 4719, 4720, 4721, 4731, 4782, 4813, 4819, 4820, 4821, 4834, 4872, 4888, 4889, 4890, 4899, 4904, 4905, 4931, 4932, 4947, 4948, 4949, 4989, 4990, 4991, 4992, 4993, 4994, 4999, 5002, 5024, 5032, 5071, 5073, 5115, 5123, 5133, 5134, 5136, 5137, 5144, 5148, 5149, 5150, 5151, 5153, 5176, 5189, 5190, 5191, 5194, 5195, 5196, 5200, 5201, 5242, 5243, 5244, 5246, 5247, 5248, 5249, 5250, 5251, 5252, 5253, 5254, 5257, 5258, 5259, 5260, 5261, 5297, 5429, 5433, 5434, 5435, 5436, 5437, 5438, 5439, 5440, 5441, 5442, 5443, 5468, 5469, 5479, 5498, 5499, 5500, 5501, 5502, 5503, 5520, 5523, 5556, 5557, 5558, 5559, 5560, 5561, 5562, 5563, 5564, 5565, 5594, 5597, 5600, 5602, 5607, 5611, 5697, 5698, 5712, 5713, 5714, 5715, 5742, 5750, 5751, 5752, 5810, 5811, 5812, 5813, 5814, 5815, 5835, 5836, 5837, 5838, 5891, 5892, 5893, 5894, 5895, 5896, 5897, 5898, 5899, 5900, 5901, 5902, 5903, 5904, 5905, 5906, 5908, 5909, 5910, 5911, 5946, 5947, 5948, 5949, 5950, 6023, 6112, 6113, 6114, 6115, 6134, 6135, 6136, 6151, 6152, 6153, 6178, 6179, 6180, 6181, 6182, 6183, 6184, 6185, 6186, 6187, 6200, 6211, 6375, 6376, 6377, 6402, 6403, 6404, 6439, 6447, 6448, 6449, 6450, 6451, 6452, 6453, 6454, 6455, 6456, 6559, 6579, 6580, 6581, 6582, 6583, 6584, 6585, 6586, 6692, 6693, 6694, 6695, 6696, 6697, 6698, 6699, 6700, 6701, 6702, 6746, 6747, 6748, 6749, 6750, 6773, 6776, 6777, 6778, 6779, 6780, 6781, 6782, 6783, 6788, 6789, 6790, 6791, 6794, 6795, 6796, 6797, 6798, 6894, 6929, 6930, 6931, 6981, 7036, 7037)) ORDER BY FIELD(`e`.`entity_id`, 5715, 5714, 5498, 7037, 7036, 6981, 6931, 6930, 6929, 6894, 6798, 6797, 6796, 6795, 6794, 6791, 6790, 6789, 6788, 6783, 6782, 6781, 6780, 6779, 6778, 6777, 6776, 6773, 6750, 6749, 6748, 6747, 6746, 6702, 6701, 6699, 6698, 6697, 6696, 6695, 6694, 6693, 6692, 6586, 6585, 6584, 6583, 6582, 6581, 6580, 6579, 6559, 6453, 6452, 6451, 6450, 6449, 6448, 6447, 6439, 6403, 6402, 6377, 6375, 6211, 6200, 6023, 5902, 5901, 5900, 5897, 5896, 5895, 5894, 5893, 5892, 5891, 5838, 5836, 5835, 5815, 5814, 5813, 5811, 5810, 5752, 5751, 5750, 5742, 5713, 5712, 5698, 5697, 5611, 5607, 5602, 5600, 5594, 5565, 5564, 5563, 5561, 5500, 5499, 5469, 5438, 5437, 5436, 5032, 5002, 4993, 4992, 4989, 4948, 4947, 4731, 4690, 4651, 4407, 4310, 4309, 4161, 4050, 4049, 3731, 3730, 3729, 3726, 3680, 3679, 3678, 3677, 3676, 3087, 2540, 2538, 2446, 2408, 2407, 1227, 681, 562, 561, 558, 6700, 6456, 6455, 6454, 6404, 6376, 6187, 6186, 6185, 6184, 6183, 6182, 6181, 6180, 6179, 6178, 6153, 6152, 6151, 6136, 6135, 6134, 6115, 6114, 6113, 6112, 5950, 5949, 5948, 5947, 5946, 5911, 5910, 5909, 5908, 5906, 5905, 5904, 5903, 5899, 5898, 5837, 5812, 5597, 5562, 5560, 5559, 5558, 5557, 5556, 5523, 5520, 5503, 5502, 5501, 5479, 5468, 5443, 5442, 5441, 5440, 5439, 5435, 5434, 5433, 5429, 5297, 5261, 5260, 5259, 5258, 5257, 5254, 5253, 5252, 5251, 5250, 5249, 5248, 5247, 5246, 5244, 5243, 5242, 5201, 5200, 5196, 5195, 5194, 5191, 5190, 5189, 5176, 5153, 5151, 5150, 5149, 5148, 5144, 5137, 5136, 5134, 5133, 5123, 5115, 5073, 5071, 5024, 4999, 4994, 4991, 4990, 4949, 4932, 4931, 4905, 4904, 4899, 4890, 4889, 4888, 4872, 4834, 4821, 4820, 4819, 4813, 4782, 4721, 4720, 4719, 4718, 4717, 4684, 4679, 4675, 4671, 4643, 4642, 4635, 4564, 4535, 4478, 4467, 4429, 4402, 4394, 4393, 4392, 4391, 4390, 4369, 4345, 4313, 4312, 4311, 4300, 4299, 4293, 4267, 4266, 4265, 4264, 4263, 4225, 4224, 4204, 4181, 4124, 4100, 4099, 4098, 4087, 4085, 4075, 4074, 4073, 4072, 4070, 4069, 4051, 4045, 4044, 4043, 4034, 4006, 4005, 4004, 3992, 3991, 3990, 3982, 3895, 3859, 3847, 3813, 3775, 3774, 3773, 3758, 3757, 3756, 3732, 3728, 3727, 3689, 3494, 3493, 3492, 3491, 3490, 3489, 3488, 3452, 3449, 3448, 3445, 3444, 3443, 3442, 3441, 3439, 3434, 3433, 3432, 3281, 3279, 3278, 3086, 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, 1864, 1045, 896) ASC, `stock`.`stock_status` desc, `e`.`created_at` desc LIMIT 36
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Giá thường:
1.550.000 ₫
Special Price
1.390.000 ₫
5698
-
Giá thường:
1.550.000 ₫
Special Price
1.390.000 ₫
5697