select distinct content.sha1 from (
  select distinct walk.target as target
  from (
    select distinct snapshot_branch.target as target
    from (
      select distinct origin_visit.snapshot_id as snapshot_id
      from origin
      inner join origin_visit on origin_visit.origin = origin.id
      where 400 <= origin.id and origin.id < 440
    ) as visits
    inner join snapshot on visits.snapshot_id = snapshot.object_id
    inner join snapshot_branches on snapshot.object_id = snapshot_branches.snapshot_id
    inner join snapshot_branch on snapshot_branch.object_id = snapshot_branches.branch_id
    where
      true
      and snapshot_branch.target_type = 'revision'
      -- and snapshot_branch.name = 'HEAD'
  ) as snapshot_branch
  inner join revision on snapshot_branch.target = revision.id
  join lateral swh_directory_walk(revision.directory) walk on true
  where
    true
    and walk.type = 'file'
) as walk
inner join content on walk.target = content.sha1_git;