From 7850bc03247775ed0cdf7fd5115c0d99cf7272a2 Mon Sep 17 00:00:00 2001 From: larssandergreen Date: Sun, 4 Jun 2023 17:22:11 -0600 Subject: [PATCH] Order select for mailings by id DESC --- 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 dfd5ee7dcd..9703414b80 100644 --- a/CRM/Mailing/BAO/Mailing.php +++ b/CRM/Mailing/BAO/Mailing.php @@ -2787,7 +2787,7 @@ AND e.id NOT IN ( SELECT email_id FROM civicrm_mailing_recipients mr WHERE ma SELECT civicrm_mailing.id, civicrm_mailing.name, civicrm_mailing_job.end_date FROM civicrm_mailing INNER JOIN civicrm_mailing_job ON civicrm_mailing.id = civicrm_mailing_job.mailing_id {$where} -ORDER BY civicrm_mailing.name"; +ORDER BY civicrm_mailing.id DESC"; $mailing = CRM_Core_DAO::executeQuery($query); while ($mailing->fetch()) { -- 2.25.1