The Mother of All Pingbacks

Warning: this content is older than 365 days. It may be out of date and no longer relevant.

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!

Comments

61 responses to “The Mother of All Pingbacks”

  1. Pat Phelan Avatar

    and right back at ya Chris

  2. Pat Phelan Avatar

    and right back at ya Chris

  3. Matthew W Ebel Avatar

    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.

  4. Matthew W Ebel Avatar

    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.

  5. Christopher S. Penn Avatar

    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.

  6. Christopher S. Penn Avatar

    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.

  7. Chris Van Patten Avatar

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

  8. Chris Van Patten Avatar

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

  9. Bernie/Vinny Avatar

    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!

  10. Bernie/Vinny Avatar

    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!

  11. Justine Avatar

    Haha! Awesome. You rock.

  12. Justine Avatar

    Haha! Awesome. You rock.

  13. Jason @ Insomnia Radio Avatar

    That is one DAMN fine trick 🙂

  14. Jason @ Insomnia Radio Avatar

    That is one DAMN fine trick 🙂

  15. Eric Skiff Avatar

    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 🙂

  16. Eric Skiff Avatar

    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 🙂

  17. Rich Palmer Avatar

    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

  18. Rich Palmer Avatar

    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

  19. Chris (Amateur Traveler podcas Avatar

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

  20. Chris (Amateur Traveler podcast) Avatar

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

  21. […] the cobbler and defeat the footless, how to market a podcast, audience multipliers vs. star power, Chris’ blog comment link generator, what’s a trackback in real life? LinkedIn, What makes a great Marketeer? artists vs. […]

  22. […] Person thought up a great idea – use the idea behind the Massive Pingback and 2K Bloggers to give link love to everyone attending PodCamp Boston 2 that has publicly allowed […]

  23. […] Chris Penn did a mother of all pingbacks a month ago. Let’s see if I can top his list. Here’s the list of podcasters profiled in […]

  24. koby vyzel Avatar

    very nice, wish i had commented earlier=)

  25. koby vyzel Avatar

    very nice, wish i had commented earlier=)

  26. koby vyzel Avatar

    very nice, wish i had commented earlier=)

    1. free no deposit bingo Avatar

      me too the comments are so lively!

    2. Holidays Avatar

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

    3. Home Improvement Avatar

      Nice list shared. Thanks mate. Keep it up!

  27. Bungie Avatar

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

  28. Company Logo Avatar

    Sounds interesting… thanks.. 🙂

  29. Sarah Avatar

    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.

  30. Unlock any iPhone Avatar

    great site ! count me for the comments

  31. granite Avatar

    Wow – that’s awesome!

  32. Banner Ads Avatar

    i have only one word WOW

  33. Countertop Avatar
  34. Car Finance Avatar

    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.

  35. Meta Expires Avatar

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

  36. phone cards Avatar

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

  37. Rowing Machines Avatar

    Wow, awesome list.. very helpful indeed.
    Thanks

  38. No Credit Auto Loan Avatar

    The List is really good

    I truly appreciate your effort of collecting this URLs.

  39. Dreamweaver meta tags Avatar

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

  40. Internet Marketing Consultant Avatar

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

  41. Jenny Myers Avatar

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

    Cheers,
    Jenny Myers

  42. Jenny Myers Avatar

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

    Cheers,
    Jenny Myers

  43. Jenny Myers  Avatar

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

    Cheers,
    Jenny Myers

  44. furniture Avatar

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

  45. James keller @ Bridal Showers Avatar

    Great trick mate! Guess I should have commented earlier.

  46. James keller @ Bridal Showers Avatar

    Great Trick mate! Guess I should have commented earlier.

  47. cheap web hosting Avatar

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

  48. Match Avatar

    that’s pretty awesome

  49. Cokee Avatar

    Thanks for Story

  50. Home tution for all subjects Avatar

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

    Thanks

  51. Breaking News Avatar

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

  52. Treuemax Avatar
    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!

  53. Treuemax Avatar
    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!

  54. Treuemax Avatar
    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!

  55. kutsem Avatar
    kutsem

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

Leave a Reply

Your email address will not be published. Required fields are marked *

Pin It on Pinterest

Shares
Share This