Warning:  [mysql error 3] Error writing file '/tmp/MYsAkFN2' (Errcode: 28 - No space left on device)

SELECT DISTINCT(image_id)
  FROM piwigo_image_category
    INNER JOIN piwigo_images ON id = image_id
  WHERE
    1=1
AND (category_id NOT IN (39,41,40,42,43) AND level<=0)
  ORDER BY name ASC,date_available DESC, file ASC, id ASC
; in /var/www/html/piwigo/include/dblayer/functions_mysqli.inc.php on line 847