From 875a80d08067796b5faf5331daeaa1ee411b0347 Mon Sep 17 00:00:00 2001
From: benny <benny@roojs.com>
Date: Thu, 26 Jul 2018 16:05:59 +0800
Subject: [PATCH] DataObjects/Core_group.php

---
 DataObjects/Core_group.php | 5 +++--
 1 file changed, 3 insertions(+), 2 deletions(-)

diff --git a/DataObjects/Core_group.php b/DataObjects/Core_group.php
index 6658918f..f4dead47 100644
--- a/DataObjects/Core_group.php
+++ b/DataObjects/Core_group.php
@@ -66,8 +66,9 @@ class Pman_Core_DataObjects_Core_group extends DB_DataObject
             FROM 
                 {$cgm}
             WHERE 
-                {$this->tableName()}.id = {$cgm}.group_id
-            
+                {$this->tableName()}.id = {$cgm->tableName()}.group_id
+            AND
+                {$cgm->tableName()}.user_id = {$cp->tableName()}.id
             AND
                 {$cp}.active = 1
             ) 
-- 
2.39.2