Query:
select concat(t.short_name, ' (', tn.name, ', ', c.name, ')') as teamcapt, t.country from teams t, towns tn, countries c where t.id = '297' and tn.id = t.town and c.id = tn.country
error: Can't open file: './fb/towns.frm' (errno: 24)