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 ')) GROUP BY I.productId LIMIT 0, 10' at line 1

SELECT CI.cat_id, CI.productId, I.productCode, I.quantity, I.description, I.image, I.price,, I.popularity, I.sale_price, I.stock_level, I.useStockLevel, I.hasProdVideo FROM CubeCart_cats_idx AS CI INNER JOIN CubeCart_inventory AS I ON CI.productId = I.productId INNER JOIN CubeCart_category as C ON C.cat_id = CI.cat_id WHERE I.disabled = '0' AND I.cat_id > 0 AND C.cat_id > 0 AND C.hide = '0' AND (C.cat_desc != '##HIDDEN##' OR C.cat_desc IS NULL) AND (I.useStockLevel = 0 OR I.stock_level > 0) AND (CI.cat_id IN ()) GROUP BY I.productId