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