WordPress database error: [Disk full (/var/tmp/#sql_402_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT count( * ) AS num, ID, p.post_title
FROM wp_posts p
USE INDEX (
PRIMARY ) , wp_comments c
WHERE p.post_author = 397
AND p.ID = c.comment_post_ID
GROUP BY p.ID
ORDER BY num DESC
LIMIT 10
WordPress database error: [Disk full (/var/tmp/#sql_402_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT c.comment_ID, c.comment_post_ID, c.comment_content ,comment_approved
FROM wp_posts p, wp_comments c
WHERE p.post_author =397
AND c.comment_approved = '1'
AND p.id = c.comment_post_id
ORDER BY c.comment_id DESC
LIMIT 0 , 10
