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(968, 1115, 1967, 2038, 2039, 2040, 2355, 2530, 2940, 2941, 2972, 2975, 2976, 2977, 2978, 2979, 2980, 2981, 2995, 2996, 3397, 3412, 3413, 3414, 3698, 3841, 3842, 3844, 3851, 3947, 3948, 3949, 3977, 3978, 3980, 3981, 4027, 4093, 4289, 4290, 4291, 4292, 4453, 4535, 4653, 4770, 4771, 4772, 4831, 4832, 4833, 4849, 4850, 4851, 4852, 5108, 5168, 5234, 5235, 5236, 5237, 5516, 5517, 5518, 5519, 5520, 5521, 5522, 5596, 5687, 5721, 5722, 5723, 5724, 6040, 6041, 6156, 6743, 6814, 6849, 6850, 6934, 6935, 6936, 6937, 6938, 6939, 6940, 6941, 6954, 6955, 6957, 6962, 6989)) ORDER BY FIELD(`e`.`entity_id`, 6989, 6962, 6957, 6955, 6954, 6941, 6940, 6939, 6938, 6937, 6936, 6935, 6934, 6850, 6849, 6814, 6743, 6156, 6041, 5724, 5723, 5722, 5721, 5687, 5596, 4851, 4850, 4849, 4653, 4093, 4027, 3842, 3841, 3413, 3412, 2976, 2941, 1115, 6040, 5522, 5521, 5520, 5519, 5518, 5517, 5516, 5237, 5236, 5235, 5234, 5168, 5108, 4852, 4833, 4832, 4831, 4772, 4771, 4770, 4535, 4453, 4292, 4291, 4290, 4289, 3981, 3980, 3978, 3977, 3949, 3948, 3947, 3851, 3844, 3698, 3414, 3397, 2996, 2995, 2981, 2980, 2979, 2978, 2977, 2975, 2972, 2940, 2530, 2355, 2040, 2039, 2038, 1967, 968) ASC, `stock`.`stock_status` desc, `e`.`created_at` desc LIMIT 36
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Giá thường:
290.000 ₫
Special Price
250.000 ₫
5687
-
-
Giá thường:
290.000 ₫
Special Price
176.000 ₫
4849
-
Giá thường:
340.000 ₫
Special Price
260.000 ₫
4653
-
Giá thường:
290.000 ₫
Special Price
250.000 ₫
4093
-
Giá thường:
340.000 ₫
Special Price
260.000 ₫
4027
-
Giá thường:
450.000 ₫
Special Price
315.000 ₫
3412
-
-
-
-
-
-
-
-
-
-
-
-
-
Giá thường:
380.000 ₫
Special Price
340.000 ₫
5234
-