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 products.id' at line 5
Error Number:
1064
SELECT products.id, products.title, products.alt_name, GROUP_CONCAT(pc.cat_id) as cat_id, GROUP_CONCAT(CASE WHEN pc.is_primary = 1 THEN pc.cat_id END ORDER BY pc.cat_id ) as primary_cat_id FROM products LEFT JOIN products_categories pc ON pc.product_id = products.id WHERE products.id IN () GROUP BY products.id