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`.`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 = '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('144329', '144328', '144327', '144324', '144309', '144289', '144283', '139692', '139690', '139675', '139671', '139663', '139662', '139659', '139645', '139624', '139620', '139618', '139614', '139605', '139601', '139597', '139595', '139590', '139586', '139582', '139573', '139569', '139565', '139562', '139558', '139551', '139548', '139545', '139541', '139535', '139508', '139486', '139481', '139476', '139469', '139465', '139461', '139457', '139450', '139444', '139440', '139437', '139426', '139418', '139414', '139411', '139407', '139402', '139398', '139391', '139381', '139376', '139368', '139364', '139346', '139341', '139337', '139333', '139305', '139294', '139283', '139277', '139252', '139244', '139241', '139229', '139222', '139218', '139189', '139175', '139166', '139150', '139145', '139143', '139138', '139118', '139113', '139094', '139077', '139062', '139037', '139031', '139027', '139025', '139022', '139019', '139013', '139006', '138996', '138990', '138983', '138966', '138960', '138954', '138948', '138946', '138942', '138934', '138928', '138922', '138917', '138908', '138904', '138895', '138891', '138887', '138883', '138878', '138870', '138867', '138859', '138855', '138850', '138840', '138838', '138836', '138831', '138826', '138816', '138811', '138806', '138802', '138798', '138789', '138783', '138771', '138765', '138760', '138754', '138748', '138738', '138734', '138722', '138718', '138713', '138707', '138701', '138690', '138683', '138677', '138659', '138655', '138637', '138619', '138608', '138598', '138594', '138590', '138586', '138580', '138574', '138568', '138564', '138561', '138554', '138550', '138546', '138540', '138530', '138519', '138512', '138509', '138505', '138500', '138495', '138491', '138486', '138475', '138469', '138450', '138449', '138448', '138447', '138446', '138445', '138432', '138430', '138403', '138252', '138213', '138132', '138130', '138127', '138125', '138124', '138123', '138122', '138121', '138117', '138116', '138113', '138110', '138107', '138101', '138099', '138098', '138097', '138094', '138092', '138090', '138088', '138087', '138086', '138082', '138078', '138075', '138074', '138073', '138070', '138069', '138064', '138062', '138059', '138057', '138053', '138052', '138051', '138047', '138043', '138042', '138039', '138037', '138036', '138035', '138032', '138029', '138024', '138023', '138022', '138021', '138020', '138019', '138016', '138013', '138009', '138006', '138001', '137998', '137995', '137991', '137986', '137982', '137978', '137973', '137970', '137967', '137963', '137640', '137556', '137550', '137534', '137521', '137516', '137387', '137376', '137340', '137141', '137134', '137100', '137081', '137055', '137044', '137040', '137037', '136895', '136851', '136837', '136829', '136827', '136819', '136813', '136812', '136811', '136805', '136799', '136792', '136785', '136780', '136769', '136762', '136756', '136750', '136740', '136739', '136731', '136722', '136717', '136712', '136703', '136689', '136676', '136645', '136640', '136538', '136431', '136429', '135151', '135124', '135112', '135109', '135098', '135086', '135079', '135068', '135048', '135032', '135019', '134981', '134936', '134922', '134889', '134869', '134821', '134810', '134784', '134783', '134780', '134778', '134777', '134776', '134775', '134774', '134773', '134771', '134770', '134769', '134768', '134767', '134766', '134764', '134762', '134761', '134684', '134523', '134522', '134521', '134520', '134519', '134518', '134517', '134516', '134515', '134513', '134501', '134480', '134475', '134468', '134462', '134456', '134431', '134420', '134418', '134416', '134415', '134347', '134346', '134342', '134337', '134334', '134312', '134311', '134298', '134292', '134150', '134144', '134111', '134106', '134102', '134098', '134094', '134086', '134081', '134047', '134046', '134045', '134044', '134040', '134032', '134024', '133940', '133929', '133918', '133917', '133906', '133774', '133769', '133767', '133763', '133760', '133755', '133751', '133713', '133706', '133082', '133042', '132928', '132738', '132618', '132617', '132612', '132572', '132558', '132556', '132552', '132549', '132545', '132543', '132537', '132506', '132068', '132063', '132059', '132047', '132044', '132040', '132037', '132028', '132023', '131883', '131840', '131828', '131796', '131790', '131787', '131786', '131689', '131564', '131237', '131232', '131231', '131161', '131153', '131150', '131147', '131144', '131141', '131139', '131136', '131035', '131031', '131027', '131023', '131019', '131018', '131014', '131013', '131009', '131002', '131001', '130997', '130995', '130990', '130986', '130981', '130978', '130974', '130599', '130582', '130569', '130556', '130372', '130360', '130341', '130330', '130309', '130124', '130013', '129933', '129930', '129925', '129906', '129852', '129831', '129827', '129823', '129819', '129251', '129248', '129092', '129085', '129070', '129065', '129060', '129055', '129049', '129048', '129045', '129044', '129034', '129030', '129028', '129021', '129020', '129019', '129018', '129016', '129015', '129011', '129010', '128970', '128961', '128888', '128887', '128886', '128885', '128884', '128883', '128882', '128881', '128880', '128879', '128877', '128876', '128870', '128865', '128786', '128772', '128719', '128705', '128688', '128681', '128680', '128679', '128678', '128548', '128463', '128356', '128351', '128350', '128331', '128317', '128308', '128286', '128260', '128253', '128248', '128235', '128126', '128121', '128033', '127966', '127961', '127905', '127900', '126211', '126207', '126202', '126198', '126194', '126191', '126187', '126182', '126076', '125960', '125957', '125701', '125629', '123990', '123972', '123945', '123940', '123935', '123917', '123913', '123909', '123905', '123901', '123897', '123893', '123889', '123885', '123792', '123787', '123779', '123778', '123773', '123772', '123768', '123757', '123754', '123750', '123746', '123742', '123738', '123725', '123723', '123688', '123536', '123530', '123170', '123154', '123149', '123144', '123128', '123096', '123066', '122930', '122917', '122880', '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', '122278', '122277', '122276')) ORDER BY `cat_index_position` DESC, `cat_index`.`position` DESC LIMIT 24