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 (8032, 8015, 7428, 7939, 7990, 7938, 7940, 7876, 7429, 12516, 12517, 10770, 11807, 12320, 9577, 7640, 9297, 9313, 9281, 9329, 9205, 9247, 9264, 8988, 9118, 8982, 8987, 8184, 8284, 8209, 8234, 8259, 8159, 11436, 11415, 11457, 11478, 11021, 10983, 11059, 11097, 11869, 11889, 11909, 11929, 11651, 11729, 11690, 11768, 9610, 9514, 9387, 9531, 9497, 9421, 9404, 9438, 9552, 9476, 9455, 9345, 9366, 8585, 8578, 8600, 12542, 12634, 12642, 12630, 12626, 12638, 12522, 12534, 12526, 12530, 8506, 12618, 12646, 12654, 12622, 12650, 8532, 12518, 8514, 8502, 8510, 8596, 8592, 12550, 12546, 12658, 12662, 12614, 9572)) ORDER BY FIELD(e.entity_id,8032,8015,7428,7939,7990,7938,7940,7876,7429,12516,12517,10770,11807,12320,9577,7640,9297,9313,9281,9329,9205,9247,9264,8988,9118,8982,8987,8184,8284,8209,8234,8259,8159,11436,11415,11457,11478,11021,10983,11059,11097,11869,11889,11909,11929,11651,11729,11690,11768,9610,9514,9387,9531,9497,9421,9404,9438,9552,9476,9455,9345,9366,8585,8578,8600,12542,12634,12642,12630,12626,12638,12522,12534,12526,12530,8506,12618,12646,12654,12622,12650,8532,12518,8514,8502,8510,8596,8592,12550,12546,12658,12662,12614,9572)