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 ') GROUP BY g.ifilter_id,f.ifilter_id ORDER BY feature_sort, certification_sort, ' at line 1:SELECT g.ifilter_type as ifilter_type, g.ifilter_name as ifilter_name, g.ifilter_id as ifilter_id, count(f.sku_id) as filter_count, IF(g.ifilter_type='feature',0,1) as feature_sort, IF(g.ifilter_type='certification',0,1) as certification_sort, IF(g.ifilter_type='process',0,1) as process_sort, IF(g.ifilter_type='material',0,1) as material_sort , if(c.icategory_id IN (8,29) AND c.icategory_type='subcategory','subcategory selected', 'subcategory not selected') as indicator FROM sku a INNER JOIN icategory_sku b ON b.isku_id = a.sku_id INNER JOIN icategory c ON c.icategory_id = b.icategory_id INNER JOIN icategory d ON d.icategory_id = c.icategory_parent_id INNER JOIN icategory e ON e.icategory_id = d.icategory_parent_id INNER JOIN ifilter_sku f ON f.sku_id = b.isku_id INNER JOIN ifilter g ON g.ifilter_id = f.ifilter_id WHERE a.sku_industrial_product=1 and a.isku_hide=0 and a.isku_release_date<=now() and (a.isku_end_of_life=0 OR (a.isku_end_of_life=1 AND a.isku_end_of_life_date > Now())) and g.ifilter_type<>'Glossary-Only' and c.icategory_type='subcategory' and d.icategory_type='category' and e.icategory_type='family' and (c.icategory_id IN (8,29) or d.icategory_id IN (8,29) or e.icategory_id IN (8,29)) and c.icategory_id = 29 AND f.sku_id IN () GROUP BY g.ifilter_id,f.ifilter_id ORDER BY feature_sort, certification_sort, process_sort, material_sort, g.ifilter_sort