[civicrm-scripts.git] / deleted-members.sh

#! /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 |
    tail -n +2 |
    sed -e "s:^:https\://my.fsf.org/civicrm/contact/view?reset=1\&cid=:"
Commit	Line	Data
49302003 AE	1	#! /bin/bash
	2
	3	# SPDX-FileCopyrightText: 2023 Andrew Engelbrecht
	4	#
	5	# SPDX-License-Identifier: GPL-3.0-or-later
	6
6ee744ec AE	7	echo "select c.id from civicrm_contact c inner join civicrm_membership m on c.id = m.contact_id where c.is_deleted != 0" \|
	8	mysql civicrm \|
	9	tail -n +2 \|
	10	sed -e "s:^:https\://my.fsf.org/civicrm/contact/view?reset=1\&cid=:"
49302003	11