Warning:  [mysql error 3] Error writing file '/tmp/MYZNqzaD' (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,4,5,6,7,8,9,10,11,13,14,15,16,17,23,24,25,27,28,26,3,22))
  ORDER BY date_available DESC, file ASC, id ASC
; in /var/www/headleyandgnome.co.uk/public_html/photo/include/dblayer/functions_mysqli.inc.php on line 847