From f0b94aa86ae188a324fd147362be482f764a1813 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Wed, 13 Apr 2016 14:53:17 -0400 Subject: [PATCH] Orphan browse entry cleanup repair Clean up subject entries, not author entries twice. Signed-off-by: Bill Erickson --- .../browse_cleanup/delete-stale-browse-entries.sql | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/KCLS/utility-scripts/browse_cleanup/delete-stale-browse-entries.sql b/KCLS/utility-scripts/browse_cleanup/delete-stale-browse-entries.sql index a46672dda1..482fc7e32b 100644 --- a/KCLS/utility-scripts/browse_cleanup/delete-stale-browse-entries.sql +++ b/KCLS/utility-scripts/browse_cleanup/delete-stale-browse-entries.sql @@ -18,12 +18,12 @@ DELETE FROM metabib.browse_author_entry WHERE id IN ( WHERE map.id IS NULL AND hmap.id IS NULL ); -DELETE FROM metabib.browse_author_entry WHERE id IN ( +DELETE FROM metabib.browse_subject_entry WHERE id IN ( SELECT DISTINCT(entry.id) - FROM metabib.browse_author_entry entry - LEFT JOIN metabib.browse_author_entry_def_map map + FROM metabib.browse_subject_entry entry + LEFT JOIN metabib.browse_subject_entry_def_map map ON (map.entry = entry.id) - LEFT JOIN metabib.browse_author_entry_simple_heading_map hmap + LEFT JOIN metabib.browse_subject_entry_simple_heading_map hmap ON (hmap.entry = entry.id) WHERE map.id IS NULL AND hmap.id IS NULL ); -- 2.11.0