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`.`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`, `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('110871', '110870', '110857', '110853', '110845', '110825', '110766', '110684', '110633', '110632', '110631', '110577', '110543', '110542', '110504', '110493', '110472', '110465', '110457', '110448', '110441', '110433', '110425', '110417', '110409', '110404', '110386', '110378', '110369', '110367', '110362', '110360', '110334', '110326', '110314', '110296', '110292', '110213', '110119', '110086', '110076', '109870', '109868', '109864', '109857', '109854', '109849', '109845', '109841', '109839', '109837', '109833', '109829', '109826', '109823', '109820', '109817', '109815', '109811', '109808', '109806', '109804', '109802', '109797', '109601', '109599', '109596', '109593', '109591', '109589', '109587', '109585', '109583', '109553', '109546', '109542', '109538', '109534', '109530', '109523', '109519', '109515', '109511', '109507', '109503', '109499', '109495', '109491', '109487', '109373', '109370', '109366', '109363', '109359', '109357', '109355', '109353', '109351', '109349', '109346', '109343', '109341', '109339', '109337', '109335', '109333', '109328', '109324', '109322', '109320', '109317', '109315', '109313', '109311', '109309', '109307', '109304', '109302', '109300', '109298', '109296', '109294', '109292', '109290', '109288', '109285', '109283', '109223', '109221', '109219', '109216', '109214', '109207', '109205', '109202', '109200', '109196', '109194', '109192', '109190', '109185', '109182', '109180', '109178', '109105', '109103', '109101', '109099', '109094', '109092', '109086', '109083', '109080', '109077', '109075', '109073', '109071', '109069', '109067', '109065', '109063', '109059', '109057', '109054', '109051', '109048', '109043', '109041', '109037', '109035', '109030', '109028', '109024', '109020', '109018', '109014', '109012', '109010', '109008', '109005', '109003', '109001', '108999', '108994', '108992', '108990', '108988', '108985', '108982', '108979', '108976', '108935', '108931', '108927', '108923', '108919', '108915', '108911', '108907', '108904', '108901', '108898', '108895', '108891', '108889', '108887', '108884', '108882', '108880', '108878', '108876', '108874', '108872', '108870', '108868', '108866', '108862', '108858', '108855', '108848', '108787', '108783', '108779', '108775', '108771', '108767', '108763', '108761', '108759', '108752', '108748', '108744', '108740', '108738', '108733', '108730', '108727', '108725', '108722', '107975', '107918', '107900', '107898', '107754', '107753', '107752', '107559', '107550', '107541', '107534', '107533', '107442', '107429', '107419', '107417', '107416', '107415', '107384', '107382', '107381', '107286', '107285', '107282', '107266', '107265', '107264', '107263', '107252', '107248', '107241', '107240', '107239', '107238', '107083', '107074', '107073', '107033', '107027', '107023', '107019', '107013', '107011', '107007', '107002', '106933', '106932', '106930', '106929', '106928', '106923', '106904', '106842', '106840', '106715', '106713', '106481', '106468', '106404', '105887', '105855', '105765', '105761', '105757', '105699', '105693', '105652', '105648', '105342', '105337', '105331', '105308', '105304', '105276', '105230', '105220', '105166', '105164', '105103', '104990', '104951', '104841', '103791', '103790', '103788', '103786', '103783', '103781', '103778', '103775', '103773', '103772', '103769', '103765', '103692', '103661', '103611', '103596', '103571', '103544', '103475', '103471', '103445', '103431', '103427', '103417', '103406', '103349', '103339', '103338', '103335', '103332', '103328', '103321', '102301', '102246', '102189', '101922', '101916', '101909', '101902', '101895', '101888', '101887', '101881', '101875', '101869', '101838', '101828', '101817', '101807', '101796', '101786', '101776', '101750', '101742', '101733', '101732', '101726', '101719', '101712', '101672', '101665', '101654', '101653', '101651', '101649', '101624', '101616', '101560', '101550', '101484', '101416', '101402', '101378', '101340', '101313', '101308', '101245', '101240', '101234', '101227', '101213', '101207', '101201', '101195', '101190', '101183', '101178', '101172', '101165', '101158', '101154', '101143', '101127', '101119', '101110', '101099', '101093', '101080', '101079', '101078', '101073', '101072', '101071', '101067', '101066', '101065', '101059', '101057', '101045', '101038', '101037', '101036', '101035', '100994', '100990', '100985', '100980', '100976', '100974', '100333', '100269', '100217', '100135', '99948', '99613', '99574', '99569', '99558', '99555', '99551', '99546', '99528', '99456', '99453', '99397', '99391', '99344', '99270', '99262', '99255', '99249', '99242', '99236', '99230', '99225', '99220', '99214', '99208', '99202', '99198', '99192', '99186', '99180', '99177', '99156', '99152', '99151', '99131', '99126', '99112', '99109', '99107', '99096', '99085', '99059', '99038', '99033', '98989')) ORDER BY `cat_index_position` DESC, `cat_index`.`position` DESC LIMIT 24
×
Item has been added to your bag
