New in Women's Fashion

SELECT `e`.`entity_id`, `e`.`type_id`, `e`.`attribute_set_id`, `cat_index`.`position` AS `cat_index_position`, `e`.`custom_sort_order`, `e`.`ring_size`, `e`.`ring_size_value`, `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`.`free_shipping`, `e`.`sales_sort_order`, `e`.`selected_categories`, `e`.`webpos_tax`, `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`, `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', '70534', '70535', '71223', '74625', '74643', '74644')) AND (e.entity_id IN('123201', '123195', '123194', '123170', '123154', '123149', '123144', '123128', '123098', '123097', '123096', '123085', '123066', '123062', '122930', '122917', '122880', '122862', '122851', '122841', '122828', '122819', '122774', '122753', '122747', '122740', '122734', '122729', '122726', '122723', '122720', '122719', '122716', '122713', '122710', '122707', '122703', '122564', '122563', '122549', '122546', '122545', '122526', '122522', '122518', '122504', '122499', '122324', '122283', '122282', '122281', '122280', '122279', '122278', '122277', '122276', '122275', '122274', '122271', '122269', '122265', '122261', '122257', '122253', '122246', '122188', '122182', '122178', '122174', '122161', '122147', '122138', '122105', '121772', '121769', '121710', '121701', '121685', '121680', '121625', '121557', '121506', '121505', '121504', '121503', '121500', '121495', '121360', '121356', '121326', '121322', '121321', '121320', '121319', '121311', '121310', '121306', '121300', '121281', '121277', '121273', '121268', '121265', '121240', '121215', '121213', '121212', '121184', '121179', '121174', '121170', '121167', '121163', '121161', '121157', '121152', '121146', '121141', '121137', '121129', '121125', '121121', '121118', '121116', '121048', '121045', '121043', '121041', '121028', '120961', '120960', '120959', '120958', '120947', '120892', '120887', '120883', '120879', '120872', '120867', '120858', '120849', '120827', '120753', '120616', '120615', '120527', '120526', '120508', '120507', '120504', '120503', '120502', '120499', '120496', '120487', '120480', '120476', '120472', '120468', '120465', '120430', '120424', '120408', '120360', '120353', '120350', '120345', '120340', '120308', '120293', '120289', '120286', '120176', '120174', '120173', '120169', '120094', '120082', '120081', '120076', '120074', '120073', '120070', '120068', '120065', '120037', '120031', '120025', '120021', '120019', '120017', '120014', '120012', '120008', '120003', '119999', '119997', '119711', '119536', '119535', '119472', '119326', '119323', '119320', '119318', '119315', '119306', '119273', '119263', '119225', '119224', '119217', '119208', '119186', '119147', '119139', '119100', '119045', '119043', '118952', '118927', '118918', '118827', '118816', '118803', '118778', '118762', '118761', '118759', '118758', '118757', '118756', '118754', '118753', '118752', '118636', '118596', '118543', '118496', '118489', '118483', '118409', '118384', '118372', '118344', '118299', '118296', '118274', '118269', '118262', '118258', '118257', '118254', '118249', '118243', '118240', '117217', '117215', '117213', '117211', '117208', '117206', '117204', '117202', '117198', '117196', '116979', '116946', '116899', '116892', '116886', '116882', '116879', '116871', '116866', '116862', '116857', '116854', '116848', '116842', '116837', '116834', '116799', '116798', '116764', '116763', '116760', '116759', '116758', '116736', '116733', '116729', '116725', '116721', '116717', '116712', '116707', '116701', '116700', '116666', '116664', '116635', '116621', '116617', '116611', '116605', '116598', '116591', '116587', '116586', '116579', '116573', '116567', '116527', '116386', '116385', '116384', '116383', '116359', '116298', '116284', '116280', '116279', '116051', '116048', '116044', '116039', '115921', '115802', '115801', '114690', '114609', '114606', '114605', '114604', '114603', '114584', '114580', '114535', '114528', '114524', '114523', '114021', '114019', '114017', '114015', '114013', '114011', '114004', '114002', '113999', '113996', '113994', '113991', '113786', '113782', '113778', '113776', '113770', '113767', '113765', '113763', '113759', '113757', '113754', '113752', '113748', '113743', '113739', '113735', '113666', '113661', '113659', '113658', '113656', '113646', '113633', '113624', '113615', '113610', '113605', '113596', '113587', '113578', '113569', '113560', '113555', '113544', '113535', '113526', '113521', '113512', '113503', '113494', '113493', '113491', '113486', '113482', '113478', '113474', '113470', '113466', '113464', '113459', '113455', '113451', '113447', '113445', '113441', '113435', '113431', '113426', '113422', '113418', '113413', '113409', '113404', '113400', '113395', '113391', '113387', '113383', '113382', '113380', '113378', '113375', '113373', '113370', '113368', '113367', '113364', '113360', '113334', '113320', '113288', '113278', '113276', '113269', '113261', '113254', '113253', '113250', '113245', '113244', '113236', '113230', '113226', '113222', '113218', '113215', '113210', '113206', '113201', '113196', '113192', '113188', '113187', '113175', '112728', '112725', '112721', '112717', '112714', '112710', '112703', '112699', '112695', '112691', '112687', '112683', '112678', '112673', '112668', '112663', '112662', '112658', '112641', '112635', '112626', '112603', '112598', '112586', '112582', '112578', '112574', '112570', '112565', '112561', '112556', '112555', '112551', '112547', '112544', '112538', '112533', '112478', '112477', '112476', '112475', '112474', '112413', '112408', '112402', '112398', '112397', '112392', '112386', '112382', '112378', '112068', '112063', '112044', '111847', '111806', '111797')) ORDER BY `cat_index_position` DESC, `cat_index`.`position` DESC LIMIT 24