number of errors=5
number of warnings=0
Group=chkGrpShp
select geoname.countrycode,geoname.admincode1,geoname_shape.admincode1,featurecode,level,geoname.geonameid,geoshapeid from geoname,geoname_shape where geoname.geonameid=geoname_shape.geonameid and level=1+ replace(featurecode,'ADM','')::int and featurecode like 'ADM_' and featurecode not in ('ADMD','ADMF','ADMS') and geoname.admincode1<>geoname_shape.admincode1 order by 1
countrycode admincode1 admincode1 featurecode level geonameid geoshapeid DZ TM 34 ADM3 4 2506850 855658 DZ TM 34 ADM3 4 12953827 857096 DZ BB 34 ADM3 4 12953565 856949 DZ TM 34 ADM3 4 2476402 856678 DZ TM 34 ADM3 4 2476242 856085