From c52be1feba251d23a713da7b1e2b6cbeb895959f Mon Sep 17 00:00:00 2001 From: "deb.monish" Date: Fri, 13 May 2016 15:44:30 +0530 Subject: [PATCH] CRM-18488: minor change --- CRM/Report/Form/Pledge/Pbnp.php | 5 ++--- 1 file changed, 2 insertions(+), 3 deletions(-) diff --git a/CRM/Report/Form/Pledge/Pbnp.php b/CRM/Report/Form/Pledge/Pbnp.php index e98b87b478..e90e03b00d 100644 --- a/CRM/Report/Form/Pledge/Pbnp.php +++ b/CRM/Report/Form/Pledge/Pbnp.php @@ -273,12 +273,11 @@ class CRM_Report_Form_Pledge_Pbnp extends CRM_Report_Form { INNER JOIN civicrm_pledge {$this->_aliases['civicrm_pledge']} ON ({$this->_aliases['civicrm_pledge']}.contact_id = {$this->_aliases['civicrm_contact']}.id) AND - {$this->_aliases['civicrm_pledge']}.status_id IN ( {$statusIds} ) - LEFT JOIN "; + {$this->_aliases['civicrm_pledge']}.status_id IN ( {$statusIds} )\n"; // Note that the derived query protects us from providing inaccurate data in the edge case where pledge // payments have been edited such that they are not in id order. This might be better as a temp table. - $this->_from .= "(SELECT * FROM civicrm_pledge_payment ORDER BY scheduled_date) as {$this->_aliases['civicrm_pledge_payment']} + $this->_from .= "LEFT JOIN (SELECT * FROM civicrm_pledge_payment ORDER BY scheduled_date) as {$this->_aliases['civicrm_pledge_payment']} ON ({$this->_aliases['civicrm_pledge']}.id = {$this->_aliases['civicrm_pledge_payment']}.pledge_id AND {$this->_aliases['civicrm_pledge_payment']}.status_id = {$pendingStatus} ) "; -- 2.25.1