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, 699, 1276, 1676, 1685, 1788, 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, 2413, 2414, 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, 2812, 2813, 2816, 2818, 2832, 2833, 2864, 2865, 2866, 2867, 2868, 2915, 2926, 2931, 2940, 2941, 2967, 2968, 2969, 2998, 3190, 3191, 3192, 3193, 3194, 3195, 3196, 3197, 3198, 3199, 3200, 3202, 3205, 3207, 3210, 3215, 3228, 3237, 3238, 3324, 3325, 3353, 3354, 3357, 3358, 3359, 3360, 3361, 3364, 3392, 3393, 3407, 3432, 3433, 3434, 3445, 3469, 3470, 3471, 3539, 3540, 3542, 3544, 3547, 3582, 3592, 3593, 3643, 3674, 3715, 3725, 3733, 3734, 3735, 3736, 3737, 3738, 3764, 3850, 3879, 3889, 3920, 3936, 3980, 3982, 3984, 3985, 3987, 3988, 3994, 4040, 4041, 4042, 4061, 4189, 4190, 4191, 4192, 4194, 4195, 4201, 4255, 4274, 4275, 4276, 4281, 4290, 4321, 4363, 4368, 4449, 4450, 4451, 4452, 4468, 4469, 4470, 4471, 4472, 4548, 4549, 4550, 4551, 4553, 4556, 4596, 4641, 4713, 4835, 4836, 4837, 4841, 4845, 4856, 4857, 4936, 5080, 5122, 5204, 5228, 5294, 5302, 5303, 5338, 5351, 5352, 5353, 5383, 5385, 5386, 5387, 5392, 5393, 5395, 5440, 5447, 5462, 5463, 5468, 5484, 5586, 5607, 5608, 5609, 5610, 5703, 5708, 5709, 5734, 5735, 5736, 5760, 5761, 5762, 5855, 5856, 5874, 5920, 5999, 6002, 6003, 6019, 6035, 6053, 6181, 6206, 6207, 6208, 6209, 6210, 6212, 6213, 6214, 6310, 6322, 6356, 6358, 6395, 6396, 6551, 6605, 6606, 6612, 6613, 6614, 6710, 6740, 6786, 6807, 6811, 6823, 6889, 6890, 6913, 6994, 6995, 6996, 7001, 7012, 7035)) ORDER BY FIELD(`e`.`entity_id`, 6356, 5609, 7035, 7012, 7001, 6996, 6995, 6994, 6913, 6890, 6889, 6823, 6786, 6614, 6613, 6612, 6606, 6605, 6551, 6396, 6395, 6358, 6322, 6310, 6214, 6213, 6212, 6208, 6207, 6206, 6035, 6019, 6002, 5920, 5736, 5735, 5734, 5607, 5393, 5392, 5353, 5352, 5351, 5228, 5204, 4936, 4641, 4556, 4553, 3994, 3738, 3735, 3582, 3358, 3354, 3324, 3228, 3215, 3207, 3205, 2941, 2915, 2710, 2617, 2615, 2559, 2554, 2493, 2487, 2483, 2481, 2473, 2472, 2468, 2373, 2371, 2245, 2231, 2216, 2153, 2148, 2147, 2146, 2145, 2064, 2042, 1788, 1685, 1676, 6811, 6807, 6740, 6710, 6210, 6209, 6181, 6053, 6003, 5999, 5874, 5856, 5855, 5762, 5761, 5760, 5709, 5708, 5703, 5610, 5608, 5586, 5484, 5468, 5463, 5462, 5447, 5440, 5395, 5387, 5386, 5385, 5383, 5338, 5303, 5302, 5294, 5122, 5080, 4857, 4856, 4845, 4841, 4837, 4836, 4835, 4713, 4596, 4551, 4550, 4549, 4548, 4472, 4471, 4470, 4469, 4468, 4452, 4451, 4450, 4449, 4368, 4363, 4321, 4290, 4281, 4276, 4275, 4274, 4255, 4201, 4195, 4194, 4192, 4191, 4190, 4189, 4061, 4042, 4041, 4040, 3988, 3987, 3985, 3984, 3982, 3980, 3936, 3920, 3889, 3879, 3850, 3764, 3737, 3736, 3734, 3733, 3725, 3715, 3674, 3643, 3593, 3592, 3547, 3544, 3542, 3540, 3539, 3471, 3470, 3469, 3445, 3434, 3433, 3432, 3407, 3393, 3392, 3364, 3361, 3360, 3359, 3357, 3353, 3325, 3238, 3237, 3210, 3202, 3200, 3199, 3198, 3197, 3196, 3195, 3194, 3193, 3192, 3191, 3190, 2998, 2969, 2968, 2967, 2940, 2931, 2926, 2868, 2867, 2866, 2865, 2864, 2833, 2832, 2818, 2816, 2813, 2812, 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, 2414, 2413, 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:
480.000 ₫
Special Price
380.000 ₫
6019
-
-
-
-
-
Từ:
136.000 ₫
Đến:
661.000 ₫
5393
-
-
-
-
-
-
Giá thường:
120.000 ₫
Special Price
60.000 ₫
4936
-
Giá thường:
200.000 ₫
Special Price
180.000 ₫
4556
-
Giá thường:
200.000 ₫
Special Price
180.000 ₫
4553
-
-
Giá thường:
220.000 ₫
Special Price
154.000 ₫
3735
-
-