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