From 40a63e82b11635f0d1540057e8c8b1aa126a0c6a Mon Sep 17 00:00:00 2001 From: KH Lau Date: Wed, 7 Feb 2018 16:09:09 +0800 Subject: [PATCH] DataObjects/Core_email.php --- DataObjects/Core_email.php | 12 +++++++++++- 1 file changed, 11 insertions(+), 1 deletion(-) diff --git a/DataObjects/Core_email.php b/DataObjects/Core_email.php index f3636a06..49cfa2ec 100644 --- a/DataObjects/Core_email.php +++ b/DataObjects/Core_email.php @@ -51,7 +51,17 @@ class Pman_Core_DataObjects_Core_email extends DB_DataObject WHERE to_group_id = core_group_member.group_id ) - AS group_member_count + AS group_member_count, + + ( + SELECT + count(user_id) + FROM + core_group_member + WHERE + bcc_group = core_group_member.group_id + ) + AS bcc_group_member_count "); } -- 2.39.2