WordPress database error: [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 'ON ( comment_post_ID = ID AND comment_approved = '1') WHERE ID IN (117) GR' at line 3]
SELECT ID, COUNT( comment_ID ) AS ccount FROM wp_posts LEFT JOIN ON ( comment_post_ID = ID AND comment_approved = '1') WHERE ID IN (117) GROUP BY ID