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

population of geonames and wikipedia should be in same dimension

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

select geoname.geonameid,geoname.countrycode,geoname.name,title,geoname.population,wp_match.population,abs(geoname.population-wp_match.population)*100/(geoname.population+wp_match.population) as pctdiff,feature,geoname.featurecode from geoname,wp_match,alternatename where wp_match.url=alternatename.name and alternatename.geonameid=geoname.geonameid and wp_match.population>geoname.population and geoname.population>0 and abs(geoname.population-wp_match.population)>1000 and abs(geoname.population-wp_match.population)*100/(geoname.population+wp_match.population)>70 order by pctdiff desc

geonameid	countrycode	name	title	population	population	pctdiff	feature	featurecode