2025-03-01     2025-03-02     2025-03-03

valid admincode1 for NP

number of errors=0
number of warnings=0
country=NP

select countrycode,name,geonameid,admincode1,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 not exists (select 1 from geoname b where b.countrycode=geoname.countrycode and b.admincode1=geoname.admincode1 and b.featurecode='ADM1' and b.countrycode in ('NP')) order by countrycode,name

countrycode	name	geonameid	admincode1	featureclass	featurecode	relevance