From: Alan Knowles <alan@roojs.com>
Date: Fri, 6 Apr 2018 05:51:52 +0000 (+0800)
Subject: DataObjects/Core_email.php
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=50554e8c7c433d323a1c384cb1193d8e68944161

DataObjects/Core_email.php
---

diff --git a/DataObjects/Core_email.php b/DataObjects/Core_email.php
index 5bb7b2c7..170c2a10 100644
--- a/DataObjects/Core_email.php
+++ b/DataObjects/Core_email.php
@@ -43,25 +43,23 @@ class Pman_Core_DataObjects_Core_email extends DB_DataObject
         $cgm = DB_DataObject::Factory('core_group_member')->tableName();;
       
         $this->selectAdd("
-           (
-            SELECT 
-                count(user_id) 
-            FROM 
-                {$cgm}
-            WHERE 
-                to_group_id = {$cgm}.group_id
-            ) 
-            AS group_member_count,
+            (
+                SELECT 
+                    count(id) 
+                FROM 
+                    {$cgm}
+                WHERE 
+                    to_group_id = {$cgm}.group_id
+            )  AS group_member_count,
             
-           (
-            SELECT 
-                count(user_id) 
-            FROM 
-                {$cgm}
-            WHERE 
-                bcc_group_id = {$cgm}.group_id
-           ) 
-           AS bcc_group_member_count
+            (
+                SELECT 
+                    count(id) 
+                FROM 
+                    {$cgm}
+                WHERE 
+                    bcc_group_id = {$cgm}.group_id
+            )  AS bcc_group_member_count
         ");
     }