From 71305fed4c552b0ae4716a7d01756a9ad81a1c3f Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Wed, 14 Mar 2018 17:07:01 +0800 Subject: [PATCH] DataObjects/Core_group.php --- DataObjects/Core_group.php | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) diff --git a/DataObjects/Core_group.php b/DataObjects/Core_group.php index f288b42a..4e456f61 100644 --- a/DataObjects/Core_group.php +++ b/DataObjects/Core_group.php @@ -53,15 +53,16 @@ class Pman_Core_DataObjects_Core_group extends DB_DataObject $roo->jdata($core_group->memberCount()); } } + $cgm = DB_DataObject::Factory('core_group_member')->tableName();; $this->selectAdd(" ( SELECT count(user_id) FROM - core_group_member + {$cgm} WHERE - core_group.id = core_group_member.group_id + {$this->tableName()}.id = {$cgm}.group_id ) AS group_member_count "); -- 2.39.2