From e82ee6476063ea670ea0b4fc34f5f7a9b8076010 Mon Sep 17 00:00:00 2001
From: Justin Freeman <justin@agileware.com.au>
Date: Sun, 22 Mar 2020 14:52:20 +1100
Subject: [PATCH] Remove ORDER BY and GROUP BY from alphabetQuery to improve
 performance. Refs #1665 CIVICRM-1457

---
 CRM/Contact/BAO/Query.php | 4 +---
 1 file changed, 1 insertion(+), 3 deletions(-)

diff --git a/CRM/Contact/BAO/Query.php b/CRM/Contact/BAO/Query.php
index 2124cbf460..6d223ffa28 100644
--- a/CRM/Contact/BAO/Query.php
+++ b/CRM/Contact/BAO/Query.php
@@ -5008,9 +5008,7 @@ civicrm_relationship.start_date > {$today}
     $query = "SELECT DISTINCT LEFT(contact_a.sort_name, 1) as sort_name
       {$sqlParts['from']}
       {$sqlParts['where']}
-      {$sqlParts['having']}
-      GROUP BY sort_name
-      ORDER BY sort_name asc";
+      {$sqlParts['having']}";
     $dao = CRM_Core_DAO::executeQuery($query);
     return $dao;
   }
-- 
2.25.1