How Web2.0 Marketing Should Be Done
by Patrick Ruffini :: February 17th, 2007 2:24 pmThis morning the Beta Stage came up in my feedreader. I liked their suggestion for a peppier McCain logo.
They had another post on The Shins and successful user-generated video.
I watch the video.
Then I pull up iTunes and buy the song. I’d heard it on the radio before but couldn’t place the title or the artist.
How many more were there like me?
With all the chatter about how marketing sucks, it’s fun and different to tell a story as a consumer about when marketing works. And for me, it’s rarely ever open-point-click-buy.
WordPress database error: [Can't open file: 'ocwp_comments.MYD'. (errno: 144)] WordPress database error: [Can't open file: 'ocwp_comments.MYD'. (errno: 144)] WordPress database error: [Can't open file: 'ocwp_comments.MYD'. (errno: 144)] WordPress database error: [Can't open file: 'ocwp_comments.MYD'. (errno: 144)] WordPress database error: [Can't open file: 'ocwp_comments.MYD'. (errno: 144)] WordPress database error: [Can't open file: 'ocwp_comments.MYD'. (errno: 144)]
Tagged: marketing 
user generated content web2.0
Comments (
SELECT ID, COUNT( comment_ID ) AS ccount
FROM ocwp_posts
LEFT JOIN ocwp_comments ON ( comment_post_ID = ID AND comment_approved = '1' AND comment_type='')
WHERE post_status = 'publish' AND ID IN (36)
GROUP BY ID
SELECT ID, COUNT( comment_ID ) AS ccount
FROM ocwp_posts
LEFT JOIN ocwp_comments ON ( comment_post_ID = ID AND comment_approved = '1' AND comment_type='pingback')
WHERE post_status = 'publish' AND ID IN (36)
GROUP BY ID
SELECT ID, COUNT( comment_ID ) AS ccount
FROM ocwp_posts
LEFT JOIN ocwp_comments ON ( comment_post_ID = ID AND comment_approved = '1' AND comment_type='trackback')
WHERE post_status = 'publish' AND ID IN (36)
GROUP BY ID
Trackbacks (
SELECT ID, COUNT( comment_ID ) AS ccount
FROM ocwp_posts
LEFT JOIN ocwp_comments ON ( comment_post_ID = ID AND comment_approved = '1' AND comment_type='')
WHERE post_status = 'publish' AND ID IN (36)
GROUP BY ID
SELECT ID, COUNT( comment_ID ) AS ccount
FROM ocwp_posts
LEFT JOIN ocwp_comments ON ( comment_post_ID = ID AND comment_approved = '1' AND comment_type='pingback')
WHERE post_status = 'publish' AND ID IN (36)
GROUP BY ID
SELECT ID, COUNT( comment_ID ) AS ccount
FROM ocwp_posts
LEFT JOIN ocwp_comments ON ( comment_post_ID = ID AND comment_approved = '1' AND comment_type='trackback')
WHERE post_status = 'publish' AND ID IN (36)
GROUP BY ID
del.icio.us 
digg it 
subscribe
You can leave a response, or trackback from your own site.
WordPress database error: [Can't open file: 'ocwp_comments.MYD'. (errno: 144)]
SELECT * FROM ocwp_comments WHERE comment_post_ID = '36' AND comment_approved = '1' ORDER BY comment_date
