From 5bc634019fe91fe1eb52f44b52a35cc5a27aacfe Mon Sep 17 00:00:00 2001
From: yashodha <yashodha.chaku@webaccess.co.in>
Date: Wed, 19 Mar 2014 11:19:59 +0530
Subject: [PATCH] use group by to ensure we get single results for contacts

---
 CRM/Profile/Selector/Listings.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/CRM/Profile/Selector/Listings.php b/CRM/Profile/Selector/Listings.php
index 1c42d2d0d8..f4b1fef2eb 100644
--- a/CRM/Profile/Selector/Listings.php
+++ b/CRM/Profile/Selector/Listings.php
@@ -469,7 +469,7 @@ class CRM_Profile_Selector_Listings extends CRM_Core_Selector_Base implements CR
     if ($this->_multiRecordTableName) {
       $returnQuery = TRUE;
     }
-
+    $this->_query->_useGroupBy = TRUE;
     $result = $this->_query->searchQuery($offset, $rowCount, $sort, NULL, NULL,
       NULL, NULL, $returnQuery, $additionalWhereClause
     );
-- 
2.25.1