The Mother of All Pingbacks

Posted by on Jul 29, 2007 in Blogging, Uncategorized | 57 comments

Working off an idea from John Wall and David Meerman Scott, here’s a massive list of everyone who has left me a comment on my blog (or in some cases, a pingback). This list was compiled from the MySQL database that powers my WordPress blog, with the query:

SELECT DISTINCT `comment_author` , `comment_author_url`
FROM csp891_comments
ORDER BY `comment_author` ASC

I stuffed the output into Excel, did a little cleanup, and here we are. Thanks to everyone who has participated in the past few months to make this blog what it is.

Updated: The DoFollow Plugin is also enabled. Google Juice for everyone!

  • http://blog.roam4free.ie Pat Phelan

    and right back at ya Chris

  • http://blog.roam4free.ie Pat Phelan

    and right back at ya Chris

  • http://www.matthewebel.com Matthew W Ebel

    So what does this teach us? Use a different name every time you comment so that when someone posts a list like this you get more than one pingback.

  • http://www.matthewebel.com Matthew W Ebel

    So what does this teach us? Use a different name every time you comment so that when someone posts a list like this you get more than one pingback.

  • http://www.ChristopherSPenn.com Christopher S. Penn

    Well, until I write a script that will extract only the domain name of the blog itself… then I’ll sort on URL, not name.

  • http://www.ChristopherSPenn.com Christopher S. Penn

    Well, until I write a script that will extract only the domain name of the blog itself… then I’ll sort on URL, not name.

  • http://chrisvanpatten.com/blog/ Chris Van Patten

    Wow – that’s awesome! What a neat idea and a cool gesture to say thanks. The link is appreciated!

  • http://chrisvanpatten.com/blog/ Chris Van Patten

    Wow – that’s awesome! What a neat idea and a cool gesture to say thanks. The link is appreciated!

  • http://worldofbernie.com Bernie/Vinny

    Chris- great of you to remember us all. I’m always fascinated to hear what you will say, both in the blog and on the podcast. Thanks for sharing your time and energy. See you at Podcamp NYC #2! Whoo hoo!

  • http://worldofbernie.com Bernie/Vinny

    Chris- great of you to remember us all. I’m always fascinated to hear what you will say, both in the blog and on the podcast. Thanks for sharing your time and energy. See you at Podcamp NYC #2! Whoo hoo!

  • http://www.tastyblogsnack.com Justine

    Haha! Awesome. You rock.

  • http://www.tastyblogsnack.com Justine

    Haha! Awesome. You rock.

  • http://insomniaradio.net Jason @ Insomnia Radio

    That is one DAMN fine trick :-)

  • http://insomniaradio.net Jason @ Insomnia Radio

    That is one DAMN fine trick :-)

  • http://glitchnyc.com Eric Skiff

    This is brilliant. While I understand the need for rel=nofollow, I hate that we lose the ability to legitimately share google mojo with eachother because of it. Doing a manual linkback like this helps solve that. Very cool.

    This might be fun to turn into a wordpress plugin. Drop me an email if you’re interested in fleshing it out, I’ve done a plugin or two before :)

  • http://glitchnyc.com Eric Skiff

    This is brilliant. While I understand the need for rel=nofollow, I hate that we lose the ability to legitimately share google mojo with eachother because of it. Doing a manual linkback like this helps solve that. Very cool.

    This might be fun to turn into a wordpress plugin. Drop me an email if you’re interested in fleshing it out, I’ve done a plugin or two before :)

  • http://www.richpalmer.com/blog Rich Palmer

    Hey Chris, fantastic setup! Thanks for the Google juice and for the inclusion on the mega-pingback. Always great to see another tool to help us with connectivity.

    -Rich

  • http://www.richpalmer.com/blog Rich Palmer

    Hey Chris, fantastic setup! Thanks for the Google juice and for the inclusion on the mega-pingback. Always great to see another tool to help us with connectivity.

    -Rich

  • http://AmateurTraveler.com Chris (Amateur Traveler podcas

    I would be concerned that this would reward comment spam and I see you already have some in response to this posting.

  • http://AmateurTraveler.com Chris (Amateur Traveler podcast)

    I would be concerned that this would reward comment spam and I see you already have some in response to this posting.

  • Pingback: Marketing Over Coffee Marketing Podcast » Blog Archive » Defeeting the Shoeless

  • Pingback: Look who’s coming to dinner… or PodCamp Boston 2

  • Pingback: Podonomics » Blog Archive » The Podcasting for Profit Rock Stars

  • http://meta-image.110mb.com koby vyzel

    very nice, wish i had commented earlier=)

  • http://meta-image.110mb.com koby vyzel

    very nice, wish i had commented earlier=)

  • http://meta-image.110mb.com koby vyzel

    very nice, wish i had commented earlier=)

    • http://www.freenodepositbingo.co.uk free no deposit bingo

      me too the comments are so lively!

    • http://www.cheapturkey.org.uk Holidays

      me too . its a very nice blog .next time maybe

    • http://ehomeimprovement.org/ Home Improvement

      Nice list shared. Thanks mate. Keep it up!

  • http://www.bungiesucks.com/ Bungie

    What a nice list. I’m new and I will do my best to be in your list next time ;)

  • http://www.getyourlogos.com Company Logo

    Sounds interesting… thanks.. :)

  • http://sarahpaine.org Sarah

    You have compiled an excellent list! I just came across a list of roughly 1200 do follow blogs which is great to build links but also to give away in order to build an strong mailing list off of a blog or website! You can snag it here http://www.rishabhsood.net/dofollow-blogs.txt you don’t even have to download them as they are displayed as a website. Thanks for the list.

  • http://nayna.in/blog Nayna

    Count me in.

  • http://www.unlock-the-iphone.com Unlock any iPhone

    great site ! count me for the comments

  • http://www.stonematrix.com/ granite

    Wow – that’s awesome!

  • http://www.buycountertop.com/ Marble

    nice post

  • http://www.oogleads.com/ Banner Ads

    i have only one word WOW

  • http://www.countertopmatrix.com/ Countertop

    WOW.GREAT AWESOME

  • http://www.carmoneyrealfast.com/ Car Finance

    This is something what you can really rely on…! Since long time I look here at regular intervals and read the interesting and well written contributions. Its really appreciating.

  • http://www.webmarketingnow.com/tips/meta-tags-meta-expires.html Meta Expires

    Congratulations mate for this good written article, there is good info in it.keep up the great work…Thanks…

  • http://www.comfi.com phone cards

    Awesome, such a long list, thanks for this ecxellent post.

  • http://www.shopfitness.co.uk/rowing-machines-rowers/ Rowing Machines

    Wow, awesome list.. very helpful indeed.
    Thanks

  • http://www.auto-financed.com/ No Credit Auto Loan

    The List is really good

    I truly appreciate your effort of collecting this URLs.

  • http://www.webmarketingnow.com/tips/meta-tags-uncovered.html Dreamweaver meta tags

    Thanks a lot ……..!
    this blog is really informative…………………!

  • http://www.websproutconsulting.com Internet Marketing Consultant

    What a long and awesome list. it proved to be really helpful to me. thanks a lot/

  • http://ministoragehouston.com Jenny Myers

    Hi Christopher,
    It is a cool idea & more helpful for me to maintain my blogsite,
    Supeb idea,

    Cheers,
    Jenny Myers

  • http://ministoragehouston.com Jenny Myers

    Hi Christopher,
    It is a cool idea & more helpful for me to maintain my blogsite,
    Supeb idea,

    Cheers,
    Jenny Myers

  • http://ministoragehouston.com Jenny Myers

    Hi Christopher,
    It is a cool idea & more helpful for me to maintain my blogsite,
    Supeb idea,

    Cheers,
    Jenny Myers

  • http://www.larasfurniture.com furniture

    Very long list people. Nice try…Thank’s a lot

  • http://www.wowmycash.com coolbudy

    awesome idea

  • http://www.utredcrossclub.org James keller @ Bridal Showers

    Great trick mate! Guess I should have commented earlier.

  • http://www.utredcrossclub.org James keller @ Bridal Showers

    Great Trick mate! Guess I should have commented earlier.

  • http://www.webhostbutler.com cheap web hosting

    Nice post dude, keep on comming with such decent stuff.

  • http://www.notoriouslysingle.com/forums/showthread.php?t=170 Match

    that’s pretty awesome

  • http://www.mycokerewardscom.co.cc Cokee

    Thanks for Story

  • http://www.go4tution.com Home tution for all subjects

    Nice Site. I am new here but will be visiting more often as you have done a good job.

    Thanks

  • http://bgconsortium.com/ Breaking News

    Thanks For Informations..I Like U post..!!

  • Treuemax

    Chris- great of you to remember us all. I'm always fascinated to hear what you will say, both in the blog and on the podcast. Thanks for sharing your time and energy. See you at Podcamp NYC #2! Whoo hoo!

  • Treuemax

    Chris- great of you to remember us all. I'm always fascinated to hear what you will say, both in the blog and on the podcast. Thanks for sharing your time and energy. See you at Podcamp NYC #2! Whoo hoo!

  • Treuemax

    Chris- great of you to remember us all. I'm always fascinated to hear what you will say, both in the blog and on the podcast. Thanks for sharing your time and energy. See you at Podcamp NYC #2! Whoo hoo!