Warning:  [mysql error 1] Can't create/write to file '/var/tmp/#sql_6d5_2.MAI' (Errcode: 28 "No space left on device")

SELECT DISTINCT(image_id)
  FROM madebid_image_category
    INNER JOIN madebid_images ON id = image_id
  WHERE
    1=1
AND (category_id NOT IN (3716,6309,6311,6312,6391,5770,6456,6465,6466,6467,6468,6471,6472,6473,6474,6475,6476))
  ORDER BY hit ASC,date_available DESC, file ASC, id ASC
; in /var/www/clients/client1/web76/web/overig/include/dblayer/functions_mysqli.inc.php on line 856