Voiture électrique 4X4 Hummer

SELECT DISTINCT p.id_product, p.*, pa.`id_product_attribute`, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, i.`id_image`, il.`legend`, m.`name` AS manufacturer_name, tl.`name` AS tax_name, t.`rate`, cl.`name` AS category_default, DATEDIFF(p.`date_add`, DATE_SUB(NOW(), INTERVAL 20 DAY)) > 0 AS new,(p.`price` * IF(t.`rate`,((100 + (t.`rate`))/100),1)) AS orderprice FROM `ps_category_product` cp LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product` LEFT JOIN `ps_product_attribute` pa ON (p.`id_product` = pa.`id_product` AND default_on = 1) LEFT JOIN `ps_category_lang` cl ON (p.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 2) LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 2) LEFT JOIN `ps_image` i ON (i.`id_product` = p.`id_product` AND i.`cover` = 1) LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2) LEFT JOIN `ps_tax_rule` tr ON (p.`id_tax_rules_group` = tr.`id_tax_rules_group` AND tr.`id_country` = 21 AND tr.`id_state` = 0) LEFT JOIN `ps_tax` t ON (t.`id_tax` = tr.`id_tax`) LEFT JOIN `ps_tax_lang` tl ON (t.`id_tax` = tl.`id_tax` AND tl.`id_lang` = 2) LEFT JOIN `ps_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN `ps_specific_price` sp ON (sp.`id_product` = p.`id_product`) WHERE p.`active` = 1 AND sp.`id_shop` IN (0, 1) AND sp.`id_currency` IN (0, 1) AND sp.`id_country` IN (0, 21) AND sp.`id_group` IN (0, 1) AND p.id_product IN (95,94,93,92,92,90,89,88,87,87,86,85,83,82,80,77,75,74,73,72,70,69,67,65,64,62,61,59,57,56,55,53,50,49,48,46,40,39,38,37,36,32,31,29,28,28,27,26,20,20,19,18,15,13,12,9,7,2) AND (`from` = '0000-00-00 00:00:00' OR ('2013-05-19 07:34:41' >= `from` AND '2013-05-19 07:34:41' <= `to`)) ORDER BY p.id_product DESC LIMIT 0,15