Error Number: 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 is_main DESC ) AS file GROUP BY file_item' at line 7

SELECT *, COUNT( file_id ) AS total_files FROM ( SELECT file_id, file_web_path, file_name, file_title, file_item_id, is_main, image_width, image_height FROM file WHERE `file_module_id` = '4' AND file_item_id IN ( ) ORDER BY is_main DESC ) AS file GROUP BY file_item_id