Further cleanup from the "that is not a call number" game of last week

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 171b370..e13bb60 100644 (file)
--- 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 4b267e8..a3099a8 100644 (file)
--- 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;