WordPress Most comments

Here’s the SQL to find which of your WordPress posts have the most comments:

SELECT wp_comments.comment_post_id, count(*) as commentcount, wp_posts.post_title, wp_posts.post_date FROM wp_comments, wp_posts
where wp_comments.comment_post_id = wp_posts.ID
group by wp_comments.comment_post_id, wp_posts.post_title, wp_posts.post_date
order by commentcount desc

2 thoughts on “WordPress Most comments

  1. Glen McGregor

    So which post has the most comments? It’d be interesting to know. Unless of course there’s lively discussion here and this post ends up with the most!

Comments are closed.