number of errors=16
number of warnings=0
country=PH
Group=chkGrpPostalCode
select countrycode,zip,placename,geonameid,admincode1,admincode2,geonamesadmcode from zip_code where countrycode in ('PH') and zip_code.geonameid not in (2775000,4020092) and zip_code.admincode1 is not null and not exists (select 1 from geoname b where b.countrycode=zip_code.countrycode and b.admincode1=zip_code.geonamesadmcode and b.admincode2=zip_code.admincode2 and b.featurecode='ADM2' and b.countrycode in ('PH')) order by countrycode,zip,placename
countrycode zip placename geonameid admincode1 admincode2 geonamesadmcode PH 9602 Upi 1680233 14 56 14 PH 9603 South Upi 1685692 14 56 14 PH 9604 Parang 1694775 14 56 14 PH 9605 Sultan Kudarat 1685378 14 56 14 PH 9607 Datu Piang 1715382 14 56 14 PH 9609 Ampatuan 1730983 14 56 14 PH 9610 Pagalungan 1696683 14 56 14 PH 9612 Talayan 1684006 14 56 14 PH 9613 Matanog 1700420 14 56 14 PH 9614 Barira 1726655 14 56 14 PH 9615 Buldon 1722909 14 56 14 PH 9616 Buluan 1722817 14 56 14 PH 9617 Datu Paglas 1715384 14 56 14 PH 9627 Datu Unsay 1699810 14 56 14 PH 9632 Paglat 1696569 14 56 14 PH 9633 Pandag 1695581 14 56 14