each wikipedia article should be linked to only one ADM1

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='ADM1' group by alternatename.name having count(*)>1) and featureclass='A' and featurecode='ADM1' and geoname.geonameid=alternatename.geonameid order by alternatename.name

geonameid	name	featurecode	name	countrycode