2025-03-02     2025-03-03     2025-03-04

cities1000 with Wikipedia link have valid admincode1

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

select countrycode,name,geonameid,population,admincode1,featurecode,relevance from geoname where isCities1000 and (not isCities5000 or isCities5000 is null) and featurecode<>'PPLC' and (admincode1 is null or admincode1='00' or not exists (select 1 from geoname b where b.countrycode=geoname.countrycode and b.admincode1=geoname.admincode1 and b.featurecode='ADM1'))and i18nname like '%en.wikipedia.org%' and countrycode in (select distinct countrycode from geoname where featurecode='ADM1' and admincode1<>'00') and geoname.countrycode not in('IL') order by relevance desc

[]

countrycode	name	geonameid	population	admincode1	featurecode	relevance