From: Edward <edward@roojs.com>
Date: Tue, 18 Sep 2018 06:04:13 +0000 (+0800)
Subject: DataObjects/Core_group.php
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=bf4ad9cd19ebde530983a9e290de9a2f88dcc3dd

DataObjects/Core_group.php
---

diff --git a/DataObjects/Core_group.php b/DataObjects/Core_group.php
index 9932a4fa..2a6de416 100644
--- a/DataObjects/Core_group.php
+++ b/DataObjects/Core_group.php
@@ -57,14 +57,16 @@ class Pman_Core_DataObjects_Core_group extends DB_DataObject
         
         if(!empty($q['_is_in_group'])){
             $this->selectAdd("
-                COALESCE(
-                    (SELECT id from core_group_member
+                COALESCE((
+                    SELECT 
+                            COUNT(id) 
+                    FROM 
+                            core_group_member
                         WHERE 
                             user_id = {$q['_is_in_group']}
                         AND
                             group_id = {$this->tableName()}.id
-                        LIMIT 1
-                    ),0) as group_membership_user_id
+                    ), 0) AS is_in_group
             ");
         }