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 (835,834)
GROUP BY ID
My buddy Eric passed his last test to be a CPA! Way to go, Lala!
WordPress database error: [Can't open file: 'wp_comments.MYI' (errno: 145)]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 835 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 = '835' 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 = 834 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 = '834' AND comment_approved = '1'