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