number of errors=7
number of warnings=0
country=PH
select countrycode,name,geonameid,admincode1,admincode2,admincode3,featureclass,featurecode,relevance from geoname where countrycode in ('PH') 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 ('PH')) order by countrycode,admincode1,admincode2,admincode3
countrycode name geonameid admincode1 admincode2 admincode3 featureclass featurecode relevance PH Nayom River 13408357 01 51 037113000 H STM 0 PH San Isidro 13440720 03 13 045808000 A ADM4 0 PH Biga 13406871 03 13 175205000 P PPL 0 PH Biga 13406866 03 13 175208000 P PPL 0 PH San Luis 13413866 03 47 015531000 P PPL 0 PH Poblacion 13446487 10 34 153625000 A ADM4 0 PH Santo Niño 13441911 11 I7 101318000 A ADM4 0