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(1694, 1785, 1788, 1798, 1831, 3032, 3033, 3036, 3709, 4161, 4162, 4196, 4690, 4865, 4867, 5051, 5298, 6020, 6021, 6022, 6029, 6030, 6031, 6032, 6044, 6045, 6046, 6047, 6050, 6082, 6083, 6084, 6085, 6086, 6087, 6366, 6636, 6793)) ORDER BY FIELD(`e`.`entity_id`, 6793, 6366, 6087, 6086, 6083, 6082, 6022, 6020, 5298, 5051, 4690, 4162, 4161, 3036, 3032, 1798, 1788, 1785, 1694, 6636, 6085, 6084, 6050, 6047, 6046, 6045, 6044, 6032, 6031, 6030, 6029, 6021, 4867, 4865, 4196, 3709, 3033, 1831) ASC, `stock`.`stock_status` desc, `e`.`created_at` desc LIMIT 36
-
-
-
Giá thường:
50.000 ₫
Special Price
42.000 ₫
6082
-
-
-
Giá thường:
105.000 ₫
Special Price
50.000 ₫
5298
-
Giá thường:
260.000 ₫
Special Price
220.000 ₫
5051
-
-
Giá thường:
90.000 ₫
Special Price
35.000 ₫
4162
-
Giá thường:
90.000 ₫
Special Price
40.000 ₫
4161
-
-
-
-
Giá thường:
120.000 ₫
Special Price
84.000 ₫
1694
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Giá thường:
140.000 ₫
Special Price
60.000 ₫
4867
-
Giá thường:
80.000 ₫
Special Price
45.000 ₫
4865
-
-
-
-