You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND p.id_manufacturer != 0' at line 4
SELECT DISTINCT(p.id_manufacturer), m.name FROM ps_product p LEFT JOIN ps_manufacturer m ON (m.id_manufacturer = p.id_manufacturer) WHERE p.id_product IN () AND p.id_manufacturer != 0