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