A Database Error Occurred

Error Number: 1064

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 5

SELECT DISTINCT pf.`field`as 'filter_field',pff.*,pf.*,pbfv.* FROM `product_filter_fields` as pff LEFT JOIN `product_fields` as pf ON (pff.`product_field_id`=pf.`id`) LEFT JOIN `product_br_fields_values` as pbfv ON (pbfv.`product_field_id`=pf.`id`) WHERE pbfv.`product_id` IN ()