number of errors=0
number of warnings=0
Group=chkGrpUnlocode
select * from unlocode_manualmatch where not exists (select 1 from UNLOCODE20241 as unlocode where unlocode.geonameid=unlocode_manualmatch.geonameid and unlocode_manualmatch.code=unlocode.code and unlocode_manualmatch.cc=unlocode.cc)
update UNLOCODE20241 set geonameid=unlocode_manualmatch.geonameid from unlocode_manualmatch where unlocode_manualmatch.cc=UNLOCODE20241.cc and unlocode_manualmatch.code=UNLOCODE20241.code and UNLOCODE20241.geonameid is null
cc code geonameid creationtime