From b08455a11c3edce816c3dc7924cf3383561d6d2a Mon Sep 17 00:00:00 2001
From: Coleman Watts <coleman@civicrm.org>
Date: Wed, 12 Nov 2014 20:33:10 -0500
Subject: [PATCH] CRM-15107 - Fix count from static groups to only count
 'Added' status

---
 CRM/Contact/BAO/Group.php | 6 +++++-
 1 file changed, 5 insertions(+), 1 deletion(-)

diff --git a/CRM/Contact/BAO/Group.php b/CRM/Contact/BAO/Group.php
index 8743a3131e..c33a9319a2 100644
--- a/CRM/Contact/BAO/Group.php
+++ b/CRM/Contact/BAO/Group.php
@@ -974,7 +974,11 @@ class CRM_Contact_BAO_Group extends CRM_Contact_DAO_Group {
 
     // Get group counts
     foreach ($groupsToCount as $table => $groups) {
-      $dao = CRM_Core_DAO::executeQuery("SELECT group_id, COUNT(id) as `count` FROM $table WHERE group_id IN (" . implode(',', $groups) . ") GROUP BY group_id");
+      $where = "group_id IN (" . implode(',', $groups) . ")";
+      if ($table == 'civicrm_group_contact') {
+        $where .= " AND status = 'Added'";
+      }
+      $dao = CRM_Core_DAO::executeQuery("SELECT group_id, COUNT(id) as `count` FROM $table WHERE $where GROUP BY group_id");
       while($dao->fetch()) {
         $values[$dao->group_id]['count'] = $dao->count;
       }
-- 
2.25.1