Warning:  [mysql error 1021] Disk full (/tmp/#sql_337_0.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 phpwebgallery_image_category AS ic
    INNER JOIN phpwebgallery_comments AS com
    ON ic.image_id = com.image_id
    LEFT JOIN phpwebgallery_users As u
    ON u.id = com.author_id
  WHERE 1=1
    AND validated='true'
    AND  (category_id NOT IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,37,38,39,40,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,59,60,61,62,64,66,67,69,71,72,73,74,75,76,77,80,81,82,83,84,85,86,87,89,90,91,92,93,94,95,96,97,100,102,104,105,108,109,110,130,131,132,133,135) AND ic.image_id NOT IN (6614,6615,6616,6617,6618,6668,6669,6670, in /var/www/piwigo/include/dblayer/functions_mysqli.inc.php on line 847