number of errors=16
number of warnings=0
country=ZA
select countrycode,name,geonameid,admincode1,admincode2,featureclass,featurecode,relevance from geoname where countrycode in ('ZA') 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 ('ZA')) order by relevance desc,admincode1,admincode2
countrycode name geonameid admincode1 admincode2 featureclass featurecode relevance ZA Thabazimbi 949684 06 DC36 S AIRF 4 ZA Nylstroom 968666 06 DC36 S AIRQ 4 ZA Potgietersrus 964316 06 DC36 S AIRQ 4 ZA Musina 976884 06 DC34 S AIRF 2 ZA Gravelotte 1000160 06 DC33 S AIRQ 1 ZA Gravelotte South 1000158 06 DC33 S AIRF 1 ZA Arundel 1022202 06 DC33 S AIRQ 1 ZA Hoedspruit 996200 06 DC33 S AIRF 1 ZA Riverside 961148 06 DC33 S AIRF 1 ZA Punda Miria 963875 06 DC34 S AIRF 1 ZA Ranch Motel 963245 06 DC35 S AIRF 1 ZA Swartwater 950809 06 DC35 S AIRF 1 ZA Dendron 1010968 06 DC35 S AIRF 1 ZA Vaalwater 945158 06 DC36 S AIRF 1 ZA Inmalkaar North 994675 06 DC36 S AIRF 1 ZA Oost Indie 967689 06 DC36 S AIRF 1