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 8<br /><br /><pre>SELECT DISTINCT a.id_attribute, a.color, a.color2, al.name 
		FROM `ps_attribute` a
		INNER JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.id_attribute_group AND is_color_group=1)
		INNER JOIN `ps_product_attribute_combination` pac ON a.id_attribute = pac.id_attribute
		INNER JOIN `ps_product_attribute` pa ON pac.id_product_attribute = pa.id_product_attribute
		INNER JOIN `ps_attribute_lang` al ON a.id_attribute = al.id_attribute AND al.id_lang = 2
		INNER JOIN `ps_category_product` cp ON pa.id_product = cp.id_product
		WHERE cp.id_category IN ()</pre>