From 7c054a4d976a431b6b47333f74a07e15936db5d9 Mon Sep 17 00:00:00 2001
From: benny <benny@roojs.com>
Date: Wed, 1 Aug 2018 12:58:58 +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 3beff8bc..c2a559a9 100644
--- a/DataObjects/Core_group.php
+++ b/DataObjects/Core_group.php
@@ -55,14 +55,16 @@ class Pman_Core_DataObjects_Core_group extends DB_DataObject
             }
         }
         
-        if(!empty($q['_with_member_id'])){
+        if(!empty($q['mem_id'])){
             $this->selectAdd("
                 COALESCE(
                     (SELECT id from core_group_member
-                        WHERE ...
-                        
+                        WHERE 
+                            user_id = {$q['mem_id']}
+                        AND
+                            group_id = {$this->tableName()}.id
                         LIMIT 1
-                    ),0) as ....
+                    ),0) as cgm_id
                     ");
         }
         
-- 
2.39.2