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(968, 1115, 1967, 2038, 2039, 2040, 2355, 2530, 2940, 2941, 2972, 2975, 2976, 2977, 2978, 2979, 2980, 2981, 3397, 3412, 3413, 3414, 3698, 3841, 3842, 3844, 3947, 3948, 3949, 3977, 3978, 3980, 3981, 4027, 4289, 4290, 4291, 4292, 4453, 4535, 4653, 4849, 4850, 4851, 4852, 5168, 5234, 5235, 5236, 5237, 5516, 5517, 5518, 5519, 5520, 5521, 5522, 6156)) ORDER BY FIELD(`e`.`entity_id`, 6156, 4851, 4850, 4849, 4653, 4027, 3842, 3841, 3413, 3412, 2976, 2941, 1115, 5522, 5521, 5520, 5519, 5518, 5517, 5516, 5237, 5236, 5235, 5234, 5168, 4852, 4535, 4453, 4292, 4291, 4290, 4289, 3981, 3980, 3978, 3977, 3949, 3948, 3947, 3844, 3698, 3414, 3397, 2981, 2980, 2979, 2978, 2977, 2975, 2972, 2940, 2530, 2355, 2040, 2039, 2038, 1967, 968) ASC, `stock`.`stock_status` desc, `e`.`created_at` desc LIMIT 36
-
-
Giá thường:
290.000 ₫
Special Price
176.000 ₫
4849
-
Giá thường:
340.000 ₫
Special Price
260.000 ₫
4653
-
Giá thường:
340.000 ₫
Special Price
260.000 ₫
4027
-
Giá thường:
450.000 ₫
Special Price
315.000 ₫
3412
-
-
-
-
-
-
-
-
-
-
-
-
Giá thường:
380.000 ₫
Special Price
340.000 ₫
5234
-
-
-
Giá thường:
400.000 ₫
Special Price
380.000 ₫
4535
-
-
-
Giá thường:
300.000 ₫
Special Price
280.000 ₫
4291
-
Giá thường:
300.000 ₫
Special Price
280.000 ₫
4290
-
Giá thường:
300.000 ₫
Special Price
280.000 ₫
4289
-
-
-
Giá thường:
395.000 ₫
Special Price
276.500 ₫
3978
-
-
Giá thường:
695.000 ₫
Special Price
590.000 ₫
3949
-
Giá thường:
795.000 ₫
Special Price
675.000 ₫
3948
-
Giá thường:
890.000 ₫
Special Price
756.000 ₫
3947
-
-
-
Giá thường:
340.000 ₫
Special Price
238.000 ₫
3397
-