Warning:  [mysql error 3] Error writing file '/tmp/MYnMD3PA' (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 (2,12,14,17,18,19,20,21,22,23,50,62,71,78,79,80,82,86,87,88,91,93,97,103,104,105,106,108,116) AND level<=0)
  ORDER BY date_creation DESC, file ASC, id ASC
; in /var/www/vhosts/rohanrao.com/httpdocs/gallery/include/dblayer/functions_mysqli.inc.php on line 847