Custom Message : Something wrong in query
SELECT fp.*,pfm.product_id,pro.name as product_name,pfm.filter_name,pfm.parent,pfm.id as fid FROM filters_of_provider as fp INNER JOIN product_filter_master as pfm ON fp.filter_id = pfm.id left join product as pro on pfm.product_id=pro.product_id WHERE fp.provider_id= and pfm.product_id in('') ORDER BY pro.name ASC, pfm.filter_name ASC


Error Number : 1064

Error Message : 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 'and pfm.product_id in('') ORDER BY pro.name ASC, pfm.filter_name ASC' at line 1