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 ')' at line 9

			SELECT p.`id_product`, p.`condition`, p.`id_manufacturer`, p.`quantity`, p.`weight`,
			(SELECT GROUP_CONCAT(`id_category`) FROM `ps_category_product` cp WHERE cp.`id_product` = p.`id_product`) as ids_cat,
				(SELECT GROUP_CONCAT(`id_feature_value`) FROM `ps_feature_product` fp WHERE fp.`id_product` = p.`id_product`) as ids_feat,
				(SELECT GROUP_CONCAT(DISTINCT(pac.`id_attribute`)) 
					FROM `ps_product_attribute_combination` pac 
					LEFT JOIN `ps_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) 
					WHERE pa.`id_product` = p.`id_product` ) as ids_attr
			FROM ps_product p 
			WHERE p.`active` = 1 AND p.`id_product` IN ()