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(1729, 1734, 3439, 3440, 3441, 3443, 3444, 3447, 3448, 3538, 3609, 3775, 3958, 3959, 4188, 4201, 4202, 4213, 4293, 4295, 4296, 4297, 4298, 4299, 4300, 4301, 4351, 4379, 4380, 4460, 4594, 4595, 4596, 4671, 4699, 4700, 4847, 4929, 4930, 4931, 4932, 5085, 5086, 5087, 5088, 5089, 5090, 5091, 5092, 5094, 5095, 5096, 5122, 5135, 5136, 5138, 5142, 5143, 5147, 5150, 5151, 5152, 5154, 5155, 5156, 5172, 5211, 5213, 5331, 5468, 5469, 5470, 5471, 5477, 5478, 5479, 5480, 5482, 5491, 5492, 5493, 6281, 6284, 6310, 6944, 6946)) ORDER BY FIELD(`e`.`entity_id`, 6946, 6944, 6310, 5480, 5478, 5469, 5213, 4929, 4595, 6284, 6281, 5493, 5492, 5491, 5482, 5479, 5477, 5471, 5470, 5468, 5331, 5211, 5172, 5156, 5155, 5154, 5152, 5151, 5150, 5147, 5143, 5142, 5138, 5136, 5135, 5122, 5096, 5095, 5094, 5092, 5091, 5090, 5089, 5088, 5087, 5086, 5085, 4932, 4931, 4930, 4847, 4700, 4699, 4671, 4596, 4594, 4460, 4380, 4379, 4351, 4301, 4300, 4299, 4298, 4297, 4296, 4295, 4293, 4213, 4202, 4201, 4188, 3959, 3958, 3775, 3609, 3538, 3448, 3447, 3444, 3443, 3441, 3440, 3439, 1734, 1729) ASC, `stock`.`stock_status` desc, `e`.`created_at` desc LIMIT 36
-
-
-
Giá thường:
90.000 ₫
Special Price
75.000 ₫
5480
-
Giá thường:
95.000 ₫
Special Price
66.000 ₫
5478
-
-
-
Giá thường:
980.000 ₫
Special Price
588.000 ₫
4929
-
Giá thường:
400.000 ₫
Special Price
380.000 ₫
4595
-
-
-
Giá thường:
120.000 ₫
Special Price
84.000 ₫
5493
-
Giá thường:
490.000 ₫
Special Price
343.000 ₫
5492
-
-
Giá thường:
300.000 ₫
Special Price
260.000 ₫
5482
-
Giá thường:
250.000 ₫
Special Price
175.000 ₫
5479
-
-
Giá thường:
200.000 ₫
Special Price
140.000 ₫
5471
-
Giá thường:
140.000 ₫
Special Price
98.000 ₫
5470
-
-
Giá thường:
350.000 ₫
Special Price
290.000 ₫
5331
-
Giá thường:
250.000 ₫
Special Price
150.000 ₫
5211
-
Giá thường:
140.000 ₫
Special Price
110.000 ₫
5172
-
-
Giá thường:
180.000 ₫
Special Price
126.000 ₫
5155
-
Giá thường:
160.000 ₫
Special Price
110.000 ₫
5154
-
Giá thường:
260.000 ₫
Special Price
180.000 ₫
5152
-
-
-
-
-
-
-
-
-
-