23 - Out of resources when opening file '/tmp/#sql_337_0.MYD' (Errcode: 24)

select l2g.link_id, l2g.link_type, l2g.group_id, l2g.link_target, l.link_url, l.link_user, ld.link_description, CASE l2g.link_type WHEN 2 THEN cd.categories_name WHEN 3 THEN m.manufacturers_name WHEN 4 THEN pd.products_name WHEN 5 THEN pad.page_name ELSE ld.link_name END as link_name from mts_links_to_groups l2g left join mts_links l on l.link_id=l2g.link_id and l.link_status='1' left join mts_links_description ld on l.link_id=ld.link_id and ld.language_id = '1' left join categories_description cd on cd.categories_id = l2g.link_id and cd.language_id = '1' left join manufacturers m on m.manufacturers_id = l2g.link_id left join products p on p.products_id = l2g.link_id and p.products_status='1' left join products_description pd on pd.products_id = p.products_id and pd.language_id = '1' left join mts_pages pa on pa.page_id = l2g.link_id and pa.page_status='1' left join mts_pages_description pad on pad.page_id = pa.page_id and pad.language_id = '1' order by l2g.sort_order, link_name