UPDATE xf_user_profile AS up
INNER JOIN xf_user AS u ON up.user_id = u.user_id
INNER JOIN xf_user_field_value AS ufv ON up.user_id = ufv.user_id
SET up.homepage = ufv.field_value
WHERE ufv.field_id = 'website'
AND ufv.field_value <> ''
AND u.last_activity >= unix_timestamp(now() - interval 365 day)
AND up.homepage = '';