softwareheritage=> select *, encode(name, 'escape') from snapshot_branch where target_type='revision' and target='\x7076613b79f425dc8bc3600a3253e9c0c9a3397e';
 object_id |                     name                     |                   target                   | target_type |        encode         
-----------+----------------------------------------------+--------------------------------------------+-------------+-----------------------
 133325445 | \x6275737465722f6d61696e2f322e372e302d32     | \x7076613b79f425dc8bc3600a3253e9c0c9a3397e | revision    | buster/main/2.7.0-2
 133383513 | \x756e737461626c652f6d61696e2f322e372e302d32 | \x7076613b79f425dc8bc3600a3253e9c0c9a3397e | revision    | unstable/main/2.7.0-2
(2 lignes)

softwareheritage=> select * from snapshot_branches where branch_id in (133325445, 133383513);
 snapshot_id | branch_id 
-------------+-----------
    26273242 | 133325445
    51645287 | 133325445
    26273242 | 133383513
(3 lignes)

softwareheritage=> select * from snapshot where object_id in (26273242, 51645287, 26273242);
 object_id |                     id                     
-----------+--------------------------------------------
  26273242 | \xa12431fe9c2051e8444364fdfdfffa5dad8697ed
  51645287 | \xff1917af4f9cb653b9c4baca1ee5c6499f3a661f
(2 lignes)