From a3696ce880e6736afb0f0856ed8f863ccab6a4d5 Mon Sep 17 00:00:00 2001
From: "Donald A. Lobo" <lobo@civicrm.org>
Date: Mon, 15 Apr 2013 11:30:17 -0700
Subject: [PATCH] CRM-12274

----------------------------------------
* CRM-12274: Merge activity tables into one unified table activity contact table
  http://issues.civicrm.org/jira/browse/CRM-12274
---
 CRM/Activity/BAO/Activity.php | 11 +++++------
 1 file changed, 5 insertions(+), 6 deletions(-)

diff --git a/CRM/Activity/BAO/Activity.php b/CRM/Activity/BAO/Activity.php
index 28d3083519..79c3904e72 100644
--- a/CRM/Activity/BAO/Activity.php
+++ b/CRM/Activity/BAO/Activity.php
@@ -1026,7 +1026,10 @@ LEFT JOIN   civicrm_case_activity ON ( civicrm_case_activity.activity_id = tbl.a
 
     // build main activity table select clause
     $sourceSelect = '';
-    $sourceJoin = '';
+    $sourceJoin = "
+INNER JOIN civicrm_activity_contact ac ON ac.activity_id = civicrm_activity.id
+INNER JOIN civicrm_contact contact ON ac.contact_id = contact.id
+";
 
     if (!$input['count']) {
       $sourceSelect = ',
@@ -1044,10 +1047,6 @@ LEFT JOIN   civicrm_case_activity ON ( civicrm_case_activity.activity_id = tbl.a
                 contact.sort_name as sort_name
             ';
 
-      $sourceJoin = "
-INNER JOIN civicrm_activity_contact activityContact ON activityContact.activity_id = civicrm_activity.id
-INNER JOIN civicrm_contact contact ON activityContact.contact_id = contact.id
-";
     }
 
     $sourceClause = "
@@ -1112,7 +1111,7 @@ INNER JOIN civicrm_contact contact ON activityContact.contact_id = contact.id
             ";
     }
 
-    $returnClause = " {$sourceClause}  union all {$caseClause} ";
+    $returnClause = " {$sourceClause} {$caseClause} ";
 
     return array($returnClause, $params);
   }
-- 
2.25.1