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`=30 AND model.`descriptor`!='valdaj_33104'
					ORDER BY RAND() LIMIT 4
					

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

This script cannot continue, terminating.