From d9cac69d6939dc3fbfeb9f2d26fb76d38142e769 Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Mon, 11 Apr 2011 13:09:13 -0400 Subject: [PATCH] Further cleanup from the "that is not a call number" game of last week --- Open-ILS/src/sql/Pg/300.schema.staged_search.sql | 3 +-- Open-ILS/src/sql/Pg/upgrade/XXX.schema.multi-home-items.sql | 3 +-- 2 files changed, 2 insertions(+), 4 deletions(-) diff --git a/Open-ILS/src/sql/Pg/300.schema.staged_search.sql b/Open-ILS/src/sql/Pg/300.schema.staged_search.sql index 171b3706a4..e13bb60075 100644 --- a/Open-ILS/src/sql/Pg/300.schema.staged_search.sql +++ b/Open-ILS/src/sql/Pg/300.schema.staged_search.sql @@ -279,8 +279,7 @@ BEGIN PERFORM 1 FROM biblio.peer_bib_copy_map pr JOIN asset.copy cp ON (cp.id = pr.target_copy) - WHERE NOT cn.deleted - AND NOT cp.deleted + WHERE NOT cp.deleted AND cp.circ_lib IN ( SELECT * FROM search.explode_array( search_org_list ) ) AND pr.peer_record IN ( SELECT * FROM search.explode_array( core_result.records ) ) LIMIT 1; diff --git a/Open-ILS/src/sql/Pg/upgrade/XXX.schema.multi-home-items.sql b/Open-ILS/src/sql/Pg/upgrade/XXX.schema.multi-home-items.sql index 4b267e8706..a3099a8d41 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXX.schema.multi-home-items.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXX.schema.multi-home-items.sql @@ -274,8 +274,7 @@ BEGIN PERFORM 1 FROM biblio.peer_bib_copy_map pr JOIN asset.copy cp ON (cp.id = pr.target_copy) - WHERE NOT cn.deleted - AND NOT cp.deleted + WHERE NOT cp.deleted AND cp.circ_lib IN ( SELECT * FROM search.explode_array( search_org_list ) ) AND pr.peer_record IN ( SELECT * FROM search.explode_array( core_result.records ) ) LIMIT 1; -- 2.11.0