number of errors=11
number of warnings=0
country=UG
select countrycode,name,geonameid,admincode1,admincode2,featureclass,featurecode,relevance from geoname where countrycode in ('UG') 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 ('UG')) order by relevance desc,admincode1,admincode2
countrycode name geonameid admincode1 admincode2 featureclass featurecode relevance UG Lake Mburo National Park 7839148 W 24 L RESN 8 UG Mgahinga Gorilla National Park 7839167 W 24 L PRK 8 UG Semuliki National Park 7839151 W 25 L RESN 8 UG Kibale National Park 7839168 W 25 L PRK 8 UG Kibale National Park 7839149 W 25 L RESF 7 UG Mount Elgon National Park (Uganda) 7839150 E 20 L PRK 5 UG Pian Upe Game Reserve 7870037 N 08 L RESW 5 UG Queen Elizabeth National Park 7839147 W 24 L RESN 5 UG Kibale Conservation Area 7839146 W 25 L RESF 5 UG Katonga Game Reserve 7870036 W 25 L RESN 5 UG Naluubale 7647817 C 22 S PS 1