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(588, 697, 968, 1115, 1275, 1281, 1605, 1612, 1617, 1967, 2038, 2039, 2040, 2122, 2124, 2125, 2287, 2331, 2332, 2334, 2377, 2379, 2380, 2381, 2382, 2384, 2391, 2392, 2393, 2394, 2395, 2530, 2721, 2838, 2839, 2850, 2851, 2940, 2941, 2972, 2975, 2976, 2977, 2978, 2979, 2980, 2981, 2992, 3204, 3205, 3206, 3207, 3208, 3209, 3210, 3215, 3216, 3395, 3396, 3397, 3404, 3409, 3410, 3411, 3412, 3413, 3414, 3415, 3416, 3543, 3572, 3573, 3574, 3577, 3578, 3588, 3589, 3681, 3682, 3683, 3684, 3685, 3698, 3699, 3711, 3717, 3718, 3719, 3720, 3841, 3842, 3908, 3909, 3944, 3945, 3977, 3978, 3979, 3980, 3981, 3987, 4289, 4290, 4291, 4292, 4309, 4310, 4311, 4312, 4313, 4429, 4453, 4454, 4455, 4456, 4457, 4467, 4535, 4636, 4637, 4638, 4639, 4842, 4843, 4845, 4989, 4990, 4991, 4992, 4993, 4994, 4999, 5073, 5234, 5235, 5236, 5237, 5516, 5517, 5518, 5519, 5520, 5521, 5522)) ORDER BY FIELD(`e`.`entity_id`, 4993, 4992, 4989, 4639, 4638, 4310, 4309, 3908, 3842, 3841, 3720, 3719, 3718, 3711, 3681, 3413, 3412, 3410, 3409, 3215, 3208, 3207, 3205, 2976, 2941, 2721, 2395, 2391, 1617, 1115, 5522, 5521, 5520, 5519, 5518, 5517, 5516, 5237, 5236, 5235, 5234, 5073, 4999, 4994, 4991, 4990, 4845, 4843, 4842, 4637, 4636, 4535, 4467, 4457, 4456, 4455, 4454, 4453, 4429, 4313, 4312, 4311, 4292, 4291, 4290, 4289, 3987, 3981, 3980, 3979, 3978, 3977, 3945, 3944, 3909, 3717, 3699, 3698, 3685, 3684, 3683, 3682, 3589, 3588, 3578, 3577, 3574, 3573, 3572, 3543, 3416, 3415, 3414, 3411, 3404, 3397, 3396, 3395, 3216, 3210, 3209, 3206, 3204, 2992, 2981, 2980, 2979, 2978, 2977, 2975, 2972, 2940, 2851, 2850, 2839, 2838, 2530, 2394, 2393, 2392, 2384, 2382, 2381, 2380, 2379, 2377, 2334, 2332, 2331, 2287, 2125, 2124, 2122, 2040, 2039, 2038, 1967, 1612, 1605, 1281, 1275, 968, 697, 588) ASC, `stock`.`stock_status` desc, `e`.`created_at` desc LIMIT 36
-
Giá thường:
260.000 ₫
Special Price
132.000 ₫
4989
-
Giá thường:
250.000 ₫
Special Price
190.000 ₫
4638
-
Giá thường:
160.000 ₫
Special Price
98.000 ₫
4309
-
Giá thường:
200.000 ₫
Special Price
140.000 ₫
3711
-
-
Giá thường:
450.000 ₫
Special Price
315.000 ₫
3412
-
-
Giá thường:
170.000 ₫
Special Price
119.000 ₫
3215
-
-
-
-
-
Giá thường:
320.000 ₫
Special Price
224.000 ₫
2391
-
-
-
-
-
-
-
-
-
-
-
-
-
Giá thường:
380.000 ₫
Special Price
340.000 ₫
5234
-
Giá thường:
240.000 ₫
Special Price
168.000 ₫
5073
-
Giá thường:
160.000 ₫
Special Price
68.600 ₫
4999
-
Giá thường:
260.000 ₫
Special Price
220.000 ₫
4994
-
Giá thường:
260.000 ₫
Special Price
220.000 ₫
4991
-
Giá thường:
260.000 ₫
Special Price
220.000 ₫
4990
-
Giá thường:
350.000 ₫
Special Price
203.000 ₫
4845
-
Giá thường:
250.000 ₫
Special Price
175.000 ₫
4843
-
Giá thường:
320.000 ₫
Special Price
224.000 ₫
4842
-
Giá thường:
350.000 ₫
Special Price
190.000 ₫
4637
-
Giá thường:
250.000 ₫
Special Price
190.000 ₫
4636