I remember Neil Turner publishes a list of his blog’s most frequent commenters each year, and I being the copycat I am decided to do the same.
I realised that you can’t do this in WordPress without having to mess on installing a widget or doing a SQL query. I decided to download the WordPress Top Commenters Plugin/Widget, but wishing to produce a one time list only I decided to extract the SQL query held in this GPL script.
Anyhow, the MySQL query is:
SELECT comment_author, comment_author_url, comment_author_email, comment_post_ID, COUNT( comment_ID ) AS total_comments
FROM wp_comments
WHERE comment_approved = '1'
GROUP BY comment_author
ORDER BY total_comments DESC
And to honour our most frequent commenters (bear in mind if you’ve posted from different names unless I see, they won’t be merged together)
Number 1 is Azhar, who’s made 72 comments here. He is followed by Sarah who has made 57. techchick comes next making 21 comments in total from the names techchick and dd. We then have Ambiguous Wanderer, who hasn’t commented here in quite a while, but once was a regular commenter making 11 comments. There are many more commenters I’d like to thank, but frankly there are too many!
As a blogger, I love comments. Its nice to know that you are not only being read but that people are thinking about your writing.
Why, I am honored
Thank you!