From 1dae893c17371a0fc4add5699ecdedacbfe1bc22 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Fri, 27 Jul 2018 10:12:18 +0800 Subject: [PATCH] DataObjects/Core_group.php --- DataObjects/Core_group.php | 24 ++++++++++++------------ 1 file changed, 12 insertions(+), 12 deletions(-) diff --git a/DataObjects/Core_group.php b/DataObjects/Core_group.php index 0bf78c04..643a6687 100644 --- a/DataObjects/Core_group.php +++ b/DataObjects/Core_group.php @@ -61,18 +61,18 @@ class Pman_Core_DataObjects_Core_group extends DB_DataObject $this->selectAdd(" ( - SELECT - COUNT(core_group_member.user_id) - FROM - core_group_member - LEFT JOIN - core_person - ON - core_person.id = core_group_member.user_id - WHERE - core_group_member.group_id = core_group.id - AND - core_person.active = 1 + SELECT + COUNT(core_group_member.user_id) + FROM + core_group_member + LEFT JOIN + core_person + ON + core_person.id = core_group_member.user_id + WHERE + core_group_member.group_id = core_group.id + AND + core_person.active = 1 ) AS group_member_count "); -- 2.39.2