Men

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 (7428, 7990, 7940, 7429, 7431, 7427, 12973, 14111, 14066, 14201, 14156, 13445, 13310, 13400, 13355, 12516, 12517, 13095, 10770, 11807, 12320, 9577, 9297, 9313, 9281, 9329, 9226, 9205, 9264, 8988, 8982, 8986, 8983, 11436, 11415, 11457, 11478, 11021, 10983, 11059, 11097, 11869, 11889, 11909, 11929, 11651, 11729, 11690, 11768, 13149, 13161, 13173, 13196, 13264, 13281, 13230, 13213, 13247, 9610, 9514, 9387, 9531, 9497, 9421, 9404, 9438, 9552, 9476, 9455, 9345, 9366, 8585, 8578, 8600, 8609, 14250, 14254, 14258, 14262, 14246, 12634, 12642, 12630, 12626, 12638, 12530, 8506, 12646, 12654, 12622, 12650, 8502, 12872, 8596, 13298, 13306, 8592, 13302, 12550, 12546)) ORDER BY FIELD(e.entity_id,7428,7990,7940,7429,7431,7427,12973,14111,14066,14201,14156,13445,13310,13400,13355,12516,12517,13095,10770,11807,12320,9577,9297,9313,9281,9329,9226,9205,9264,8988,8982,8986,8983,11436,11415,11457,11478,11021,10983,11059,11097,11869,11889,11909,11929,11651,11729,11690,11768,13149,13161,13173,13196,13264,13281,13230,13213,13247,9610,9514,9387,9531,9497,9421,9404,9438,9552,9476,9455,9345,9366,8585,8578,8600,8609,14250,14254,14258,14262,14246,12634,12642,12630,12626,12638,12530,8506,12646,12654,12622,12650,8502,12872,8596,13298,13306,8592,13302,12550,12546)