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('105', '121', '166', '182', '194', '197', '208', '219', '229', '240', '251', '276', '490', '491', '492', '496', '497', '498', '500', '501', '505', '507', '508', '524', '525', '530', '533', '536', '551', '555', '702', '722', '723', '725', '726', '727', '728', '733', '738', '760', '764', '766', '768', '769', '770', '775', '776', '777', '780', '781', '782', '783', '784', '785', '786', '787', '788', '791', '792', '793', '794', '795', '796', '803', '818', '824', '850', '856', '868', '1000', '1009', '1010', '1082', '1157', '1203', '1219', '1236', '1296', '1413', '1495', '1574', '1765', '1800', '1806', '1813', '1823', '1875', '1888', '1940', '2004', '2005', '2011', '2056', '2080', '2150', '2156', '2157', '2174', '2177', '2196', '2201', '2202', '2203', '2204', '2270', '2393', '2405', '2686', '2690', '2692', '2699', '2785', '2798', '2806', '2811', '2812', '2824', '2838', '2889', '2995', '3031', '3354', '3535', '3536', '3563', '3599', '3600', '3601', '3602', '3603', '3606', '3608', '3609', '3612', '3617', '3623', '3629', '3642', '3652', '3658', '3664', '3670', '3698', '3699', '3712', '3713', '3714', '3829', '3830', '3831', '3882', '3893', '3894', '3901', '3902', '3903', '4011', '4012', '4013', '4014', '4082', '4095', '4116', '4117', '4118', '4119', '4121', '4145', '4160', '4166', '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')) 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
