Can't execute query

SELECT model.*, br.name as brendname, model_kovrik.primen, model_kovrik.material, model_kovrik.model as modelname, model_kovrik.proizvod FROM `model`
						LEFT JOIN `model_kovrik` ON `model`.`id`=`modelid` 
						LEFT JOIN brend as br ON model.brend = br.id 
						WHERE model.`struktura`=147 AND model.`descriptor`!='toyotanplp8835'
						ORDER BY RAND() LIMIT 4
						

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

This script cannot continue, terminating.