From 13223cc218beba2f283c9b01ac5df39a37e37f0d Mon Sep 17 00:00:00 2001 From: Andrew Engelbrecht Date: Fri, 19 May 2023 12:14:01 -0400 Subject: [PATCH 1/1] we want to selct donations >= $120.00 --- board-forum-contacts.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/board-forum-contacts.sql b/board-forum-contacts.sql index 98079d2..cff3798 100644 --- a/board-forum-contacts.sql +++ b/board-forum-contacts.sql @@ -24,7 +24,7 @@ and c.id not in ( select contact_id from civicrm_contribution where contribution_status_id = 1 and receive_date >= '2018-01-19' and receive_date <= '2022-10-19' group by contact_id - having sum(total_amount) > '120.00' -- donated $120 or more during time period + having sum(total_amount) >= '120.00' -- donated $120 or more during time period ) ) ) -- 2.25.1