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(593, 594, 683, 1094, 1270, 1275, 1299, 1591, 1597, 1605, 1612, 1617, 1634, 1759, 2025, 2085, 2086, 2092, 2093, 2094, 2095, 2096, 2097, 2098, 2099, 2100, 2101, 2111, 2113, 2114, 2116, 2118, 2120, 2121, 2122, 2124, 2125, 2151, 2153, 2159, 2160, 2251, 2252, 2253, 2254, 2255, 2256, 2257, 2258, 2259, 2260, 2261, 2262, 2263, 2528, 2563, 2569, 2570, 2571, 2572, 2615, 2616, 2617, 2696, 2850, 2851, 2995, 2996, 2998, 3204, 3206, 3207, 3208, 3209, 3210, 3214, 3215, 3216, 3217, 3283, 3324, 3325, 3336, 3337, 3338, 3341, 3364, 3395, 3533, 3534, 3536, 3537, 3539, 3540, 3542, 3547, 3619, 3642, 3681, 3682, 3683, 3684, 3700, 3711, 3719, 3720, 3756, 3757, 3758, 3850, 3851, 3856, 3889, 3895, 3922, 3923, 3924, 3958, 3959, 4000, 4001, 4002, 4014, 4016, 4019, 4020, 4025, 4037, 4038, 4053, 4069, 4098, 4099, 4100, 4114, 4176, 4218, 4244, 4245, 4302, 4303, 4304, 4361, 4381, 4382, 4383, 4384, 4385, 4386, 4424, 4425, 4426, 4427, 4428, 4439, 4463, 4465, 4478, 4524, 4525, 4526, 4527, 4553, 4554, 4555, 4556, 4557, 4558, 4628, 4629, 4630, 4640, 4641, 4671, 4672, 4700, 4712, 4789, 4838, 4849, 4850, 4851, 4852, 4853, 4888, 4889, 4890, 4921, 4931, 4932, 4939, 4942, 4943, 4944, 4968, 4981, 5032, 5048, 5120, 5123, 5143, 5153, 5157, 5158, 5159, 5189, 5194, 5195, 5196, 5197, 5198, 5209, 5300, 5459, 5461, 5474, 5485, 5486, 5498, 5505, 5534, 5550, 5551, 5552, 5563, 5564, 5647, 5648, 5649, 5650, 5652, 5663, 5664, 5665, 5666, 5703, 5708, 5709, 5714, 5715, 5737, 5738, 5739, 5740, 5743, 5744, 5745, 5746, 5753, 5759, 5792, 5793, 5794, 5799, 5807, 5821, 5822, 5823, 5824, 5828, 5843, 5844, 5845, 5846, 5847, 5848, 5849, 5850, 5851, 5852, 5853, 5854, 5891, 5892, 5893, 5894, 5895, 6024, 6130, 6131, 6132, 6133, 6179, 6206, 6207, 6208, 6209, 6224, 6273, 6274, 6275, 6276, 6278, 6279, 6280, 6306, 6307, 6427, 6430, 6445, 6446, 6459, 6492, 6493, 6494, 6495, 6681, 6682, 6683, 6751, 6752, 6753, 6769, 6774, 6793, 6815, 6816, 6817, 6914, 6915, 6916, 6917, 6981, 6982, 6983, 6984, 6985, 6986, 6987)) ORDER BY FIELD(`e`.`entity_id`, 6987, 6986, 6985, 6984, 6983, 6982, 6981, 6917, 6916, 6915, 6914, 6817, 6815, 6793, 6774, 6769, 6753, 6752, 6751, 6495, 6494, 6493, 6492, 6446, 6430, 6427, 6307, 6306, 6276, 6274, 6273, 6224, 6208, 6207, 6206, 6133, 6132, 6131, 5895, 5894, 5893, 5892, 5891, 5853, 5851, 5845, 5843, 5828, 5759, 5715, 5714, 5666, 5665, 5664, 5663, 5648, 5647, 5564, 5563, 5534, 5498, 5474, 5461, 5209, 5048, 5032, 4851, 4850, 4849, 4789, 4641, 4640, 4556, 4555, 4553, 4465, 4425, 4424, 4385, 4384, 4382, 4381, 4176, 4114, 4002, 4001, 3720, 3719, 3711, 3681, 3619, 3536, 3324, 3217, 3215, 3208, 3207, 2617, 2615, 2252, 2251, 2153, 2096, 2095, 1634, 1617, 1597, 1591, 1299, 1094, 683, 594, 593, 6816, 6683, 6682, 6681, 6459, 6445, 6280, 6279, 6278, 6275, 6209, 6179, 6130, 6024, 5854, 5852, 5850, 5849, 5848, 5847, 5846, 5844, 5824, 5823, 5822, 5821, 5807, 5799, 5794, 5793, 5792, 5753, 5746, 5745, 5744, 5743, 5740, 5739, 5738, 5737, 5709, 5708, 5703, 5652, 5650, 5649, 5552, 5551, 5550, 5505, 5486, 5485, 5459, 5300, 5198, 5197, 5196, 5195, 5194, 5189, 5159, 5158, 5157, 5153, 5143, 5123, 5120, 4981, 4968, 4944, 4943, 4942, 4939, 4932, 4931, 4921, 4890, 4889, 4888, 4853, 4852, 4838, 4712, 4700, 4672, 4671, 4630, 4629, 4628, 4558, 4557, 4554, 4527, 4526, 4525, 4524, 4478, 4463, 4439, 4428, 4427, 4426, 4386, 4383, 4361, 4304, 4303, 4302, 4245, 4244, 4218, 4100, 4099, 4098, 4069, 4053, 4038, 4037, 4025, 4020, 4019, 4016, 4014, 4000, 3959, 3958, 3924, 3923, 3922, 3895, 3889, 3856, 3851, 3850, 3758, 3757, 3756, 3700, 3684, 3683, 3682, 3642, 3547, 3542, 3540, 3539, 3537, 3534, 3533, 3395, 3364, 3341, 3338, 3337, 3336, 3325, 3283, 3216, 3214, 3210, 3209, 3206, 3204, 2998, 2996, 2995, 2851, 2850, 2696, 2616, 2572, 2571, 2570, 2569, 2563, 2528, 2263, 2262, 2261, 2260, 2259, 2258, 2257, 2256, 2255, 2254, 2253, 2160, 2159, 2151, 2125, 2124, 2122, 2121, 2120, 2118, 2116, 2114, 2113, 2111, 2101, 2100, 2099, 2098, 2097, 2094, 2093, 2092, 2086, 2085, 2025, 1759, 1612, 1605, 1275, 1270) ASC, `stock`.`stock_status` desc, `e`.`created_at` desc LIMIT 36
-
-
-
-
-
-
-
-
-
-
Giá thường:
520.000 ₫
Special Price
495.000 ₫
6430
-
-
Giá thường:
520.000 ₫
Special Price
495.000 ₫
6307
-
Giá thường:
520.000 ₫
Special Price
495.000 ₫
6306
-
-
-
-
-
-
-
-
-
-
-
-
Giá thường:
550.000 ₫
Special Price
395.000 ₫
5474
-
Giá thường:
1.680.000 ₫
Special Price
1.176.000 ₫
5461
-
-
Giá thường:
450.000 ₫
Special Price
224.000 ₫
5048
-
Giá thường:
350.000 ₫
Special Price
290.000 ₫
5032
-
Giá thường:
290.000 ₫
Special Price
176.000 ₫
4849
-
-
Giá thường:
200.000 ₫
Special Price
180.000 ₫
4556
-
Giá thường:
200.000 ₫
Special Price
180.000 ₫
4553
-
-
-