MySQL Error Occured
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 ') AND active='1' AND isPhotos='0' AND isNews='0' ORDER BY CubeCart_inven' at line 1

QUERY = SELECT DISTINCT CubeCart_inventory.cat_id, CubeCart_cats_idx.productId, productCode, image, price, dia, name, available, sale_price, tampelaki, useStockLevel, stock_level FROM CubeCart_cats_idx INNER JOIN CubeCart_inventory ON CubeCart_cats_idx.productId = CubeCart_inventory.productId WHERE CubeCart_cats_idx.cat_id IN () AND active='1' AND isPhotos='0' AND isNews='0' ORDER BY CubeCart_inventory.list_no DESC, productId DESC