MySQL returned error

Error Description :
Error No : 1064
Description : 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 '29,31,32,39,40,42,43,44) AND status='Active') GROUP BY' at line 1

SQL Query
SELECT product.*, AS product_category_id, product_category.category_id AS product_category_category_id FROM product LEFT JOIN product_category AS product_category ON( WHERE!=0 AND (product_category.category_id IN (,29,31,32,39,40,42,43,44) AND status='Active') GROUP BY