«
»

Thank You!

Posted in Blogging, Homefront, WordPress by Douglas Karr Thursday, November 27th at 11:46 am

I have so much to be thankful for this Thanksgiving… healthy and exceptional children, fantastic friends, and a dream job. As for my blog, the person I owe the most thanks to is YOU! Here is a list of commentors on my blog (in order of number of comments!). Your engagement in this blog is the driving force behind the quality of content that I try to put here day after day.

If you’re wondering how I did this, I ran the following SQL statement against my wordpress database:

SELECT CONCAT('<li><a href="',`comment_author_url`,'">',`comment_author`,'</a><li>') FROM `wp_comments` WHERE `comment_approved` = 1 AND comment_author_url <>'' AND comment_author <>'Douglas Karr' AND comment_type = '' GROUP BY `comment_author`, `comment_author_email` ORDER BY COUNT(`comment_ID`) DESC

You might also find these posts interesting: