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…





About

Welcome to femgeek. This could be described as a lifestyle blog, if your lifestyle included photography, learning japanese, html, css, javascript, PHP, Photoshop, Wordpress and the raspberry pi that is.

Read more…


You can search this site by entering any term into the box above. You can also browse the Archive and Category pages.
If you would like to subscribe to this site via RSS please click here.


Categories & Archives