WordPress database error: [Can't open file: 'wp_comments.MYI' (errno: 145)]
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 (605,604)
GROUP BY ID
Thanks to Ali for the pics of Brooks and me making brownies (or “brownie cake,” as Brooks calls it) over Christmas!
WordPress database error: [Can't open file: 'wp_comments.MYI' (errno: 145)]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 605 AND comment_approved = '1';
WordPress database error: [Can't open file: 'wp_comments.MYI' (errno: 145)]
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '605' AND comment_approved = '1'
WordPress database error: [Can't open file: 'wp_comments.MYI' (errno: 145)]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 604 AND comment_approved = '1';
WordPress database error: [Can't open file: 'wp_comments.MYI' (errno: 145)]
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '604' AND comment_approved = '1'