List of Top Commenters in wordpress

If you’d like your own list of top commenters for 2010 here is the SQL. SELECT comment_author, comment_author_url, comment_date, comment_approved, count(comment_author_url) as n FROM wp_comments WHERE comment_date > ’2010-01-01 00:00:00′ AND comment_approved = 1 GROUP BY comment_author_url ORDER BY n DESC The sections marked in red may need changing – if you changed your DB

Continue reading List of Top Commenters in wordpress…