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(2449, 2452, 2457, 2458, 2460, 2461, 2463, 2464, 2824, 3109, 3258, 3261, 3262, 3294, 3299, 3301, 3308, 3314, 3322, 3323, 3328, 3331, 3332, 3435, 3437, 3445, 3709, 4109, 4261, 4403, 4404, 4405, 4406, 4412, 4417, 4418, 4597, 4609, 4818, 4879, 4906, 4907, 4908, 4909, 4910, 4911, 4912, 4913, 4914, 5000, 5035, 5036, 5037, 5038, 5043, 5047, 5071, 5104, 5105, 5106, 5107, 5202, 5203, 5204, 5205, 5300, 5516, 5581, 5582, 5583, 5584, 5585, 5586, 5946, 5947, 5948, 5949, 5950, 6021, 6734, 6735, 6736, 6737, 6897, 6898, 6900, 6901, 6906)) ORDER BY FIELD(`e`.`entity_id`, 6906, 6901, 6900, 6898, 6897, 5585, 5584, 5583, 5582, 5581, 5204, 5203, 5202, 5043, 5038, 5037, 5036, 4911, 4910, 4909, 4908, 4907, 4906, 4418, 4412, 4109, 3314, 3262, 3261, 3258, 2464, 2463, 2461, 2452, 6737, 6736, 6735, 6734, 6021, 5950, 5949, 5948, 5947, 5946, 5586, 5516, 5300, 5205, 5107, 5106, 5105, 5104, 5071, 5047, 5035, 5000, 4914, 4913, 4912, 4879, 4818, 4609, 4597, 4417, 4406, 4405, 4404, 4403, 4261, 3709, 3445, 3437, 3435, 3332, 3331, 3328, 3323, 3322, 3308, 3301, 3299, 3294, 3109, 2824, 2460, 2458, 2457, 2449) ASC, `stock`.`stock_status` desc, `e`.`created_at` desc LIMIT 36
-
-
-
-
Giá thường:
140.000 ₫
Special Price
98.000 ₫
5202
-
Giá thường:
280.000 ₫
Special Price
120.000 ₫
5043
-
Giá thường:
380.000 ₫
Special Price
145.000 ₫
5036
-
-
-
Giá thường:
200.000 ₫
Special Price
180.000 ₫
4412
-
Giá thường:
250.000 ₫
Special Price
180.000 ₫
4109
-
-
Giá thường:
180.000 ₫
Special Price
126.000 ₫
3262
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Giá thường:
230.000 ₫
Special Price
180.000 ₫
5300
-
Giá thường:
140.000 ₫
Special Price
98.000 ₫
5205
-
Giá thường:
340.000 ₫
Special Price
238.000 ₫
5107
-
Giá thường:
340.000 ₫
Special Price
238.000 ₫
5106
-
Giá thường:
340.000 ₫
Special Price
238.000 ₫
5105
-
Giá thường:
340.000 ₫
Special Price
238.000 ₫
5104
-
-
Giá thường:
250.000 ₫
Special Price
180.000 ₫
5047
-
-
-
Giá thường:
340.000 ₫
Special Price
240.000 ₫
4914