Warning:  [mysql error 1] Can't create/write to file '/tmp/#sql-temptable-3de-2dbaab-1955.MAI' (Errcode: 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  (category_id NOT IN (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,36,37,39,43,44,45,46,48,51,52,56,57,58,60,61,62,63,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,98,99,101,102,103,100,97,50,49) AND ic.image_id NOT IN (11900,11901,11902,11903,11904,11905,11906,11907,11908,11909,11910,11911,11912,11913,11914,11915,11916,11917,11918,11922,11923,11924,119 in /mnt/webstorage/web/webroot/www-piwigo/piwigo-11.5.0/include/dblayer/functions_mysqli.inc.php on line 847