2025-03-04     2025-03-05     2025-03-06

cities5000 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 isCities5000 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 geonameid not in (443093,1819609,12747063,12747064) order by relevance desc

[]

countrycode	name	geonameid	population	admincode1	featurecode	relevance