From bf4ad9cd19ebde530983a9e290de9a2f88dcc3dd Mon Sep 17 00:00:00 2001
From: Edward <edward@roojs.com>
Date: Tue, 18 Sep 2018 14:04:13 +0800
Subject: [PATCH] DataObjects/Core_group.php

---
 DataObjects/Core_group.php | 10 ++++++----
 1 file changed, 6 insertions(+), 4 deletions(-)

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
             ");
         }
         
-- 
2.39.2