Query:
select concat(t.short_name, ' (', tn.name, ', ', c.name, ')') as teamcapt,
t.country
from teams t, towns tn, countries c
where t.id = '724' and tn.id = t.town and c.id = tn.country
error: Out of resources when opening file './fb/countries.MYD' (Errcode: 24)