From 55d7c005e9b44aa9d1670239ed9e9b1ff02b27e4 Mon Sep 17 00:00:00 2001
From: benny <benny@roojs.com>
Date: Thu, 26 Jul 2018 15:36:45 +0800
Subject: [PATCH] DataObjects/Core_group.php

---
 DataObjects/Core_group.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/DataObjects/Core_group.php b/DataObjects/Core_group.php
index 994f4b90..6993d293 100644
--- a/DataObjects/Core_group.php
+++ b/DataObjects/Core_group.php
@@ -61,7 +61,7 @@ class Pman_Core_DataObjects_Core_group extends DB_DataObject
         $cgm = DB_DataObject::Factory('core_group_member')->tableName();
         $cpObj->active = 1; // set the where condition with active = 1
       
-        $core_group->joinAdd($cgmDBObj, array('joinType' => 'LEFT', 'useWhereAsOn' => false));
+        $cgm->joinAdd($cpObj, array('joinType' => 'LEFT', 'useWhereAsOn' => true));
         $core_group->joinAdd($cpObj, array('joinType' => 'LEFT', 'useWhereAsOn' => true));
         $core_group->find();
         DB_DataObject::debugLevel();
-- 
2.39.2