From e624bc9e6b469fc2c5466f6c01a6427fc5fb7788 Mon Sep 17 00:00:00 2001 From: Michael McAndrew Date: Fri, 26 Jan 2018 12:16:43 +0000 Subject: [PATCH] fix select SMS recipients query --- CRM/Mailing/BAO/Mailing.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/CRM/Mailing/BAO/Mailing.php b/CRM/Mailing/BAO/Mailing.php index 5c284a5a38..08ee1f5b5a 100644 --- a/CRM/Mailing/BAO/Mailing.php +++ b/CRM/Mailing/BAO/Mailing.php @@ -238,7 +238,7 @@ class CRM_Mailing_BAO_Mailing extends CRM_Mailing_DAO_Mailing { 'temp.contact_id IS null', ); CRM_Utils_SQL_Select::from($phone) - ->select(" DISTINCT $phone.id as phone_id ") + ->select(" DISTINCT $phone.contact_id, $phone.id as phone_id ") ->join($contact, " INNER JOIN $contact ON $phone.contact_id = $contact.id ") ->join('gc', " INNER JOIN civicrm_group_contact gc ON $contact.id = gc.contact_id ") ->join('mg', " INNER JOIN civicrm_mailing_group mg ON gc.group_id = mg.entity_id AND mg.entity_table = 'civicrm_group' ") -- 2.25.1