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 comment_post_ID, comment_type, comment_status' at line 3(Errno=1064)
Your query:
SELECT comment_post_ID, comment_type, comment_status, COUNT(*) AS type_count
FROM evo_comments
WHERE comment_post_ID IN ()
GROUP BY comment_post_ID, comment_type, comment_status