2025-03-01     2025-03-02     2025-03-03

each wikipedia article should be linked to only one ADM2

number of errors=0
number of warnings=0
Group=ckgGrpWP

select geoname.geonameid,alternatename.name,featurecode,geoname.name,geoname.countrycode from geoname,alternatename where alternatename.name in (select alternatename.name from geoname,alternatename where geoname.geonameid=alternatename.geonameid and alternatename.namelocale='link' and alternatename.name like '%wikipedia%' and featureclass='A' and featurecode='ADM2' group by alternatename.name having count(*)>1) and featureclass='A' and featurecode='ADM2' and geoname.geonameid=alternatename.geonameid order by alternatename.name

geonameid	name	featurecode	name	countrycode