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`, `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('52076', '52077', '52078', '57952')) AND (e.entity_id IN('66290', '66275', '66261', '66260', '66259', '66257', '66256', '66254', '66253', '66250', '66237', '66226', '66195', '66190', '66188', '66147', '66145', '66144', '66143', '66142', '66137', '66136', '66135', '66133', '66124', '66119', '66076', '66072', '66067', '66059', '66056', '66051', '66047', '66041', '66036', '66031', '66026', '66024', '66020', '66016', '66010', '66005', '66000', '65995', '65991', '65986', '65982', '65977', '65974', '65971', '65969', '65968', '65963', '65957', '65954', '65952', '65951', '65949', '65945', '65944', '65941', '65940', '65933', '65932', '65931', '65926', '65922', '65914', '65907', '65900', '65894', '65893', '65891', '65879', '65837', '65836', '65799', '65797', '65796', '65792', '65756', '65743', '65739', '65735', '65731', '65727', '65656', '65647', '65621', '65611', '65602', '65593', '65583', '65574', '65564', '65556', '65547', '65542', '65537', '65528', '65517', '65504', '65495', '65486', '65479', '65443', '65424', '65412', '65394', '65389', '65388', '65387', '65386', '65384', '65374', '65369', '65368', '65367', '65366', '65365', '65364', '65362', '65361', '65360', '65358', '65356', '65355', '65354', '65353', '65351', '65350', '65348', '65343', '65342', '65341', '65340', '65339', '65338', '65336', '65335', '65329', '65328', '65327', '65324', '65323', '65322', '65320', '65319', '65318', '65309', '65304', '65303', '65300', '65299', '65298', '65297', '65296', '65295', '65294', '65293', '65288', '65285', '65284', '65283', '65282', '65281', '65280', '65275', '65273', '65260', '65259', '65258', '65257', '65256', '65255', '65254', '65253', '65252', '65249', '65246', '65239', '65237', '65236', '65235', '65234', '65228', '65226', '65225', '65224', '65217', '65216', '65215', '65214', '65207', '65200', '65181', '65180', '65179', '65175', '65174', '65173', '65165', '65164', '65162', '65161', '65160', '65159', '65158', '65155', '65151', '65147', '65146', '65145', '65144', '65142', '65136', '65135', '65134', '65133', '65132', '65131', '65130', '65129', '65128', '65127', '65126', '65122', '65121', '65120', '65119', '65118', '65114', '65112', '65103', '65093', '65092', '65091', '65090', '65089', '65088', '65087', '65086', '65084', '65083', '65082', '65081', '65080', '65079', '65078', '65077', '65061', '65060', '65059', '65058', '65057', '65050', '65049', '65048', '65047', '65046', '65045', '65044', '65043', '65041', '65040', '65039', '65031', '65030', '65029', '65028', '65027', '65026', '65025', '65024', '65023', '65020', '65019', '65018', '65014', '65013', '65012', '65011', '65008', '65004', '65003', '65000', '64992', '64990', '64989', '64988', '64987', '64986', '64985', '64984', '64983', '64977', '64974', '64966', '64963', '64962', '64961', '64959', '64958', '64957', '64956', '64953', '64951', '64928', '64927', '64925', '64924', '64923', '64922', '64920', '64919', '64918', '64917', '64914', '64913', '64912', '64911', '64908', '64907', '64899', '64898', '64896', '64895', '64894', '64893', '64882', '64881', '64880', '64876', '64875', '64874', '64873', '64872', '64871', '64870', '64869', '64868', '64867', '64866', '64864', '64860', '64859', '64858', '64854', '64852', '64846', '64844', '64843', '64842', '64835', '64834', '64826', '64821', '64819', '64813', '64811', '64806', '64805', '64804', '64799', '64798', '64797', '64790', '64787', '64786', '64785', '64784', '64447', '63484', '63476', '63317', '63309', '63301', '63275', '63269', '63266', '63264', '63247', '63243', '63200', '63183', '63160', '63116', '63052', '61899', '60794', '60770', '60769', '60714', '60709', '60693', '60692', '60688', '60687', '60676', '60675', '60673', '60641', '60634', '60622', '60565', '60558', '60484', '60474', '60452', '60439', '60438', '60437', '60212', '60198', '60033', '60009', '60005', '60001', '59995', '59992', '59987', '59958', '59957', '59956', '59881', '59780', '59775', '59769', '59757', '59747', '59718', '59656', '59651', '59643', '59632', '59625', '59614', '59542', '59534', '59527', '59520', '59512', '59509', '59495', '59489', '59486', '59472', '59459', '59293', '59247', '59201', '59192', '59167', '59163', '59160', '59147', '59143', '59114', '59102', '59096', '59084', '59071', '59066', '59055', '59051', '59046', '59044', '59039', '59038', '59022', '59013', '59006', '59003', '58993', '58966', '58956', '58946', '58918', '58853', '58813', '58789', '58725', '58721', '58673')) ORDER BY `e`.`created_at` desc, `cat_index_position` ASC, `cat_index`.`position` ASC LIMIT 24