Don't use a join in origin_visit_get_latest.
This changes the behavior of snapshot_get_latest, to raise an error in case a visit references an unknown snapshot. This should not happen in practice (unless we're replaying from a journal).
snapshot_get_latest will be removed in the next monthes anyway.
Migrated from D1586 (view on Phabricator)