Warning:  [mysql error 1021] Disk full (/tmp/#sql_10d_9.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")

SELECT SQL_CALC_FOUND_ROWS com.id AS comment_id,
       com.image_id,
       ic.category_id,
       com.author,
       com.author_id,
       u.mail_address AS user_email,
       com.email,
       com.date,
       com.website_url,
       com.content,
       com.validated
  FROM piwigo_image_category AS ic
    INNER JOIN piwigo_comments AS com
    ON ic.image_id = com.image_id
    LEFT JOIN piwigo_users As u
    ON u.id = com.author_id
  WHERE 1=1
    AND validated='true'
    AND  1 = 1
  GROUP BY comment_id
  ORDER BY date DESC
  LIMIT 10 OFFSET 242900
; in /var/www/html/piwigo/include/dblayer/functions_mysqli.inc.php on line 847