Can't execute query

SELECT model.*, br.name as brend, br.id as bid FROM `model` 
					INNER JOIN diskrazmer as tr ON model.id = tr.model_id 
					LEFT JOIN brend as br ON model.brend = br.id 
					WHERE model.`struktura`=1556 AND model.`descriptor`!='ci14'
					ORDER BY RAND() LIMIT 4
					

MySQL Error: Out of resources when opening file '/var/tmp/#sql_4a4_195.MAD' (Errcode: 24)

This script cannot continue, terminating.