From 46e935d848908ad8c2242ca3bc77b9145de66fd4 Mon Sep 17 00:00:00 2001
From: Jamie McClelland <jm@mayfirst.org>
Date: Mon, 8 Nov 2021 14:19:06 -0500
Subject: [PATCH] don't overfill the prevnext cache when reserving for a
 survey.

---
 CRM/Campaign/Selector/Search.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/CRM/Campaign/Selector/Search.php b/CRM/Campaign/Selector/Search.php
index ce9a302d68..3f8c035ec4 100644
--- a/CRM/Campaign/Selector/Search.php
+++ b/CRM/Campaign/Selector/Search.php
@@ -267,7 +267,7 @@ class CRM_Campaign_Selector_Search extends CRM_Core_Selector_Base implements CRM
 
       $selectSQL = "
       SELECT %1, contact_a.id, contact_a.display_name
-{$sql['from']}
+{$sql['from']} {$sql['where']}
 ";
 
       try {
-- 
2.25.1