number of errors=7
number of warnings=0
country=MM
select countrycode,name,geonameid,admincode1,admincode2,featureclass,featurecode,relevance from geoname where countrycode in ('MM') 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 ('MM')) order by relevance desc,admincode1,admincode2
countrycode name geonameid admincode1 admincode2 featureclass featurecode relevance MM Hti mi la san Reservoir 13164938 03 MMR013D003 H RSV 0 MM Tha met 13164942 03 MMR013D003 P PPL 0 MM Ka to zeik 13164955 03 MMR013D003 P PPL 0 MM Htin bon zeik 13164945 03 MMR013D003 P PPL 0 MM San gyaung 13164948 03 MMR013D003 P PPL 0 MM Thamo Reserved Forest 13164934 03 MMR013D003 V FRST 0 MM Sin do ywa 13164930 03 MMR013D003 P PPL 0