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, 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, 2712, 2713, 2796, 2832, 2833, 2864, 2865, 2866, 2867, 2868, 2931, 2940, 2941, 2967, 2968, 2969, 2998, 3190, 3191, 3192, 3193, 3194, 3195, 3196, 3197, 3198, 3199, 3200, 3202, 3205, 3207, 3210, 3215, 3228, 3324, 3325, 3392, 3393, 3407, 3469, 3470, 3471, 3539, 3540, 3542, 3544, 3547, 3592, 3593, 3674, 3715, 3725, 3733, 3734, 3735, 3736, 3737, 3738, 3879, 3980, 3982, 3984, 3985, 3987, 3988, 3994, 4061, 4189, 4190, 4191, 4192, 4194, 4195, 4201, 4274, 4275, 4276, 4281, 4290, 4321, 4363, 4368, 4468, 4469, 4470, 4471, 4472, 4548, 4549, 4550, 4551, 4835, 4836, 4837, 4841, 4845, 5080, 5351, 5352, 5353, 5385, 5386, 5387, 5392, 5393, 5395, 5586, 5703, 5708, 5709, 5734, 5735, 5736, 6206, 6207, 6208, 6209, 6212, 6213, 6214, 6322, 6358, 6605, 6606, 6612, 6613, 6614, 6786, 6889, 6890, 7001, 7012)) ORDER BY FIELD(`e`.`entity_id`, 6890, 2493, 2487, 2481, 6322, 6208, 6207, 6206, 5393, 7001, 6614, 6613, 6612, 5736, 5735, 5734, 2710, 2483, 2042, 7012, 6889, 6786, 6606, 6605, 6358, 6214, 6213, 6212, 5586, 5392, 5353, 5352, 5351, 3994, 3738, 3735, 3324, 3228, 3215, 3207, 3205, 2941, 2712, 2617, 2615, 2559, 2554, 2473, 2472, 2468, 2373, 2371, 2245, 2231, 2216, 2153, 2148, 2147, 2146, 2145, 2064, 1676, 6209, 5709, 5708, 5703, 5395, 5387, 5386, 5385, 5080, 4845, 4841, 4837, 4836, 4835, 4551, 4550, 4549, 4548, 4472, 4471, 4470, 4469, 4468, 4368, 4363, 4321, 4290, 4281, 4276, 4275, 4274, 4201, 4195, 4194, 4192, 4191, 4190, 4189, 4061, 3988, 3987, 3985, 3984, 3982, 3980, 3879, 3737, 3736, 3734, 3733, 3725, 3715, 3674, 3593, 3592, 3547, 3544, 3542, 3540, 3539, 3471, 3470, 3469, 3407, 3393, 3392, 3325, 3210, 3202, 3200, 3199, 3198, 3197, 3196, 3195, 3194, 3193, 3192, 3191, 3190, 2998, 2969, 2968, 2967, 2940, 2931, 2868, 2867, 2866, 2865, 2864, 2833, 2832, 2796, 2713, 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:
470.000 ₫
Special Price
329.000 ₫
2487
-
-
Từ:
136.000 ₫
Đến:
661.000 ₫
5393
-
-
-
-
Giá thường:
1.500.000 ₫
Special Price
1.050.000 ₫
2710
-
Giá thường:
220.000 ₫
Special Price
154.000 ₫
2042
-
-
-
-
-
-
-
-
-
-
-
Giá thường:
220.000 ₫
Special Price
154.000 ₫
3735
-
Giá thường:
250.000 ₫
Special Price
160.000 ₫
3228
-
Giá thường:
170.000 ₫
Special Price
119.000 ₫
3215
-
-
-
Giá thường:
250.000 ₫
Special Price
175.000 ₫
2615
-
-
Giá thường:
110.000 ₫
Special Price
77.000 ₫
2371
-
-
Giá thường:
320.000 ₫
Special Price
224.000 ₫
2145
-
Giá thường:
200.000 ₫
Special Price
140.000 ₫
2064
-
-
Giá thường:
250.000 ₫
Special Price
168.000 ₫
5709
-
Giá thường:
250.000 ₫
Special Price
168.000 ₫
5708
-
Giá thường:
250.000 ₫
Special Price
168.000 ₫
5703
-
-