From c6632dabd3999f27738458b2a6f8db5e47e96d3c Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Thu, 10 Mar 2016 13:13:35 -0500 Subject: [PATCH] LP#1549505: fix thinko in rating.precalc_location_filter() Signed-off-by: Galen Charlton --- Open-ILS/src/sql/Pg/upgrade/XXXX.schema.statisitcal-ratings.sql | 3 +-- 1 file changed, 1 insertion(+), 2 deletions(-) diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.statisitcal-ratings.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.statisitcal-ratings.sql index b9e70167e7..b00e3fd1aa 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.statisitcal-ratings.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.statisitcal-ratings.sql @@ -278,8 +278,7 @@ BEGIN FROM asset.call_number cn JOIN asset.copy cp ON (cn.id = cp.call_number) JOIN asset.copy_location_group_map lg ON (cp.location = lg.location) - WHERE cp.location = cm - AND lg.lgroup = loc + WHERE lg.lgroup = loc AND NOT cp.deleted; ELSE CREATE TEMP TABLE precalc_location_filter_bib_list ON COMMIT DROP AS -- 2.11.0