number of errors=0
number of warnings=0
Group=chkGrpTimezone
select timezoneid,geoname_timezone.countrycode,timezoneshapeid,geoname_timezone.sourcegeoshapeid from geoname_timezone where sourcegeoshapeid>0 and not exists (select geoshapeid from geoname_shape where geoshapeid=geoname_timezone.sourcegeoshapeid)
timezoneid countrycode timezoneshapeid sourcegeoshapeid