From f7626f98676550cc2d954d63b199dbc8ece753b8 Mon Sep 17 00:00:00 2001 From: benny Date: Thu, 26 Jul 2018 16:15:11 +0800 Subject: [PATCH] DataObjects/Core_group.php --- DataObjects/Core_group.php | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) diff --git a/DataObjects/Core_group.php b/DataObjects/Core_group.php index ee544cdc..4b0ec5d7 100644 --- a/DataObjects/Core_group.php +++ b/DataObjects/Core_group.php @@ -64,13 +64,13 @@ class Pman_Core_DataObjects_Core_group extends DB_DataObject SELECT count(user_id) FROM - {$cgm} + core_group_member WHERE - {$this->tableName()}.id = {$cgm}.group_id - AND - {$cgm}.user_id = {$cp}.id - AND - {$cp}.active = 1 + {$this->tableName()}.id = core_group_member.group_id + AND + core_group_member.user_id = core_person.id + AND + core_person.active = 1 ) AS group_member_count "); -- 2.39.2