From 4a06548fb10be02d3ba7feac3384351c1b1c0bae Mon Sep 17 00:00:00 2001
From: Alan Knowles <alan@roojs.com>
Date: Wed, 14 Mar 2018 17:42:08 +0800
Subject: [PATCH] DataObjects/Core_email.php

---
 DataObjects/Core_email.php | 11 ++++++-----
 1 file changed, 6 insertions(+), 5 deletions(-)

diff --git a/DataObjects/Core_email.php b/DataObjects/Core_email.php
index 278ebd5c..17cb9e88 100644
--- a/DataObjects/Core_email.php
+++ b/DataObjects/Core_email.php
@@ -41,15 +41,16 @@ class Pman_Core_DataObjects_Core_email extends DB_DataObject
                 $tn.subject LIKE '%{$this->escape($q['search']['nameortitle'])}%'
             ");
         }
-        
+        $cgm = DB_DataObject::Factory('core_group_member')->tableName();;
+      
         $this->selectAdd("
            (
             SELECT 
                 count(user_id) 
             FROM 
-                core_group_member 
+                {$cgm}
             WHERE 
-                to_group_id = core_group_member.group_id
+                to_group_id = {$cgm}.group_id
             ) 
             AS group_member_count,
             
@@ -57,9 +58,9 @@ class Pman_Core_DataObjects_Core_email extends DB_DataObject
             SELECT 
                 count(user_id) 
             FROM 
-                core_group_member 
+                {$cgm}
             WHERE 
-                bcc_group = core_group_member.group_id
+                bcc_group = {$cgm}.group_id
            ) 
            AS bcc_group_member_count
         ");
-- 
2.39.2