24 Premiere Now On DVD & iTunes
by Patrick Ruffini :: January 16th, 2007 11:15 pmThis is the kind of thing I was talking about earlier. Creative tie-ins between freely available content and paid extras for those who want it. The “24″ premiere that aired over the last two nights is now available for purchase as a DVD and for download on iTunes.
Strangely enough, I’m not (yet) a “24″ fanatic, but this gives me a perfect excuse to start.
Via Rex.
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: 24 
dvd fox itunes
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 (23)
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 (23)
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 (23)
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 (23)
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 (23)
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 (23)
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 = '23' AND comment_approved = '1' ORDER BY comment_date
