2025-03-04     2025-03-05     2025-03-06

nuts country prefix same as associated feature

number of errors=0
number of warnings=0
Group=chkGrpNuts

select geoname.geonameid,geoname.countrycode,alternatename.name from geoname,alternatename where geoname.geonameid=alternatename.geonameid and alternatename.namelocale='nuts' and alternatename.name not like replace(countrycode,'GR','EL')||'%'

geonameid	countrycode	name