number of errors=20
number of warnings=0
country=BD
select countrycode,name,geonameid,admincode1,admincode2,admincode3,admincode4,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 admincode4 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.admincode4=geoname.admincode4 and b.featurecode='ADM4' and b.countrycode in ('BD')) order by countrycode,admincode1,admincode2,admincode3,admincode4
countrycode name geonameid admincode1 admincode2 admincode3 admincode4 featureclass featurecode relevance BD North Tiākhāli 13407747 82 1004 100409 10040907 P PPL 0 BD Nilganj 13407748 82 1004 100409 10040907 P PPL 0 BD Uttar Chār Mādrās 13407734 82 1009 100925 10092557 P PPL 0 BD Uttar Char Mādrās 13407731 82 1009 100925 10092557 P PPL 0 BD Dakshin Char Fasson 13407733 82 1009 100925 10092566 P PPL 0 BD Paschim Char Umed 13407730 82 1009 100925 10092595 P PPL 0 BD Alipur 13407698 82 1078 107852 10785210 P PPL 0 BD Amkhola 13407751 82 1078 107857 10785711 P PPL 0 BD Char Kajal 13407753 82 1078 107857 10785739 P PPL 0 BD Ratnadi 13407752 82 1078 107857 10785794 P PPL 0 BD Chālitābunia 13407750 82 1078 107866 10786655 P PPL 0 BD Chālitabunia 13407749 82 1078 107866 10786655 P PPL 0 BD Kalikāpur 13407692 82 1078 107876 10787681 P PPL 0 BD Kālikāpur 13407697 82 1078 107876 10787681 P PPL 0 BD Sārikkhāli 13407705 82 1078 107895 10789533 P PPL 0 BD Kālikāpur 13407713 82 1078 107895 10789561 P PPL 0 BD Chhota Bāisdia 13407754 82 1078 107897 10789744 P PPL 0 BD Hābibpur 13410720 83 5532 553230 55323072 P PPL 0 BD Kachua 13410893 83 5532 553288 55328885 P PPL 0 BD Atapur 13411790 87 5038 503874 50387442 P PPL 0