Expression #1 of ORDER BY clause is not in SELECT list, references column 'bd-eur-info.towns.id' which is not in SELECT list; this is incompatible with DISTINCT