New in Women'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`.`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`, `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 = '199' 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('93146', '93125', '93121', '93118', '93116', '93070', '93064', '93063', '92541', '92538', '92534', '92531', '92530', '92527', '92524', '92519', '92443', '92439', '92437', '92436', '92430', '92422', '92421', '92418', '92416', '92415', '92282', '92244', '92223', '92219', '92218', '92190', '92188', '92181', '92180', '92176', '92172', '92170', '92169', '92168', '92166', '92165', '92162', '92155', '92154', '92153', '92140', '92139', '92138', '92129', '92104', '92094', '92090', '92065', '92064', '92059', '92046', '92038', '92032', '91788', '91783', '91782', '91779', '91778', '91777', '91775', '91768', '91683', '91679', '91567', '91563', '91559', '91544', '91536', '91497', '91472', '91462', '91458', '91447', '91446', '91431', '91425', '91420', '91419', '91418', '91403', '91397', '91393', '91386', '91314', '91313', '91312', '91253', '91189', '91114', '91106', '91102', '91099', '91092', '91080', '91070', '91066', '91063', '91059', '91056', '91053', '91050', '91046', '91042', '91035', '90961', '90956', '90232', '90153', '90067', '90065', '90063', '90061', '90059', '90057', '90055', '90053', '90051', '90049', '90015', '89944', '89942', '89940', '89938', '89934', '89898', '89896', '89887', '89882', '89868', '89865', '89858', '89857', '89856', '89854', '89852', '89839', '89833', '89830', '89826', '89789', '89768', '89737', '89549', '89544', '89478', '89404', '89353', '89352', '89153', '89149', '89144', '89122', '89012', '89011', '89007', '88994', '88988', '88968', '88963', '88958', '88949', '88942', '88938', '88918', '88869', '88836', '88831', '88826', '88821', '88816', '88812', '88802', '88795', '88790', '88785', '88776', '88770', '88763', '88755', '88747', '88700', '88698', '88690', '88684', '88679', '88675', '88609', '88601', '88587', '88581', '88575', '88571', '88567', '88566', '88442', '88338', '88332', '88323', '88319', '88286', '88238', '88106', '88105', '88104', '88078', '88074', '88041', '88029', '88024', '88020', '88010', '88008', '88002', '87975', '87970', '87962', '87957', '87947', '87867', '87866', '87865', '87857', '87830', '87815', '87811', '87809', '87804', '87800', '87795', '87791', '87787', '87782', '87777', '87775', '87767', '87763', '87759', '87756', '87749', '87745', '87739', '87736', '87732', '87728', '87725', '87718', '87716', '87712', '87709', '87705', '87703', '87698', '87695', '87686', '87682', '87678', '87674', '87669', '87664', '87659', '87654', '87648', '87643', '87638', '87633', '87629', '87628', '87612', '87016', '87015', '87002', '87001', '87000', '86999', '86998', '86997', '86963', '86962', '86961', '86960', '86941', '86940', '86928', '86927', '86926', '86925', '86924', '86923', '86901', '86895', '86851', '86846', '86844', '86841', '86836', '86827', '86818', '86812', '86808', '86804', '86777', '86776', '86775', '86731', '86718', '86717', '86716', '86715', '86714', '86713', '86712', '86705', '86690', '86670', '86663', '86652', '86647', '86646', '86623', '85417', '85416', '85415', '85413', '85412', '85411', '85387', '85357', '85349', '85348', '85345', '85340', '85336', '85329', '85322', '85313', '85309', '85303', '85287', '85284', '85283', '85282', '85254', '85204', '85203', '85202', '85201', '85200', '85196', '85119', '85118', '85115', '85114', '85113', '85112', '85111', '85110', '85109', '85108', '85107', '85106', '85100', '85059', '85056', '85052', '85048', '85044', '85040', '85039', '85017', '85006', '84998', '84972', '84869', '84865', '84820', '84796', '84790', '84784', '84783', '84750', '84746', '84740', '84736', '84730', '84724', '84717', '84707', '84698', '84634', '84630', '84621', '84614', '84525', '84518', '84512', '84499', '84486', '84481', '84476', '84472', '84467', '84462', '84458', '84450', '84449', '84440', '84436', '84435', '84430')) ORDER BY `cat_index_position` DESC, `cat_index`.`position` DESC LIMIT 24