From 49302003e8f55da270f1275f578c18e023fce6c0 Mon Sep 17 00:00:00 2001
From: Andrew Engelbrecht <andrew@fsf.org>
Date: Thu, 18 May 2023 17:45:17 -0400
Subject: [PATCH] find expired / current deleted members

deleted contacts with expired or current memberships
---
 deleted-members.sh | 8 ++++++++
 1 file changed, 8 insertions(+)
 create mode 100755 deleted-members.sh

diff --git a/deleted-members.sh b/deleted-members.sh
new file mode 100755
index 0000000..24fd002
--- /dev/null
+++ b/deleted-members.sh
@@ -0,0 +1,8 @@
+#! /bin/bash
+
+# SPDX-FileCopyrightText: 2023 Andrew Engelbrecht
+#
+# SPDX-License-Identifier: GPL-3.0-or-later
+
+echo "select c.id from civicrm_contact c inner join civicrm_membership m on c.id = m.contact_id where c.is_deleted != 0" | mysql civicrm | sed -e "s:^:https\://my.fsf.org/civicrm/contact/view?reset=1\&cid=:"
+
-- 
2.25.1