From f61375ae5998a5366d42371373978eeec88662de Mon Sep 17 00:00:00 2001 From: Pradeep Nayak Date: Tue, 4 Sep 2018 17:23:19 +0100 Subject: [PATCH] only include the tables that will be in from clause --- CRM/Report/Form/Contact/Detail.php | 5 +++++ 1 file changed, 5 insertions(+) diff --git a/CRM/Report/Form/Contact/Detail.php b/CRM/Report/Form/Contact/Detail.php index 060d4cacf4..efa522f802 100644 --- a/CRM/Report/Form/Contact/Detail.php +++ b/CRM/Report/Form/Contact/Detail.php @@ -462,6 +462,11 @@ class CRM_Report_Form_Contact_Detail extends CRM_Report_Form { $this->joinPhoneFromContact(); $this->joinEmailFromContact(); + // only include tables that are in from clause + $componentTables = array_intersect($this->_aliases, $this->_component); + $componentTables = array_flip($componentTables); + $this->_selectedTables = array_diff($this->_selectedTables, $componentTables); + if (!empty($this->_selectComponent['contribution_civireport'])) { $this->_formComponent['contribution_civireport'] = " FROM civicrm_contact {$this->_aliases['civicrm_contact']} -- 2.25.1