Can't execute query

	
		SELECT DISTINCT s.id, s.stijl
		FROM stijlen s, merken m, producten p, categorieen c,
		producten_categorieen pc, producten_stijlen ps, producten_merken pm
		WHERE s.id = ps.stijl_id 
		AND p.id = ps.product_id		
		AND c.id = pc.categ_id
		AND p.id = pc.product_id
		AND pm.product_id = p.id
		AND p.benaming_eng!= ''  AND pm.merk_id = 22 order by s.stijl	
		

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

This script cannot continue, terminating.