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 ')' at line 1
SELECT COUNT(DISTINCT p.productID) FROM SC_products p WHERE `p`.`productID` IN()