From 3d13be0cf08ea73c8722fa0c4d796ac7e85d3132 Mon Sep 17 00:00:00 2001 From: Bradley Bonner Date: Wed, 8 Apr 2015 14:49:58 -0700 Subject: [PATCH] add new ID for nonresident property owner - it should exclude from updating. --- KCLS/utility-scripts/patron_activity/patron_activity.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/KCLS/utility-scripts/patron_activity/patron_activity.sql b/KCLS/utility-scripts/patron_activity/patron_activity.sql index adedf36b18..7f477097fc 100644 --- a/KCLS/utility-scripts/patron_activity/patron_activity.sql +++ b/KCLS/utility-scripts/patron_activity/patron_activity.sql @@ -10,6 +10,6 @@ WHERE event_time BETWEEN current_date - 2 AND current_date - 1 AND actor.usr_activity.usr IS NOT NULL ) AND NOT barred AND NOT deleted -AND profile NOT IN (31, 91, 17, 26, 23, 32, 90); +AND profile NOT IN (31, 91, 17, 26, 23, 32, 90, 92); COMMIT; -- 2.11.0