number of errors=36
number of warnings=0
country=PH
select geonameid,name,ansiname,featurecode,countrycode,admincode1,admincode2,admincode3,admincode4,admincode5 from geoname where countrycode='PH' and featurecode='ADM3' and not exists (select 1 from countrysubdiv_code where validtill is null and countrysubdiv_code.countrycode='PH' and countrysubdiv_code.featurecode='ADM3' and geoname.admincode1=countrysubdiv_code.admincode1 and geoname.admincode2=countrysubdiv_code.admincode2 and geoname.admincode3=countrysubdiv_code.admincode3) order by admincode1,admincode2,admincode3,admincode4,admincode5
1646 from psgc
geonameid name ansiname featurecode countrycode admincode1 admincode2 admincode3 admincode4 admincode5 1722910 Buldon Buldon ADM3 PH 14 MGN 153802000 null null 1714782 Datu Odin Sinsuat (Dinaig) Datu Odin Sinsuat (Dinaig) ADM3 PH 14 MGN 153807000 null null 1700421 Matanog Matanog ADM3 PH 14 MGN 153809000 null null 1694777 Parang Parang ADM3 PH 14 MGN 153811000 null null 1685379 Sultan Kudarat (Nuling) Sultan Kudarat (Nuling) ADM3 PH 14 MGN 153812000 null null 11778373 Kabuntalan (Tumbao) Kabuntalan (Tumbao) ADM3 PH 14 MGN 153814000 null null 1680234 Upi Upi ADM3 PH 14 MGN 153815000 null null 1726656 Barira Barira ADM3 PH 14 MGN 153818000 null null 11778291 Talitay Talitay ADM3 PH 14 MGN 153821000 null null 11778346 Sultan Mastura Sultan Mastura ADM3 PH 14 MGN 153824000 null null 9346503 Datu Blah T. Sinsuat Datu Blah T. Sinsuat ADM3 PH 14 MGN 153830000 null null 1709853 Northern Kabuntalan Northern Kabuntalan ADM3 PH 14 MGN 153834000 null null 11778317 Ampatuan Ampatuan ADM3 PH 14 MGS 153801000 null null 1722820 Buluan Buluan ADM3 PH 14 MGS 153803000 null null 1715385 Datu Paglas Datu Paglas ADM3 PH 14 MGS 153805000 null null 1715383 Datu Piang Datu Piang ADM3 PH 14 MGS 153806000 null null 1704022 Shariff Aguak (Maganoy) Shariff Aguak (Maganoy) ADM3 PH 14 MGS 153808000 null null 11778354 Pagalungan Pagalungan ADM3 PH 14 MGS 153810000 null null 1685374 Sultan Sa Barongis (Lambayong) Sultan Sa Barongis (Lambayong) ADM3 PH 14 MGS 153813000 null null 1684008 Talayan Talayan ADM3 PH 14 MGS 153816000 null null 1685693 South Upi South Upi ADM3 PH 14 MGS 153817000 null null 11778332 Gen. S.K. Pendatun Gen. S.K. Pendatun ADM3 PH 14 MGS 153819000 null null 11778331 Mamasapano Mamasapano ADM3 PH 14 MGS 153820000 null null 1696686 Pagagawan Pagagawan ADM3 PH 14 MGS 153822000 null null 11778342 Paglat Paglat ADM3 PH 14 MGS 153823000 null null 11778374 Guindulungan Guindulungan ADM3 PH 14 MGS 153825000 null null 11778375 Datu Saudi-Ampatuan Datu Saudi-Ampatuan ADM3 PH 14 MGS 153826000 null null 11778312 Datu Unsay Datu Unsay ADM3 PH 14 MGS 153827000 null null 11778376 Datu Abdullah Sangki Datu Abdullah Sangki ADM3 PH 14 MGS 153828000 null null 11778377 Rajah Buayan Rajah Buayan ADM3 PH 14 MGS 153829000 null null 11778347 Datu Anggal Midtimbang Datu Anggal Midtimbang ADM3 PH 14 MGS 153831000 null null 11778295 Mangudadatu Mangudadatu ADM3 PH 14 MGS 153832000 null null 11778344 Pandag Pandag ADM3 PH 14 MGS 153833000 null null 1730984 Datu Hoffer Ampatuan Datu Hoffer Ampatuan ADM3 PH 14 MGS 153835000 null null 11778333 Datu Salibo Datu Salibo ADM3 PH 14 MGS 153836000 null null 11778356 Shariff Saydona Mustapha Shariff Saydona Mustapha ADM3 PH 14 MGS 153837000 null null