number of errors=2
number of warnings=0
Group=chkGrpTimezone
select countrycode,geonameid,name,featurecode from geoname where timezoneid is null and featureclass in ('P') and featurecode <>'PPLQ'
[{key=EC,number=1}, {key=RU,number=1}]
update tmp5 set timezoneid=geoname_timezone.timezoneid from geoname_timezone where geoname_timezone.countrycode=tmp5.countrycode and layer=2 and st_within(tmp5.geography::geometry,wkb_geometry) and tmp5.timezoneid is null;
countrycode geonameid name featurecode EC 13193356 Guanazán Pamba PPL RU 13224347 Mal’kovo PPL