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

April 21st, 2006 at 11:03
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!
April 24th, 2006 at 13:52
Fair question! (One I originally answered for my personal blog).
The top five are:
A Windows user’s adventures in Linux (42 comments)
Commonwealth Games patch (21)
Spam Karma (18)
Why I both love and hate my iPod (18)
The Most Basic Guide Available To Downloading Television Shows With Bit Torrent (15)