number of errors=0
number of warnings=0
Group=chkGrpPostalCode
select distinct countrycode,adminname1,admincode1,admin1geonameid from zip_code where not exists (select 1 from geoname where geoname.geonameid=admin1geonameid and featureclass='A' and geoname.countrycode=zip_code.countrycode) and admin1geonameid is not null and admin1geonameid not in (1538316)
[]
countrycode adminname1 admincode1 admin1geonameid