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 RAND() limit 0,20' at line 1

SQL Query
SELECT product.*, product_category.id AS product_category_id, product_category.category_id AS product_category_category_id FROM product LEFT JOIN product_category AS product_category ON(product_category.product_id=product.id) WHERE product.id!=0 AND (product.status='Active' and product.id!=826 and product_category.category_id IN ()) GROUP BY product.id ORDER BY RAND() limit 0,20