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.