Warning:  [mysql error 1] Can't create/write to file '/var/tmp/#sql_8fb_0.MAI' (Errcode: 28)

SELECT DISTINCT(image_id)
  FROM piwigo_image_category
    INNER JOIN piwigo_images ON id = image_id
  WHERE
    1=1
AND (category_id NOT IN (98,1) AND level<=0)
  ORDER BY date_available DESC, file ASC, id ASC
; in /home/www/html/peirwiki/library/include/dblayer/functions_mysqli.inc.php on line 845