Page MenuHomeSoftware Heritage
Paste P275

(An Untitled Masterwork)
ActivePublic

Authored by seirl on Jun 19 2018, 3:21 PM.
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;