From 500d854af4866be2df013ec6e99a4b12235bf466 Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Sun, 3 Feb 2019 10:20:07 -0500 Subject: [PATCH] add browse entries deletion script --- sql/delete_stale_browse_entries.sql | 9 +++++++++ 1 file changed, 9 insertions(+) create mode 100644 sql/delete_stale_browse_entries.sql diff --git a/sql/delete_stale_browse_entries.sql b/sql/delete_stale_browse_entries.sql new file mode 100644 index 0000000..c5f48b1 --- /dev/null +++ b/sql/delete_stale_browse_entries.sql @@ -0,0 +1,9 @@ +DELETE FROM metabib.browse_entry WHERE id IN ( + SELECT DISTINCT(entry.id) + FROM metabib.browse_entry entry + LEFT JOIN metabib.browse_entry_def_map map + ON (map.entry = entry.id) + LEFT JOIN metabib.browse_entry_simple_heading_map hmap + ON (hmap.entry = entry.id) + WHERE map.id IS NULL AND hmap.id IS NULL +); -- 2.11.0