Can't execute query

	
		SELECT DISTINCT m.id, m.merk
		FROM merken m, stijlen s, prijsklasses pk, categorieen c, producten p, 
		producten_merken pm, producten_stijlen ps, producten_categorieen pc, producten_prijsklasses prpr
		WHERE m.id = pm.merk_id		
		AND p.id = pm.product_id		
		AND c.id = pc.categ_id
		AND p.id = pc.product_id
		AND ps.product_id = p.id
		AND s.id = ps.stijl_id 
		AND p.id = prpr.product_id
		AND pk.id = prpr.prijs_id
		AND p.benaming_fra!= ''  AND ( c.id = 7 OR c.parent_id = 7 ) order by m.merk
		

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

This script cannot continue, terminating.