From 50554e8c7c433d323a1c384cb1193d8e68944161 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Fri, 6 Apr 2018 13:51:52 +0800 Subject: [PATCH] DataObjects/Core_email.php --- DataObjects/Core_email.php | 34 ++++++++++++++++------------------ 1 file changed, 16 insertions(+), 18 deletions(-) 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 "); } -- 2.39.2