diff --git a/swh/storage/postgresql/db.py b/swh/storage/postgresql/db.py
--- a/swh/storage/postgresql/db.py
+++ b/swh/storage/postgresql/db.py
@@ -767,7 +767,9 @@
             "INNER JOIN origin o ON o.id = ov.origin",
             "INNER JOIN origin_visit_status ovs USING (origin, visit)",
         ]
-        query_parts.append("WHERE o.url = %s")
+        query_parts.append(
+            "WHERE ov.origin = (SELECT id FROM origin o WHERE o.url = %s)"
+        )
         query_params: List[Any] = [origin_id]
 
         if type is not None: