WIP: sorted release ident dumps

1 files changed, 16 insertions, 0 deletions

diff --git a/extra/sql_dumps/dump_idents.sql b/extra/sql_dumps/dump_idents.sql
index e8126347..d9777ea1 100644
--- a/extra/sql_dumps/dump_idents.sql
+++ b/extra/sql_dumps/dump_idents.sql
@@ -10,5 +10,21 @@ COPY (SELECT id, rev_id, redirect_id FROM webcapture_ident   WHERE is_live=true)
 COPY (SELECT id, rev_id, redirect_id FROM release_ident      WHERE is_live=true) TO '/tmp/fatcat_ident_releases.tsv'            WITH NULL '';
 COPY (SELECT id, rev_id, redirect_id FROM work_ident         WHERE is_live=true) TO '/tmp/fatcat_ident_works.tsv'               WITH NULL '';
 COPY (SELECT id, editgroup_id, timestamp FROM changelog)                         TO '/tmp/fatcat_ident_changelog.tsv'           WITH NULL '';
+COPY (
+  SELECT
+    release_ident.id,
+    release_ident.rev_id,
+    release_ident.redirect_id,
+    release_rev.work_ident_id
+  FROM
+    release_ident
+    LEFT JOIN release_rev ON release_ident.rev_id = release_rev.id
+  WHERE
+    release_ident.is_live=true
+    AND release_ident.redirect_id IS NULL
+    AND release_ident.rev_id IS NOT NULL
+  ORDER BY
+    release_rev.work_ident_id ASC NULLS LAST
+) TO '/tmp/fatcat_ident_releases_by_work.tsv'            WITH NULL '';
 
 ROLLBACK;