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