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(546, 936, 1591, 2449, 2452, 2457, 2458, 2460, 2461, 2463, 2464, 2824, 2841, 2842, 2843, 2845, 2846, 2847, 2898, 2899, 2900, 2901, 2902, 2903, 2904, 3109, 3258, 3261, 3262, 3294, 3299, 3301, 3308, 3314, 3322, 3323, 3328, 3331, 3332, 3422, 3435, 3437, 3445, 3525, 3531, 3532, 3623, 3709, 3764, 4106, 4109, 4139, 4140, 4141, 4186, 4244, 4246, 4261, 4283, 4284, 4285, 4326, 4327, 4328, 4329, 4359, 4403, 4404, 4405, 4406, 4412, 4417, 4418, 4430, 4431, 4432, 4433, 4520, 4521, 4522, 4523, 4597, 4602, 4603, 4604, 4605, 4609, 4653, 4815, 4818, 4826, 4838, 4839, 4847, 4849, 4850, 4851, 4852, 4879, 4906, 4907, 4908, 4909, 4910, 4911, 4912, 4913, 4914, 4978, 5000, 5002, 5003, 5035, 5036, 5037, 5038, 5043, 5047, 5062, 5063, 5064, 5065, 5071, 5104, 5105, 5106, 5107, 5116, 5136, 5138, 5169, 5202, 5203, 5204, 5205, 5211, 5212, 5225, 5238, 5242, 5246, 5285, 5299, 5300, 5330, 5421, 5426, 5429, 5439, 5440, 5441, 5442, 5443, 5516, 5517, 5518, 5519, 5520, 5521, 5522, 5538, 5581, 5582, 5583, 5584, 5585, 5586, 5631, 5632, 5946, 5947, 5948, 5949, 5950, 6021, 6023, 6200, 6206, 6207, 6208, 6209, 6212, 6213, 6214, 6268, 6357, 6358, 6359, 6360, 6445, 6734, 6735, 6736, 6737, 6741, 6743, 6774, 6897, 6898, 6900, 6901, 6906, 6946, 6954, 6989, 6991, 6992, 6993)) ORDER BY FIELD(`e`.`entity_id`, 6954, 6906, 6901, 6900, 6898, 6897, 6214, 6213, 6212, 6208, 6207, 6023, 5585, 5584, 5583, 5582, 5581, 5426, 5421, 5238, 5225, 5204, 5203, 5202, 5038, 5037, 5036, 4911, 4910, 4909, 4908, 4907, 4906, 4849, 4109, 3262, 3261, 2464, 2463, 2461, 2452, 6993, 6992, 6991, 6989, 6946, 6774, 6743, 6741, 6360, 6359, 6358, 6357, 6206, 6200, 5043, 5003, 5002, 4851, 4850, 4653, 4433, 4430, 4418, 4412, 4285, 4284, 4283, 4141, 4140, 4139, 4106, 3314, 3258, 2845, 2841, 1591, 936, 546, 6737, 6736, 6735, 6734, 6445, 6268, 6209, 6021, 5950, 5949, 5948, 5947, 5946, 5632, 5631, 5586, 5538, 5522, 5521, 5520, 5519, 5518, 5517, 5516, 5443, 5442, 5441, 5440, 5439, 5429, 5330, 5300, 5299, 5285, 5246, 5242, 5212, 5211, 5205, 5169, 5138, 5136, 5116, 5107, 5106, 5105, 5104, 5071, 5065, 5064, 5063, 5062, 5047, 5035, 5000, 4978, 4914, 4913, 4912, 4879, 4852, 4847, 4839, 4838, 4826, 4818, 4815, 4609, 4605, 4604, 4603, 4602, 4597, 4523, 4522, 4521, 4520, 4432, 4431, 4417, 4406, 4405, 4404, 4403, 4359, 4329, 4328, 4327, 4326, 4261, 4246, 4244, 4186, 3764, 3709, 3623, 3532, 3531, 3525, 3445, 3437, 3435, 3422, 3332, 3331, 3328, 3323, 3322, 3308, 3301, 3299, 3294, 3109, 2904, 2903, 2902, 2901, 2900, 2899, 2898, 2847, 2846, 2843, 2842, 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:
380.000 ₫
Special Price
145.000 ₫
5036
-
-
-
Giá thường:
290.000 ₫
Special Price
176.000 ₫
4849
-
Giá thường:
250.000 ₫
Special Price
180.000 ₫
4109
-
Giá thường:
180.000 ₫
Special Price
126.000 ₫
3262
-
-
-
-
-
-
-
-
-
-
-
Giá thường:
280.000 ₫
Special Price
120.000 ₫
5043
-
Giá thường:
220.000 ₫
Special Price
126.000 ₫
5003
-
Giá thường:
250.000 ₫
Special Price
98.000 ₫
5002
-
Giá thường:
340.000 ₫
Special Price
260.000 ₫
4653
-
-
Giá thường:
200.000 ₫
Special Price
180.000 ₫
4412
-
-
-