This website requires cookies to provide all of its features. For more information on what data is contained in the cookies, please see our Privacy Policy page. To accept cookies from this site, please click the Allow button below.
SELECT `e`.*, IF(at_status.value_id > 0, at_status.value, at_status_default.value) AS `status`, IF(at_visibility.value_id > 0, at_visibility.value, at_visibility_default.value) AS `visibility`, `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` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_entity_int` AS `at_status_default` ON (`at_status_default`.`entity_id` = `e`.`entity_id`) AND (`at_status_default`.`attribute_id` = '96') AND `at_status_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_int` AS `at_status` ON (`at_status`.`entity_id` = `e`.`entity_id`) AND (`at_status`.`attribute_id` = '96') AND (`at_status`.`store_id` = 1) INNER JOIN `catalog_product_entity_int` AS `at_visibility_default` ON (`at_visibility_default`.`entity_id` = `e`.`entity_id`) AND (`at_visibility_default`.`attribute_id` = '102') AND `at_visibility_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_int` AS `at_visibility` ON (`at_visibility`.`entity_id` = `e`.`entity_id`) AND (`at_visibility`.`attribute_id` = '102') AND (`at_visibility`.`store_id` = 1) INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 1 INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1' WHERE (`e`.`entity_id` IN('1', '41', '57', '73', '89', '182', '194', '197', '208', '251', '276', '324', '331', '344', '378', '388', '398', '408', '409', '410', '412', '414', '425', '490', '492', '493', '494', '495', '500', '505', '508', '515', '518', '530', '533', '539', '572', '592', '609', '625', '628', '637', '702', '707', '708', '713', '718', '721', '724', '725', '726', '727', '728', '729', '730', '731', '732', '737', '738', '746', '747', '748', '775', '776', '777', '778', '783', '784', '790', '791', '792', '793', '794', '795', '1000', '1111', '1134', '1178', '1183', '1235', '1236', '1286', '1351', '1352', '1356', '1373', '1393', '1401', '1413', '1445', '1462', '1479', '1482', '1496', '1499', '1574', '1765', '1806', '1807', '1829', '1833', '1834', '1836', '1850', '1853', '1868', '1870', '2004', '2005', '2011', '2013', '2014', '2020', '2021', '2027', '2049', '2056', '2065', '2066', '2067', '2069', '2077', '2078', '2150', '2159', '2167', '2171', '2174', '2188', '2196', '2239', '2247', '2269', '2270', '2291', '2306', '2366', '2393', '2405', '2463', '2542', '2583', '2588', '2619', '2690', '2692', '2695', '2698', '2699', '2785', '2798', '2806', '2811', '2812', '2824', '2838', '2889', '2939', '2958', '2995', '3010', '3012', '3021', '3025', '3115', '3123', '3135', '3151', '3154', '3155', '3169', '3172', '3291', '3461', '3462', '3500', '3520', '3524', '3528', '3585', '3588', '3599', '3600', '3601', '3602', '3603', '3606', '3608', '3609', '3612', '3617', '3623', '3629', '3642', '3652', '3658', '3664', '3670', '3682', '3686', '3735', '3736', '3739', '3787', '3794', '3801', '3806', '3818', '3819', '3826', '3827', '3828', '3856', '3860', '3861', '3862', '3882', '3893', '3894', '3901', '3902', '3903', '3909', '4012', '4047', '4084', '4085', '4086', '4087', '4095', '4116', '4117', '4118', '4119', '4121', '4123', '4145', '4160', '4166', '4175', '4176', '4177', '4178', '4182', '4193', '4281', '4285', '4286', '4287', '4288', '4289', '4290', '4291', '4292', '4293', '4294', '4310', '4311', '4314', '4315', '4316', '4317', '4326', '4344', '4353', '4362', '4371', '4407', '4408', '4410', '4411', '4512', '4516', '4539', '4690', '4693', '4696', '4699', '4700', '4702', '4705', '4708', '4711', '4714', '4717', '4720', '4723', '4724', '4725', '4726', '4727', '4728', '4729', '4730', '4731', '4732', '4733', '4734', '4735', '4736', '4737', '4819', '4820', '4821', '4822', '4823', '4824', '4825', '4826', '4891', '4894', '4897')) AND (IF(at_status.value_id > 0, at_status.value, at_status_default.value) = '1') AND (IF(at_visibility.value_id > 0, at_visibility.value, at_visibility_default.value) = '4') ORDER BY `price_index`.`min_price` DESC