number of errors=20
number of warnings=0
country=BD
select countrycode,name,geonameid,admincode1,admincode2,admincode3,featureclass,featurecode,relevance from geoname where countrycode in ('BD') and not featureCode in ('ADM1H','ADM2H','ADM3H','ADM4H','ADM5H','ADMD') and admincode1 is not null and admincode1<>'00' and admincode2 is not null and admincode3 is not null and not exists (select 1 from geoname b where b.countrycode=geoname.countrycode and b.admincode1=geoname.admincode1 and b.admincode2=geoname.admincode2 and b.admincode3=geoname.admincode3 and b.featurecode='ADM3' and b.countrycode in ('BD')) order by countrycode,admincode1,admincode2,admincode3
countrycode name geonameid admincode1 admincode2 admincode3 featureclass featurecode relevance BD North Tiākhāli 13407747 82 1004 100409 P PPL 0 BD Nilganj 13407748 82 1004 100409 P PPL 0 BD Paschim Char Umed 13407730 82 1009 100925 P PPL 0 BD Uttar Char Mādrās 13407731 82 1009 100925 P PPL 0 BD Dakshin Char Fasson 13407733 82 1009 100925 P PPL 0 BD Uttar Chār Mādrās 13407734 82 1009 100925 P PPL 0 BD Alipur 13407698 82 1078 107852 P PPL 0 BD Ratnadi 13407752 82 1078 107857 P PPL 0 BD Char Kajal 13407753 82 1078 107857 P PPL 0 BD Amkhola 13407751 82 1078 107857 P PPL 0 BD Chālitabunia 13407749 82 1078 107866 P PPL 0 BD Chālitābunia 13407750 82 1078 107866 P PPL 0 BD Kalikāpur 13407692 82 1078 107876 P PPL 0 BD Kālikāpur 13407697 82 1078 107876 P PPL 0 BD Kālikāpur 13407713 82 1078 107895 P PPL 0 BD Sārikkhāli 13407705 82 1078 107895 P PPL 0 BD Chhota Bāisdia 13407754 82 1078 107897 P PPL 0 BD Hābibpur 13410720 83 5532 553230 P PPL 0 BD Kachua 13410893 83 5532 553288 P PPL 0 BD Atapur 13411790 87 5038 503874 P PPL 0