WinterCollection

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`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable` 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.customer_group_id = 0 AND price_index.website_id = '1' LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product')) INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id WHERE (stock_status_index.stock_status = 1) AND (e.entity_id IN (4969, 4920, 4906, 4976, 4948, 4913, 4927, 4896, 4941, 4934, 4962, 4955, 11987, 11994, 11966, 11980, 11959, 11973, 11949, 12006, 11999, 12062, 12069, 12020, 12083, 12076, 12034, 12027, 12013, 8139, 8113, 12731, 7479, 7477, 7447, 7446, 7444, 7445, 7430, 7428, 7990, 7940, 7429, 7431, 7427, 14111, 14066, 14201, 14156, 13445, 13310, 13400, 13355, 10770, 15158, 11807, 11436, 11415, 11457, 11478, 11021, 10983, 11059, 11097, 11869, 11889, 11909, 11929, 11651, 11729, 11690, 11768, 14250, 14254, 14258, 14262, 14246, 12896, 12886, 12891, 12881, 12876, 12901)) ORDER BY FIELD(e.entity_id,4969,4920,4906,4976,4948,4913,4927,4896,4941,4934,4962,4955,11987,11994,11966,11980,11959,11973,11949,12006,11999,12062,12069,12020,12083,12076,12034,12027,12013,8139,8113,12731,7479,7477,7447,7446,7444,7445,7430,7428,7990,7940,7429,7431,7427,14111,14066,14201,14156,13445,13310,13400,13355,10770,15158,11807,11436,11415,11457,11478,11021,10983,11059,11097,11869,11889,11909,11929,11651,11729,11690,11768,14250,14254,14258,14262,14246,12896,12886,12891,12881,12876,12901)