WordPress

Thank You!

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.

  1. Mike Schinkel
  2. modifoo
  3. Martin Weiss
  4. Steven Hodson
  5. engtech
  6. Ade
  7. JD
  8. AL
  9. Brandon Wood
  10. William Tully
  11. Sterling Camden
  12. TechZ
  13. Martin
  14. Patric Welch
  15. Small Business Marketing
  16. Duane Brown
  17. Dean Taplin
  18. Yvonne
  19. Derek
  20. Thor Schrock
  21. Julie Hunter
  22. Pat Coyle
  23. Nick Halstead
  24. Tony Chung
  25. Blog Bloke

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

40 Comments

  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  15. 15
  16. 16
  17. 17
  18. 18
  19. 19

    This is great list of commentators. I have never seen anyone would post the link love to all their commentators. Surely, this is one great thanksgiving post I read today.

  20. 20
  21. 21
  22. 22

    Hi Doug,

    It was a nice surprise to your linkback in my dashboard. Ain’t SQL fun?

    Happy Thanksgiving to you, too. We had our turkey up here in Canada last month.

    Cheers,
    -Tony

  23. 23
  24. 24
  25. 25
  26. 26
  27. 27

    Thanks of for the link Doug, its been a while not seeing your blog, I notice the link from my dashboard, and I was surprise because I wonder how you can list all your commentators… But now I know how to do it! 😀

    I read ur blog from Google Reader, thanks again for your great articles.

    Cheers,

    Andika

  28. 28
  29. 29
  30. 30
  31. 31
  32. 32

    Doug, thanks for the mention in your Thanksgiving post. It was a really unique post, and when I noticed the link in my WordPress dashboard, it caught me by surprise.

    Keep up the great work, as well as bringing some great insight via your blog.

    Have a great finish to 2008 and may 2009 bless you even more with more to be thankful for a year from now.

    Cheers,
    Dave J. (Scoop0901)

  33. 33
  34. 34
  35. 35
  36. 36
  37. 37

    Hi Doug,

    It was so thoughtful of you to give back to your site friends and visitors in this unexpected way. I enjoy the content on your blog, although I’ve been out of the visiting loop for a while. Your random act of human kindness showing up in my dashboard link backs brought me a much needed “warm fuzzy” and a smile.

    Your blog’s a keeper! Again, I really appreciate you. Continued blessings and growth in all your endeavors.

    Tray

  38. 38
  39. 39
  40. 40

Leave a Reply