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(2360, 2361, 2362, 2363, 2802, 2803, 3298, 3303, 3354, 3357, 3358, 3499, 3726, 3727, 3728, 3729, 3730, 3731, 3732, 4189, 4190, 4191, 4192, 4194, 4195, 4220, 4221, 4222, 4223, 4540, 4556, 4594, 4847, 4849, 4850, 4851, 4852, 5129, 5130, 5131, 5134, 5313, 5319, 5425, 5444, 5445, 5575, 6380, 6446, 6447, 6448, 6449, 6450, 6451, 6929, 6930, 6931, 6988)) ORDER BY FIELD(`e`.`entity_id`, 6988, 6931, 6930, 6929, 6451, 6450, 6449, 6448, 6447, 6446, 6380, 5575, 5445, 5425, 5130, 5129, 4851, 4850, 4849, 4556, 4540, 3731, 3730, 3729, 3726, 3358, 3354, 5444, 5319, 5313, 5134, 5131, 4852, 4847, 4594, 4223, 4222, 4221, 4220, 4195, 4194, 4192, 4191, 4190, 4189, 3732, 3728, 3727, 3499, 3357, 3303, 3298, 2803, 2802, 2363, 2362, 2361, 2360) ASC, `stock`.`stock_status` desc, `e`.`created_at` desc LIMIT 36
-
-
-
-
-
-
-
-
Giá thường:
250.000 ₫
Special Price
190.000 ₫
5129
-
Giá thường:
290.000 ₫
Special Price
176.000 ₫
4849
-
Giá thường:
200.000 ₫
Special Price
180.000 ₫
4556
-
Giá thường:
180.000 ₫
Special Price
160.000 ₫
4540
-
Giá thường:
220.000 ₫
Special Price
77.000 ₫
3726
-
-
-
-
Giá thường:
250.000 ₫
Special Price
220.000 ₫
5313
-
-
-
-
Giá thường:
180.000 ₫
Special Price
126.000 ₫
4847
-
Giá thường:
160.000 ₫
Special Price
98.000 ₫
4594
-
Giá thường:
320.000 ₫
Special Price
200.000 ₫
4223
-
Giá thường:
320.000 ₫
Special Price
200.000 ₫
4222
-
Giá thường:
320.000 ₫
Special Price
200.000 ₫
4221
-
Giá thường:
320.000 ₫
Special Price
200.000 ₫
4220
-
-
-
-
-
-
-
-
-
-
Giá thường:
320.000 ₫
Special Price
180.000 ₫
3499
-