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`=1431 AND model.`descriptor`!='916'
					ORDER BY RAND() LIMIT 3
					

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

This script cannot continue, terminating.