number of errors=0
number of warnings=0
Group=chkGrpTimezone
select geoname.countrycode,geonameid,name,geoname.timezoneid,geoname_timezone.timezoneid,timezoneshapeid,sourcegeoshapeid from geoname,geoname_timezone where st_within(geoname.geography::geometry,wkb_geometry) and geoname.countrycode=geoname_timezone.countrycode and featurecode='ADM1' and geoname.timezoneid <> coalesce(geoname_timezone.timezoneid,'') and geoname.countrycode in (select distinct countrycode from geoname_timezone) and timezoneshapeid not in (65109) order by 1
countrycode geonameid name timezoneid timezoneid timezoneshapeid sourcegeoshapeid