number of errors=0
number of warnings=0
Group=ckgGrpWP
select geonameid,name,countrycode,admincode1 from geoname where featurecode='ADM1' and countrycode in ('AT','CH','DE','DK','ES','FI','FR','GB','IT','NL','NO','SE','US','CA','AU','NZ','JP') and not exists (select 1 from alternatename where geoname.geonameid=alternatename.geonameid and namelocale='link' and name like 'https://en.wikipedia.org/%') and geonameid not in (3143242) order by countrycode
AT,CH,DE,DK,ES,FI,FR,GB,IT,NL,NO,SE,US,CA,AU,NZ,JP
geonameid name countrycode admincode1