From 8a06db38e8167a3ac8969055b30adbdd28da04e4 Mon Sep 17 00:00:00 2001 From: zarandras Date: Fri, 13 Nov 2015 13:52:42 +0100 Subject: [PATCH] CRM-17560 - Sql join type fix for civictm_activity_contact --- CRM/Activity/BAO/Query.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/CRM/Activity/BAO/Query.php b/CRM/Activity/BAO/Query.php index 41cde09c5c..2c817a2d90 100644 --- a/CRM/Activity/BAO/Query.php +++ b/CRM/Activity/BAO/Query.php @@ -351,9 +351,9 @@ class CRM_Activity_BAO_Query { //from civicrm_activity_target or civicrm_activity_assignment. //as component specific activities does not have entry in //activity target table so lets consider civicrm_activity_assignment. - $from .= " INNER JOIN civicrm_activity_contact + $from .= " $side JOIN civicrm_activity_contact ON ( civicrm_activity_contact.contact_id = contact_a.id ) "; - $from .= " INNER JOIN civicrm_activity + $from .= " $side JOIN civicrm_activity ON ( civicrm_activity.id = civicrm_activity_contact.activity_id AND civicrm_activity.is_deleted = 0 AND civicrm_activity.is_current_revision = 1 )"; -- 2.25.1