X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=blobdiff_plain;f=DataObjects%2FCore_email.php;h=49cfa2ec1ccf6ca6629bc732e5a7018a6fe7eeb8;hp=f3636a06c684cdf8bf9b8f2a18d6162b47f6a238;hb=40a63e82b11635f0d1540057e8c8b1aa126a0c6a;hpb=883c25c358fe110878119e5619fed28ce49bd583 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 "); }