MySQL Error Occurred

Error Message:
1064: 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 ') ORDER BY RAND() LIMIT 10' at line 1

SQL:
SELECT I.name, I.productId,I.weight, I.price,I.amz_price,I.amz_list_price, I.sale_price, I.productId, I.image , I.cat_id,I.disabled,I.prod_flag, I.main_deal, C.cat_name,C.cat_father_id FROM cubecart_inventory AS I, cubecart_category AS C WHERE C.cat_id = I.cat_id AND I.disabled = '0' AND I.prod_flag = '0' AND I.cat_id in () ORDER BY RAND() LIMIT 10