number of errors=8
number of warnings=0
country=NP
select countrycode,name,geonameid,admincode1,admincode2,admincode3,featureclass,featurecode,relevance from geoname where countrycode in ('NP') 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 ('NP')) order by countrycode,admincode1,admincode2,admincode3
countrycode name geonameid admincode1 admincode2 admincode3 featureclass featurecode relevance NP Khāni̇̄ Kholā 13450715 1 12095466 12095751 H STM 0 NP Ḍā̃ḍāgāũ 13450716 1 12095466 12095753 P PPL 0 NP Nayā̃gāũ 13450714 1 12095466 12095753 P PPL 0 NP Nayā̃gāũ 13456350 5 12095507 12095691 P PPL 0 NP Darliṅ 13456329 5 12095507 12095691 P PPL 0 NP Okhreni̇̄ Kholā 13456351 5 12095507 12095695 H STM 0 NP Kapurkoṭ Kholā 13455977 6 12095464 12095911 H STM 0 NP Sisne Gāḍ 13450319 6 12095514 12096257 H STM 0