From 978481182f94ab23990c4353347d8e064a200cc2 Mon Sep 17 00:00:00 2001 From: Jason Etheridge Date: Fri, 1 Apr 2011 10:26:57 -0400 Subject: [PATCH] probably copy/paste errors --- Open-ILS/src/sql/Pg/300.schema.staged_search.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 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 3b22752a1b..171b3706a4 100644 --- a/Open-ILS/src/sql/Pg/300.schema.staged_search.sql +++ b/Open-ILS/src/sql/Pg/300.schema.staged_search.sql @@ -193,7 +193,7 @@ BEGIN PERFORM 1 FROM biblio.peer_bib_copy_map pr JOIN asset.copy cp ON (cp.id = pr.target_copy) - WHERE AND NOT cp.deleted + WHERE NOT cp.deleted AND cp.status IN ( SELECT * FROM search.explode_array( param_statuses ) ) AND pr.peer_record IN ( SELECT * FROM search.explode_array( core_result.records ) ) AND cp.circ_lib IN ( SELECT * FROM search.explode_array( search_org_list ) ) @@ -224,7 +224,7 @@ BEGIN PERFORM 1 FROM biblio.peer_bib_copy_map pr JOIN asset.copy cp ON (cp.id = pr.target_copy) - WHERE AND NOT cp.deleted + WHERE NOT cp.deleted AND cp.location IN ( SELECT * FROM search.explode_array( param_locations ) ) AND pr.peer_record IN ( SELECT * FROM search.explode_array( core_result.records ) ) AND cp.circ_lib IN ( SELECT * FROM search.explode_array( search_org_list ) ) -- 2.11.0