You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND p.`active` = 1 and i.`zoom`=1' at line 4

SELECT *
				  FROM `ps_product` p
				  LEFT JOIN `ps_image` i ON (i.`id_product` = p.`id_product` ) 
				  WHERE p.`id_product` IN ()
				  AND p.`active` = 1 and i.`zoom`=1