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 ') GROUP BY product.id ORDER BY product.product_name ASC' at line 1

SQL Query
SELECT COUNT(product.id) AS CNT FROM product LEFT JOIN product_category AS product_category ON(product_category.product_id=product.id) WHERE product.id!=0 AND ( status='Active' AND product_category.category_id=) GROUP BY product.id ORDER BY product.product_name ASC