Can't execute query

SELECT dr.*,bp.nadb,bp.tip as tp
								FROM diskrazmer dr
								LEFT JOIN brendprice bp ON bp.intmin < dr.price2 AND bp.intmax >= dr.price2 AND bp.sezon = dr.tip AND bp.struktura=28
								WHERE dr.model_id=321287 AND dr.ostatok > 0 AND
								(dr.archive='b' OR dr.sale='yes') 
								ORDER BY dr.diametr,dr.width,dr.pcd,dr.price 

MySQL Error: Out of resources when opening file './vseshini/diskrazmer.MYD' (Errcode: 24)

This script cannot continue, terminating.