This is a nifty piece of SQL for finding out exactly who entered the five hundredth comment on your blog, assuming you have a WordPress blog with five hundred comments on it.
FROM "WordPress comment table"
ORDER BY comment_date
LIMIT 500 , 1
Right now, I don’t have a 500th comment, but it’s getting close. Well within a hundred type of close. The comment count started on 20th November 2004 when I first moved to WordPress, and I think 500 comments is worth celebrating with a gift for the commenter. Who’s it going to be? (The gift will have to be decided after the comment arrives, since I doubt Mr Bristow would appreciate yarn if it happens to be him.)