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.

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

About Douglas Karr

Douglas Karr is the founder of The Marketing Technology Blog. Doug is President and CEO of DK New Media, an online marketing company specializing in inbound marketing leveraging social media, blogging, search engine optimization, pay per click and public relations. Their clients include Angie's List, Mindjet, Webtrends, ChaCha and many more. Douglas is also the author of Corporate Blogging for Dummies. If you're interested in having Douglas speak, please propose an event!

View all posts by Douglas Karr →

Note: Comments are welcome from real people, not companies. Most comments with links will be deleted.

http://loszieglerencanada.com/ Guillermo

Thank you Douglas for your great blog! Happy Thanksgiving!
http://clarkspicks.com Clark

Thank you! We all enjoy and learn from your blog. The link love was nice, too.
http://www.digitalstreetjournal.com Jonathan Trenn

You’re welcome!
http://leedoyle.com Lee Doyle

Thanks for the mention man

We don’t have thanksgiving here in the UK but… Happy Thanksgiving
http://mtherald.com/ Raj – MT Herald

Thanx Douglas for remembering us and mentioning here on this Thanks Giving Day.
http://alpesh.nakars.com/blog Alpesh Nakar

Doug,
Happy Thanksgiving. Appreciate your mention.

Cheers!
http://www.marketing.fm Eric Friedman

Hey thanks for having such great content.

How did you generate this list? I would love to do the same thing on my blog.
http://www.workingauthor.com/ René Garcia, Jr.

Amigo! Thanks for the shout out. I think a little community can go a long way. I’ll stop by again.

René
http://www.workingauthor.com
http://www.jeayese.com Jase

Thanks also for the mention man.. Hope you are having a wonderful thanksgiving.
http://modifoo.com modifoo

You might want to filter the list for URLs Seems like I am a split personality…
http://www.mkyong.com mkyong

nice trick ~ thanks for mention
http://www.noobie.com Patric Welch

Thanks for the mention Doug. And I swear I’m not just saying this to increase my commenter count by 1
http://lgbusinesssolutions.typepad.com/solutions_to_grow_your_bu/ Lewis Green

Doug,

You are so kind. Thanks for being your Doug. And thanks for teaching us so much.
http://www.webinknow.com/ David Meerman Scott

I’m impressed. This post must have taken a long time to do!
http://StopPoliticalCalls.org Shaun Dakin

Thanks! Happy Thanksgiving!
http://fruityoaty.com fruityoaty

Thanks for the mention! I did something like that months ago (when my block reached over 2000 comments). Always good to give love back.
http://www.ggci-blog.com/ Bary Zweibel

Thanks for the thanks, Doug. Keep up the good work!
http://chipsquips.com Sterling Camden

You’re so welcome!

I wonder if my two entries were combined if I would rank higher on the list…
http://atniz.com Atniz

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.
http://www.annhandley.com Ann Handley

Wow that’s a lot of thank yous!!

Happy Thanksgiving, Doug.
http://beth,typepad.com Beth Kanter

Happy Thanksgiving and thank you to you!
http://tonychung.ca Tony Chung

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
http://momscashblog.com jj-momscashblog

Hi Doug, Great blog you have here, I did not see my name but I had a link saying there was a link so I’m thanking you for the link love. Happy Thanksgiving to you too!
http://www.localseoguide.com Andrew Shotland

Thanks for the mention Doug. Glad to see more people are picking up the “SEO for Xmas” idea!
http://flooringtheconsumer.blogspot.com C.B. Whittemore

Doug, I hope you had a wonderful Thanksgiving! Thanks for the sharing and wisdom you offer. May your readership increase even more!
http://www.sharpdeveloper.net Sameer Alibhai

Thank you for the link. I’m a software developer but marketing is essential to me for personal branding, etc..
http://askax.net Andika Kusuma

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
http://www.theblogworld.net/ Amy

Thanks for the link
http://www.doozieup.com emdoozie | Michael Anderson

Thanks for the link, and thank you for the great insight you provide here helping us new and veteran bloggers find our way through this thing we call the web.

-doozieUp!
http://www.whoismadhur.com Madhur Kapoor

Thanks for the Link Doug. Happy ThanksGiving
http://total.eclipse.co.il Shay

Much obliged, good sir.
http://blog.scoop0901.net Dave J. (Scoop0901)

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)
http://www.momsjournal.org Erica

Thanks so much for the link!
http:/www.lancecorner.com junior

Hi Doug!

Thanks for adding my blog site http://www.lancecorner.com.

I really love reading your blog posts

Keep up the good works!
http://www.lendo.org André

Thanks Douglas! Happy Thanksgiving!
http://www.seo-mind.com Danny Sam

Hey Doug!!

Thanks for the mentioning!! Thats really sweet of you!! A true thanksgiver

Danny
http://www.successchronicle.com Tray Gamble

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
http://www.iddaa.info/ iddaa

Thanks so much for the link
http://www.squishdesigns.com Nicki Laycoax

A little late, but thanks for mentioning my name! You’re great, Doug.
http://www.reknova.de/ michael.S

Thanks for the link

About Douglas Karr

Information regarding cookies