number of errors=6
number of warnings=0
country=MM
select countrycode,name,geonameid,admincode1,admincode2,admincode3,featureclass,featurecode,relevance from geoname where countrycode in ('MM') 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 ('MM')) order by countrycode,admincode1,admincode2,admincode3
countrycode name geonameid admincode1 admincode2 admincode3 featureclass featurecode relevance MM Kaw Hmu Reserve Forest 13227192 03 MMR013D003 MMR013028 L RESF 0 MM U-do 13164877 03 MMR013D003 MMR013028 H STM 0 MM Pa ya thon zu 13227136 03 MMR013D003 MMR013028 P PPL 0 MM Nyaung waing than gyo 13227197 03 MMR013D003 MMR013028 P PPL 0 MM Taw gyaung 13164864 03 MMR013D003 MMR013029 H STM 0 MM Ma U su 13227153 17 MMR017D005 MMR017019 P PPL 0