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('99059', '99038', '99033', '98989', '98925', '98879', '98873', '98868', '98866', '98862', '98777', '98776', '98772', '98767', '98764', '98726', '98719', '98707', '98706', '98693', '98687', '98683', '98677', '98676', '98663', '98644', '98642', '98593', '98573', '98569', '98564', '98559', '98556', '98551', '98547', '98545', '98541', '98538', '98534', '98533', '98519', '98510', '98498', '98495', '98490', '98485', '98481', '98476', '98473', '98467', '98389', '98379', '98367', '97822', '97798', '97787', '97779', '97774', '97738', '97733', '97732', '97726', '97725', '97718', '97712', '97698', '97675', '97650', '97644', '97642', '97641', '97638', '97635', '97634', '97633', '97632', '97631', '97627', '97603', '97601', '97565', '97563', '97553', '97515', '97469', '97455', '97454', '97439', '97430', '97422', '97414', '97378', '97360', '97359', '97353', '97340', '97332', '97330', '97329', '97324', '97308', '97304', '97294', '97293', '97289', '97278', '97277', '97275', '97269', '97264', '97255', '97237', '97218', '97161', '97156', '97144', '97124', '97113', '97021', '96949', '96948', '96947', '96946', '96935', '96934', '96933', '96927', '96913', '96898', '96875', '96857', '96853', '96848', '96844', '96839', '96836', '96829', '96824', '96823', '96818', '96810', '96805', '96804', '96802', '96798', '96794', '96791', '96787', '96785', '96780', '96773', '96771', '96765', '96761', '96759', '96754', '96751', '96749', '96743', '96737', '96731', '96727', '96723', '96720', '96716', '96713', '96659', '96639', '96528', '96376', '96193', '96175', '96174', '96173', '96129', '96125', '96124', '96120', '96119', '96118', '96085', '96080', '96076', '96070', '96065', '96060', '96055', '96050', '96045', '96041', '96037', '96032', '96028', '96015', '96006', '95952', '95904', '95899', '95892', '95882', '95818', '95779', '95778', '95765', '95677', '95662', '95563', '95554', '95553', '95535', '95519', '95515', '95514', '95513', '95503', '95500', '95496', '95494', '95489', '95482', '95472', '95468', '95463', '95454', '95427', '95424', '95418', '95410', '95395', '95392', '95378', '95355', '95344', '95267', '95255', '95249', '95175', '95171', '95113', '95111', '95106', '95103', '95100', '95095', '95093', '95036', '95007', '94981', '94971', '94889', '94874', '94844', '94718', '94690', '94651', '94644', '94627', '94613', '94609', '94605', '94600', '94595', '94590', '94585', '94568', '94547', '94534', '94408', '94402', '94379', '94221', '94179', '94149', '94121', '94109', '94104', '94103', '94010', '93916', '93893', '93819', '93818', '93745', '93727', '93717', '93708', '93691', '93630', '93625', '93589', '93583', '93577', '93566', '93558', '93553', '93540', '93535', '93534', '93533', '93532', '93530', '93495', '93490', '93473', '93457', '93447', '93405', '93371', '93369', '93367', '93359', '93289', '93259', '93256', '93255', '93228', '93223', '93222', '93221')) ORDER BY `cat_index_position` DESC, `cat_index`.`position` DESC LIMIT 24