number of errors=10
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 U-do 13164877 03 MMR013D003 MMR013028 H STM 0 MM Tha met 13164942 03 MMR013D003 MMR013028 P PPL 0 MM Hti mi la san Reservoir 13164938 03 MMR013D003 MMR013028 H RSV 0 MM Thamo Reserved Forest 13164934 03 MMR013D003 MMR013028 V FRST 0 MM Sin do ywa 13164930 03 MMR013D003 MMR013029 P PPL 0 MM Taw gyaung 13164864 03 MMR013D003 MMR013029 H STM 0 MM Htin bon zeik 13164945 03 MMR013D003 MMR013029 P PPL 0 MM In ga bu 13164908 03 MMR013D003 MMR013029 H STM 0 MM San gyaung 13164948 03 MMR013D003 MMR013029 P PPL 0 MM Ka to zeik 13164955 03 MMR013D003 MMR013029 P PPL 0