Top Comments

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 'as ID, post_title, post_name, COUNT(.comment_post_ID) AS 'comment_total' FROM L' at line 1]
SELECT .ID as ID, post_title, post_name, COUNT(.comment_post_ID) AS 'comment_total' FROM LEFT JOIN ON .ID = .comment_post_ID WHERE comment_approved = '1' AND post_date < '2010-09-04 11:53:42' AND post_status = 'publish' AND post_password = '' GROUP BY .comment_post_ID ORDER BY comment_total DESC LIMIT 10