number of errors=0
number of warnings=0
select countrycode,name,geonameid,population,admincode1,featurecode,relevance from geoname where population>15000 and featurecode='PPL' 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 countrycode in (select distinct countrycode from geoname where featurecode='ADM1' and admincode1<>'00') order by population desc
[]
countrycode name geonameid population admincode1 featurecode relevance