X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=blobdiff_plain;f=DataObjects%2FCore_group.php;fp=DataObjects%2FCore_group.php;h=54f83f55c98a04e9071f0da8d64feebf520c5bf6;hp=f845db39ada12e464e0ba9da140d4d6d694f5e5e;hb=c594944ad18739ab3ce3d2e7bc02d505ef144d19;hpb=84fbf5cb1e74cd74867f39c69da3c825bbca6126 diff --git a/DataObjects/Core_group.php b/DataObjects/Core_group.php index f845db39..54f83f55 100644 --- a/DataObjects/Core_group.php +++ b/DataObjects/Core_group.php @@ -80,17 +80,17 @@ class Pman_Core_DataObjects_Core_group extends DB_DataObject $this->selectAdd(" ( - SELECT COUNT(${cgm}.user_id) + SELECT COUNT({$cgm}.user_id) FROM {$cgm} LEFT JOIN {$cp} ON - ${cp}.id = {$cgm}.user_id + {$cp}.id = {$cgm}.user_id WHERE - ${cgm}.group_id = {$this->tableName()}.id + {$cgm}.group_id = {$this->tableName()}.id AND - ${cp}.active = 1 + {$cp}.active = 1 ) AS group_member_count ");