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(558, 561, 562, 588, 699, 1276, 1676, 1932, 1967, 2042, 2059, 2061, 2062, 2063, 2064, 2065, 2139, 2141, 2142, 2145, 2146, 2147, 2148, 2151, 2153, 2159, 2160, 2163, 2175, 2181, 2183, 2184, 2190, 2191, 2198, 2199, 2200, 2205, 2216, 2217, 2218, 2219, 2223, 2231, 2240, 2245, 2371, 2373, 2375, 2467, 2468, 2470, 2471, 2472, 2473, 2474, 2479, 2481, 2483, 2484, 2487, 2490, 2491, 2492, 2493, 2494, 2495, 2496, 2497, 2498, 2503, 2504, 2508, 2530, 2554, 2559, 2560, 2561, 2563, 2588, 2589, 2601, 2602, 2603, 2604, 2615, 2616, 2617, 2674, 2675, 2676, 2696, 2710, 2711, 2796, 2832, 2833, 2864, 2865, 2866, 2867, 2868, 2931, 2940, 2941, 2967, 2968, 2969, 2998, 3161, 3190, 3191, 3192, 3193, 3194, 3195, 3196, 3197, 3198, 3199, 3200, 3202, 3205, 3207, 3210, 3215, 3228, 3324, 3325, 3374, 3392, 3393, 3407, 3469, 3470, 3471, 3490, 3496, 3539, 3540, 3542, 3544, 3547, 3592, 3593, 3674, 3676, 3677, 3678, 3679, 3680, 3710, 3715, 3725, 3733, 3734, 3735, 3736, 3737, 3738, 3765, 3766, 3767, 3768, 3879, 3980, 3982, 3984, 3985, 3987, 3988, 3994, 4061, 4064, 4095, 4189, 4190, 4191, 4192, 4194, 4195, 4201, 4274, 4275, 4276, 4281, 4290, 4297, 4321, 4363, 4368, 4440, 4441, 4442, 4468, 4469, 4470, 4471, 4472, 4548, 4549, 4550, 4551, 4730, 4774, 4785, 4835, 4836, 4837, 4841, 4845, 5080, 5285, 5351, 5352, 5353, 5385, 5386, 5387, 5392, 5393, 5395, 5430, 5459, 5495, 5496, 5497, 5539, 5540, 5541, 5586, 5589, 5590, 5591, 5592, 5599, 5600, 5603, 5612, 5619, 5692, 5695, 5703, 5708, 5709, 5734, 5735, 5736, 5760, 5761, 5867, 5868, 6206, 6207, 6208, 6209, 6212, 6213, 6214, 6322, 6358, 6605, 6606, 6612, 6613, 6614, 6637, 6638, 6639, 6640, 6641, 6642, 6643, 6644, 6645, 6646, 6647, 6741, 6759, 6786, 6873, 6875, 6889, 6890, 7001, 7012)) ORDER BY FIELD(`e`.`entity_id`, 7012, 7001, 6890, 6889, 6875, 6873, 6786, 6759, 6741, 6647, 6646, 6645, 6643, 6642, 6641, 6640, 6639, 6638, 6637, 6614, 6613, 6612, 6606, 6605, 6358, 6322, 6214, 6213, 6212, 6208, 6207, 6206, 5868, 5736, 5735, 5734, 5695, 5612, 5603, 5600, 5599, 5430, 5393, 5392, 5353, 5352, 5351, 4730, 4095, 3994, 3767, 3766, 3765, 3738, 3735, 3680, 3679, 3678, 3677, 3676, 3324, 3228, 3215, 3207, 3205, 2941, 2710, 2617, 2615, 2559, 2554, 2493, 2487, 2483, 2481, 2473, 2472, 2468, 2373, 2371, 2245, 2231, 2216, 2153, 2148, 2147, 2146, 2145, 2064, 2042, 1676, 562, 561, 558, 6644, 6209, 5867, 5761, 5760, 5709, 5708, 5703, 5692, 5619, 5592, 5591, 5590, 5589, 5586, 5541, 5540, 5539, 5497, 5496, 5495, 5459, 5395, 5387, 5386, 5385, 5285, 5080, 4845, 4841, 4837, 4836, 4835, 4785, 4774, 4551, 4550, 4549, 4548, 4472, 4471, 4470, 4469, 4468, 4442, 4441, 4440, 4368, 4363, 4321, 4297, 4290, 4281, 4276, 4275, 4274, 4201, 4195, 4194, 4192, 4191, 4190, 4189, 4064, 4061, 3988, 3987, 3985, 3984, 3982, 3980, 3879, 3768, 3737, 3736, 3734, 3733, 3725, 3715, 3710, 3674, 3593, 3592, 3547, 3544, 3542, 3540, 3539, 3496, 3490, 3471, 3470, 3469, 3407, 3393, 3392, 3374, 3325, 3210, 3202, 3200, 3199, 3198, 3197, 3196, 3195, 3194, 3193, 3192, 3191, 3190, 3161, 2998, 2969, 2968, 2967, 2940, 2931, 2868, 2867, 2866, 2865, 2864, 2833, 2832, 2796, 2711, 2696, 2676, 2675, 2674, 2616, 2604, 2603, 2602, 2601, 2589, 2588, 2563, 2561, 2560, 2530, 2508, 2504, 2503, 2498, 2497, 2496, 2495, 2494, 2492, 2491, 2490, 2484, 2479, 2474, 2471, 2470, 2467, 2375, 2240, 2223, 2219, 2218, 2217, 2205, 2200, 2199, 2198, 2191, 2190, 2184, 2183, 2181, 2175, 2163, 2160, 2159, 2151, 2142, 2141, 2139, 2065, 2063, 2062, 2061, 2059, 1967, 1932, 1276, 699, 588) ASC, `stock`.`stock_status` desc, `e`.`created_at` desc LIMIT 36
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Giá thường:
2.500.000 ₫
Special Price
2.180.000 ₫
5868
-
-
-
-
-
-
-
Từ:
136.000 ₫
Đến:
661.000 ₫
5393
-
-
-
-
-
-
-
-
-
Giá thường:
220.000 ₫
Special Price
154.000 ₫
3735
-
-
-
-
-