links for 2007-09-29
by Patrick Ruffini :: September 29th, 2007 8:22 am-
Explore.
-
FINALLY
-
For many users, this was more convenient than sending email, but the reason this communication style really took off was because others could see the messages and become engaged - conversations between groups of users could emerge.
WordPress database error: [Can't open file: 'prwp_comments.MYD'. (errno: 144)] WordPress database error: [Can't open file: 'prwp_comments.MYD'. (errno: 144)] WordPress database error: [Can't open file: 'prwp_comments.MYD'. (errno: 144)] WordPress database error: [Can't open file: 'prwp_comments.MYD'. (errno: 144)] WordPress database error: [Can't open file: 'prwp_comments.MYD'. (errno: 144)] WordPress database error: [Can't open file: 'prwp_comments.MYD'. (errno: 144)]
Comments (
SELECT ID, COUNT( comment_ID ) AS ccount
FROM prwp_posts
LEFT JOIN prwp_comments ON ( comment_post_ID = ID AND comment_approved = '1' AND comment_type='')
WHERE post_status = 'publish' AND ID IN (440)
GROUP BY ID
SELECT ID, COUNT( comment_ID ) AS ccount
FROM prwp_posts
LEFT JOIN prwp_comments ON ( comment_post_ID = ID AND comment_approved = '1' AND comment_type='pingback')
WHERE post_status = 'publish' AND ID IN (440)
GROUP BY ID
SELECT ID, COUNT( comment_ID ) AS ccount
FROM prwp_posts
LEFT JOIN prwp_comments ON ( comment_post_ID = ID AND comment_approved = '1' AND comment_type='trackback')
WHERE post_status = 'publish' AND ID IN (440)
GROUP BY ID
Trackbacks (
SELECT ID, COUNT( comment_ID ) AS ccount
FROM prwp_posts
LEFT JOIN prwp_comments ON ( comment_post_ID = ID AND comment_approved = '1' AND comment_type='')
WHERE post_status = 'publish' AND ID IN (440)
GROUP BY ID
SELECT ID, COUNT( comment_ID ) AS ccount
FROM prwp_posts
LEFT JOIN prwp_comments ON ( comment_post_ID = ID AND comment_approved = '1' AND comment_type='pingback')
WHERE post_status = 'publish' AND ID IN (440)
GROUP BY ID
SELECT ID, COUNT( comment_ID ) AS ccount
FROM prwp_posts
LEFT JOIN prwp_comments ON ( comment_post_ID = ID AND comment_approved = '1' AND comment_type='trackback')
WHERE post_status = 'publish' AND ID IN (440)
GROUP BY ID
del.icio.us 
digg it 
subscribe
Both comments and pings are currently closed.
WordPress database error: [Can't open file: 'prwp_comments.MYD'. (errno: 144)]
SELECT * FROM prwp_comments WHERE comment_post_ID = '440' AND comment_approved = '1' ORDER BY comment_date
