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(760, 1864, 3847, 4124, 4125, 4204, 4206, 4263, 4264, 4265, 4266, 4267, 4443, 4478, 4831, 4832, 4833, 4859, 4863, 4864, 5176, 5189, 5191, 5242, 5243, 5244, 5246, 5247, 5248, 5249, 5250, 5251, 5252, 5253, 5254, 5257, 5258, 5259, 5260, 5261, 5295, 5433, 5434, 5435, 5436, 5437, 5438, 5439, 5440, 5441, 5442, 5443, 5523, 5556, 5557, 5558, 5559, 5560, 5561, 5562, 5563, 5564, 5565, 5712, 5742, 5816, 5817, 5818, 5819, 5820, 6112, 6113, 6114, 6115, 6151, 6152, 6153, 6178, 6179, 6180, 6181, 6182, 6183, 6184, 6185, 6186, 6187, 6200, 6402, 6403, 6404, 6447, 6448, 6449, 6450, 6451, 6452, 6453, 6454, 6455, 6456, 6559, 6579, 6580, 6581, 6582, 6583, 6584, 6585, 6586, 6692, 6693, 6694, 6695, 6696, 6697, 6698, 6699, 6700, 6701, 6702, 6746, 6747, 6748, 6749, 6750, 6773, 6776, 6777, 6778, 6779, 6780, 6788, 6789, 6790, 6791, 6792, 6794, 6795)) ORDER BY FIELD(`e`.`entity_id`, 6795, 6794, 6792, 6791, 6790, 6789, 6788, 6780, 6779, 6778, 6777, 6776, 6773, 6750, 6749, 6748, 6747, 6746, 6702, 6701, 6699, 6698, 6697, 6696, 6695, 6694, 6693, 6692, 6586, 6585, 6584, 6583, 6582, 6581, 6580, 6579, 6559, 6453, 6452, 6451, 6450, 6449, 6448, 6447, 6403, 6402, 6200, 5820, 5816, 5742, 5712, 5565, 5564, 5563, 5561, 5438, 5437, 5436, 5247, 5246, 4863, 4859, 760, 6700, 6456, 6455, 6454, 6404, 6187, 6186, 6185, 6184, 6183, 6182, 6181, 6180, 6179, 6178, 6153, 6152, 6151, 6115, 6114, 6113, 6112, 5819, 5818, 5817, 5562, 5560, 5559, 5558, 5557, 5556, 5523, 5443, 5442, 5441, 5440, 5439, 5435, 5434, 5433, 5295, 5261, 5260, 5259, 5258, 5257, 5254, 5253, 5252, 5251, 5250, 5249, 5248, 5244, 5243, 5242, 5191, 5189, 5176, 4864, 4833, 4832, 4831, 4478, 4443, 4267, 4266, 4265, 4264, 4263, 4206, 4204, 4125, 4124, 3847, 1864) ASC, `stock`.`stock_status` desc, `e`.`created_at` desc LIMIT 36
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Giá thường:
420.000 ₫
Special Price
290.000 ₫
4859
-
Giá thường:
95.000 ₫
Special Price
80.000 ₫
760
-
-
-
-
-
-
-
-
-
-
-
-