From ab49b311db59f9c98d0515ae66f52766744525ac Mon Sep 17 00:00:00 2001
From: KH Lau <khlau@roojs.com>
Date: Tue, 30 Jan 2018 16:41:41 +0800
Subject: [PATCH] DataObjects/Core_email.php

---
 DataObjects/Core_email.php | 14 ++++++++++++++
 1 file changed, 14 insertions(+)

diff --git a/DataObjects/Core_email.php b/DataObjects/Core_email.php
index de91473d..75c815d1 100644
--- a/DataObjects/Core_email.php
+++ b/DataObjects/Core_email.php
@@ -599,6 +599,20 @@ Content-Transfer-Encoding: 7bit
          
     }
     
+    function selectAddGroupCount()
+    {
+        $this->selectAdd("
+           (
+            SELECT 
+                count(user_id) 
+            FROM 
+                core_group_member 
+            WHERE 
+                to_group_id = core_group_member.group_id
+            ) 
+            AS group_member_count
+        ");
+    }
     
     
 }
-- 
2.39.2