I have a table which contains towns and municipalities in Spain.
I want users to select a distinct geonameid which corresponds to a town or municipality.
If the municipality asciiname is the same as a town name, i just want the municipality.
This query is incorrect as it returns both the town and municipalities.
select distinct geonameid, asciiname from geo_import where (feature_code = 'ADM3' OR feature_code = 'PPL') AND province_id = '2509951' order by asciiname asc