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, 896, 1045, 1864, 2446, 3086, 3087, 3278, 3279, 3281, 3488, 3489, 3490, 3491, 3492, 3493, 3494, 3676, 3677, 3678, 3679, 3680, 3756, 3757, 3758, 3813, 3847, 3895, 3982, 3990, 3991, 3992, 4004, 4005, 4006, 4043, 4044, 4045, 4049, 4050, 4051, 4069, 4070, 4072, 4073, 4074, 4075, 4085, 4087, 4098, 4099, 4100, 4124, 4125, 4161, 4181, 4204, 4206, 4263, 4264, 4265, 4266, 4267, 4309, 4310, 4311, 4312, 4313, 4345, 4369, 4390, 4391, 4392, 4393, 4394, 4429, 4443, 4467, 4478, 4635, 4642, 4651, 4679, 4684, 4690, 4831, 4832, 4833, 4859, 4863, 4864, 4888, 4889, 4890, 4904, 4905, 4989, 4990, 4991, 4992, 4993, 4994, 5073, 5115, 5176, 5189, 5190, 5191, 5242, 5243, 5244, 5246, 5247, 5248, 5249, 5250, 5251, 5252, 5253, 5254, 5257, 5258, 5259, 5260, 5261, 5295, 5433, 5434, 5435, 5436, 5437, 5438, 5439, 5440, 5441, 5442, 5443, 5456, 5463, 5498, 5499, 5500, 5501, 5502, 5503, 5523, 5556, 5557, 5558, 5559, 5560, 5561, 5562, 5563, 5564, 5565, 5594, 5597, 5600, 5602, 5664, 5697, 5698, 5712, 5714, 5715, 5742, 5810, 5811, 5812, 5813, 5814, 5815, 5816, 5817, 5818, 5819, 5820, 5835, 5836, 5837, 5838, 5946, 5947, 5948, 5949, 5950, 6112, 6113, 6114, 6115, 6134, 6135, 6136, 6151, 6152, 6153, 6178, 6179, 6180, 6181, 6182, 6183, 6184, 6185, 6186, 6187, 6200, 6402, 6403, 6404, 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, 6788, 6789, 6790, 6791, 6792, 6794, 6795, 6796, 6797, 6798)) ORDER BY FIELD(`e`.`entity_id`, 6795, 6794, 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, 6403, 6402, 6200, 5742, 5565, 5564, 5563, 5561, 5438, 5437, 5436, 5247, 5246, 6798, 6797, 6796, 6792, 6791, 6790, 6789, 6788, 5838, 5836, 5835, 5820, 5816, 5815, 5814, 5813, 5811, 5810, 5715, 5714, 5712, 5698, 5697, 5664, 5602, 5600, 5597, 5594, 5500, 5499, 4993, 4992, 4989, 4863, 4859, 4690, 4651, 4310, 4309, 4161, 4050, 4049, 3680, 3679, 3678, 3677, 3676, 3087, 2446, 562, 561, 558, 6700, 6456, 6455, 6454, 6404, 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, 5837, 5819, 5818, 5817, 5812, 5562, 5560, 5559, 5558, 5557, 5556, 5523, 5503, 5502, 5501, 5498, 5463, 5456, 5443, 5442, 5441, 5440, 5439, 5435, 5434, 5433, 5295, 5261, 5260, 5259, 5258, 5257, 5254, 5253, 5252, 5251, 5250, 5249, 5248, 5244, 5243, 5242, 5191, 5190, 5189, 5176, 5115, 5073, 4994, 4991, 4990, 4905, 4904, 4890, 4889, 4888, 4864, 4833, 4832, 4831, 4684, 4679, 4642, 4635, 4478, 4467, 4443, 4429, 4394, 4393, 4392, 4391, 4390, 4369, 4345, 4313, 4312, 4311, 4267, 4266, 4265, 4264, 4263, 4206, 4204, 4181, 4125, 4124, 4100, 4099, 4098, 4087, 4085, 4075, 4074, 4073, 4072, 4070, 4069, 4051, 4045, 4044, 4043, 4006, 4005, 4004, 3992, 3991, 3990, 3982, 3895, 3847, 3813, 3758, 3757, 3756, 3494, 3493, 3492, 3491, 3490, 3489, 3488, 3281, 3279, 3278, 3086, 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
-
-
-
-
-
Giá thường:
250.000 ₫
Special Price
175.000 ₫
5500
-
Giá thường:
120.000 ₫
Special Price
84.000 ₫
5499