number of errors=2
number of warnings=0
country=PH
select geonameid,name,ansiname,featurecode,countrycode,admincode1,admincode2,admincode3,admincode4,admincode5 from geoname where countrycode='PH' and featurecode='ADM2' and not exists (select 1 from countrysubdiv_code where validtill is null and countrysubdiv_code.countrycode='PH' and countrysubdiv_code.featurecode='ADM2' and geoname.admincode1=countrysubdiv_code.admincode1 and geoname.admincode2=countrysubdiv_code.admincode2) order by admincode1,admincode2,admincode3,admincode4,admincode5
86 from psgc
geonameid name ansiname featurecode countrycode admincode1 admincode2 admincode3 admincode4 admincode5 13308209 Maguindanao del Norte Maguindanao del Norte ADM2 PH 14 MGN null null null 13308207 Maguindanao del Sur Maguindanao del Sur ADM2 PH 14 MGS null null null