populated places have timezone

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=CN,number=2}]
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;
update geoname set timezoneid=tmp5.timezoneid from tmp5 where tmp5.geonameid=geoname.geonameid and geoname.timezoneid is null;

countrycode	geonameid	name	featurecode	
CN	13498227	Yuyecun	PPL	
CN	13494964	Shuangwai	PPL