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 ') LIMIT 1' at line 8

			SELECT COUNT(DISTINCT(cp.`id_product`)) AS total
		    FROM `ps_category_product` cp
			JOIN `ps_product` p ON p.id_product = cp.id_product
			WHERE p.price > 1 AND
			 p.`active` = 1
                             AND p.id_manufacturer = 10
			
			AND cp.id_category IN ()
			 LIMIT 1