number of errors=1
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
[{key=BD,number=1}]
countrycode name geonameid population admincode1 featurecode relevance BD Chāndpur 1201871 203436 00 PPL 10