New in Men's Fashion

SELECT `e`.`entity_id`, `e`.`type_id`, `e`.`attribute_set_id`, `cat_index`.`position` AS `cat_index_position`, `e`.`name`, `e`.`short_description`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`weight`, `e`.`small_image`, `e`.`thumbnail`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`status`, `e`.`url_key`, `e`.`required_options`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`msrp_enabled`, `e`.`msrp_display_actual_price_type`, `e`.`msrp`, `e`.`tax_class_id`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`shipment_type`, `e`.`links_purchased_separately`, `e`.`links_exist`, `e`.`size`, `e`.`size_value`, `e`.`giftwrap`, `e`.`custom_sort_order`, `e`.`free_shipping`, `e`.`sales_sort_order`, `e`.`selected_categories`, `e`.`webpos_tax`, `e`.`ring_size`, `e`.`ring_size_value`, `e`.`letter`, `e`.`letter_value`, `e`.`imported_to`, `e`.`shopify_culture`, `e`.`shopify_culture_value`, `e`.`woo_shampoosorte`, `e`.`woo_shampoosorte_value`, `e`.`variety`, `e`.`variety_value`, `e`.`volume`, `e`.`volume_value`, `e`.`woo_fragrance_type`, `e`.`woo_fragrance_type_value`, `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`, `e`.`manufacturer`, `e`.`manufacturer_value`, `percentagerules`.`rule_price`, `e`.`manufacturer`, `e`.`manufacturer_value`, `e`.`manufacturer`, `e`.`manufacturer_value` FROM `catalog_product_flat_1` AS `e` 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(2, 4) AND cat_index.category_id = '215' 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 LEFT JOIN `percentagepricing_product_price` AS `percentagerules` ON percentagerules.product_id = e.entity_id AND percentagerules.status = 1 AND percentagerules.website_id IN (0,1) AND percentagerules.customer_group_id = 0 AND percentagerules.rule_price IS NOT NULL AND percentagerules.rule_date = CURDATE() WHERE (e.status = 1) AND (e.entity_id NOT IN('52075', '52076', '52077', '52078', '57952', '70534', '70535', '71222', '71223', '71226', '71227', '71228', '71229', '74625', '74643', '74644')) AND (e.entity_id IN('139624', '139620', '139611', '139556', '139551', '139455', '139440', '139370', '139368', '139329', '139325', '139319', '139314', '139311', '139288', '139276', '139272', '139264', '139260', '139241', '139204', '139132', '139126', '139123', '139108', '139101', '139089', '139082', '139070', '139056', '139050', '139042', '138999', '138939', '138912', '138899', '138874', '138865', '138777', '138730', '138726', '138648', '138631', '138614', '138540', '138481', '138260', '138255', '138177', '137471', '137470', '137469', '137468', '137467', '137466', '137465', '137464', '137463', '137367', '137310', '137123', '137117', '137114', '137110', '137107', '137092', '137086', '137076', '137063', '137059', '136848', '136825', '136549', '136541', '135139', '135124', '135112', '135105', '135074', '135062', '135055', '135043', '135026', '135008', '134968', '134929', '134910', '134876', '134856', '134824', '134816', '134804', '134661', '134498', '134493', '133906', '132899', '132897', '132895', '132892', '132874', '132870', '132858', '132856', '132619', '132606', '132598', '132591', '132581', '132531', '132098', '132093', '132088', '132082', '132050', '132013', '132005', '131994', '131817', '131813', '131811', '131809', '131805', '131800', '131213', '131208', '131095', '131090', '131087', '131084', '130532', '130504', '129808', '128746', '128733', '128731', '128724', '128718', '128712', '128706', '128691', '128352', '128042', '127896', '126229', '125689', '125678', '123917', '123913', '123909', '123905', '123901', '123897', '123893', '123889', '123885', '123792', '123787', '123779', '123768', '123757', '123754', '123750', '123746', '123742', '123738', '123528', '123524', '123516', '123511', '123127', '123122')) ORDER BY `cat_index_position` DESC, `cat_index`.`position` DESC LIMIT 24