Merge remote-tracking branch 'upstream/4.4' into 4.4-master-2014-08-25-10-57-01

[civicrm-core.git] / CRM / Report / Form / Member / Detail.php

diff --git a/CRM/Report/Form/Member/Detail.php b/CRM/Report/Form/Member/Detail.php
index b7ea5c05926e197d57328df066060039dbf9e379..e1ee639de19e48591065c38882586f1bfcc10046 100644 (file)
--- a/CRM/Report/Form/Member/Detail.php
+++ b/CRM/Report/Form/Member/Detail.php
@@ -355,15 +355,10 @@ class CRM_Report_Form_Member_Detail extends CRM_Report_Form {
     //used when contribution field is selected
     if ($this->_contribField) {
       $this->_from .= "
-              LEFT JOIN (
-                  SELECT cc.*, cmp.membership_id as membership_id
-                  FROM civicrm_membership_payment cmp
-                    JOIN civicrm_contribution cc
-                      ON cc.id = cmp.contribution_id
-                  ORDER BY cc.receive_date DESC
-                  ) {$this->_aliases['civicrm_contribution']}
-                ON {$this->_aliases['civicrm_membership']}.id =
-                  {$this->_aliases['civicrm_contribution']}.membership_id\n";
+             LEFT JOIN civicrm_membership_payment cmp
+                 ON {$this->_aliases['civicrm_membership']}.id = cmp.membership_id
+             LEFT JOIN civicrm_contribution {$this->_aliases['civicrm_contribution']}
+                 ON cmp.contribution_id={$this->_aliases['civicrm_contribution']}.id\n";
     }
   }