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

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

This script cannot continue, terminating.