Page Menu
Home
Software Heritage
Search
Configure Global Search
Log In
Paste
P275
(An Untitled Masterwork)
Active
Public
Actions
Authored by
seirl
on Jun 19 2018, 3:21 PM.
Edit Paste
Archive Paste
View Raw File
Subscribe
Mute Notifications
Award Token
Flag For Later
Tags
None
Subscribers
None
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
;
Event Timeline
seirl
created this paste.
Jun 19 2018, 3:21 PM
2018-06-19 15:21:21 (UTC+2)
Log In to Comment