populated places have timezone

number of errors=0
number of warnings=0
Group=chkGrpTimezone

select countrycode,geonameid,name,featurecode from geoname where timezoneid is null and featureclass in ('P') and featurecode <>'PPLQ'

[]
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