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', '105', '121', '136', '160', '166', '182', '194', '197', '208', '219', '229', '240', '251', '276', '324', '327', '331', '344', '373', '378', '388', '398', '408', '409', '410', '412', '413', '414', '425', '490', '491', '492', '493', '494', '495', '496', '497', '498', '500', '501', '505', '507', '508', '512', '515', '518', '524', '525', '527', '530', '533', '536', '539', '551', '555', '563', '566', '569', '572', '592', '609', '625', '628', '637', '646', '664', '673', '682', '691', '702', '707', '708', '709', '710', '711', '712', '713', '714', '715', '716', '717', '718', '721', '722', '723', '724', '725', '726', '727', '728', '729', '730', '731', '732', '733', '734', '736', '737', '738', '739', '740', '743', '744', '745', '746', '747', '748', '775', '776', '777', '778', '783', '784', '790', '791', '792', '793', '794', '795', '877', '1000', '1090', '1111', '1134', '1178', '1183', '1235', '1236', '1273', '1286', '1341', '1342', '1351', '1352', '1356', '1369', '1373', '1393', '1397', '1401', '1405', '1406', '1409', '1413', '1445', '1462', '1479', '1482', '1483', '1496', '1499', '1574', '1632', '1638', '1656', '1674', '1692', '1765', '1787', '1806', '1807', '1812', '1813', '1823', '1826', '1829', '1830', '1831', '1833', '1834', '1836', '1839', '1840', '1841', '1844', '1845', '1846', '1850', '1851', '1853', '1855', '1856', '1857', '1858', '1859', '1860', '1861', '1862', '1863', '1864', '1866', '1867', '1868', '1869', '1870', '1872', '1873', '2004', '2005', '2007', '2011', '2013', '2014', '2020', '2021', '2027', '2049', '2056', '2065', '2066', '2067', '2068', '2069', '2070', '2074', '2077', '2078', '2080', '2086', '2150', '2156', '2157', '2159', '2160', '2167', '2171', '2174', '2188', '2192', '2196', '2207', '2239', '2247', '2264', '2269', '2270', '2291', '2299', '2306', '2316', '2325', '2329', '2332', '2333', '2335', '2344', '2357', '2366', '2382', '2393', '2405', '2463', '2542', '2583', '2588', '2619', '2690', '2692', '2695', '2698', '2699', '2785', '2798', '2806', '2811', '2812', '2824', '2838', '2889', '2939', '2958', '2980', '2981', '2989', '2995', '3010', '3012', '3021', '3025', '3087', '3088', '3095', '3114', '3115', '3116', '3121', '3122', '3123', '3135', '3145', '3149', '3151', '3154', '3155', '3156', '3163', '3164', '3165', '3169', '3172', '3291', '3461', '3462', '3500', '3520', '3524', '3528', '3531', '3532', '3533', '3534', '3585', '3588', '3596', '3597', '3599', '3600', '3601', '3602', '3603', '3606', '3608', '3609', '3612', '3617', '3623', '3629', '3642', '3652', '3658', '3664', '3670', '3682', '3686', '3710', '3735', '3736', '3739', '3787', '3794', '3801', '3806', '3818', '3819', '3823', '3824', '3825', '3826', '3827', '3828', '3829', '3830', '3831', '3856', '3860', '3861', '3862', '3882', '3893', '3894', '3901', '3902', '3903', '3905', '3909', '3913', '4012', '4047', '4077', '4084', '4085', '4086', '4087', '4095', '4116', '4117', '4118', '4119', '4121', '4123', '4145', '4160', '4166', '4175', '4176', '4177', '4178', '4182', '4188', '4193', '4272', '4273', '4274', '4276', '4281', '4285', '4286', '4287', '4288', '4289', '4290', '4291', '4292', '4293', '4294', '4310', '4311', '4314', '4315', '4316', '4317', '4326', '4344', '4353', '4362', '4371', '4374', '4383', '4407', '4408', '4410', '4411', '4501', '4504', '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