This clip clocks in at more than six minutes, but it’s worth it for the following reasons:
Enjoy!
WordPress database error: [Can't open file: 'wp_comments.MYI' (errno: 145)]
SELECT * FROM wp_comments WHERE comment_post_ID = '80' AND comment_approved = '1' ORDER BY comment_date
WordPress database error: [Can't open file: 'wp_comments.MYI' (errno: 145)]
SELECT COUNT(comment_author) AS comment_comments, comment_author
FROM wp_comments
WHERE DATE_FORMAT(comment_date, '%Y-%m') = DATE_FORMAT(CURDATE(), '%Y-%m')
AND comment_author NOT IN('Anonymous Communist')
AND comment_author != ''
AND comment_type != 'pingback'
AND comment_approved = '1'
GROUP BY comment_author
ORDER BY comment_comments DESC LIMIT 6
