WordPress database error: [Can't open file: 'wp_comments.MYI' (errno: 144)]
SELECT ID, COUNT( comment_ID ) AS ccount
FROM wp_posts
LEFT JOIN wp_comments ON ( comment_post_ID = ID AND comment_approved = '1')
WHERE ID IN (104)
GROUP BY ID
the blog of DC Drinking Liberally
Though last place is very good in this case. According to the California Energy Commission, DC has the lowest per capita gas consumption. At 214.4 gals/person, DC is well below half the national average of 470.6.
Congratulations DC for getting the lead out. Granted it’s in the water supply now, but it’s a start.
Via Metroblogging DC
WordPress database error: [Can't open file: 'wp_comments.MYI' (errno: 144)]
SELECT * FROM wp_comments WHERE comment_post_ID = '104' AND comment_approved = '1' ORDER BY comment_date
Subscribe to an announcement list (or more than one) so you’ll always know what’s going on:
WordPress database error: [Can't open file: 'wp_comments.MYI' (errno: 144)]
SELECT * FROM wp_comments LEFT JOIN wp_posts ON wp_posts.ID=wp_comments.comment_post_ID WHERE (post_status = 'publish' OR post_status = 'static') AND comment_approved= '1' AND post_password = '' AND comment_type = '' ORDER BY comment_date DESC LIMIT 10
39 queries. 0.665 seconds