<?php
-// $Id$
/*
+--------------------------------------------------------------------+
$this->_from = "
FROM civicrm_pcp {$this->_aliases['civicrm_pcp']}
-LEFT JOIN civicrm_contribution_soft {$this->_aliases['civicrm_contribution_soft']}
- ON {$this->_aliases['civicrm_pcp']}.id =
+LEFT JOIN civicrm_contribution_soft {$this->_aliases['civicrm_contribution_soft']}
+ ON {$this->_aliases['civicrm_pcp']}.id =
{$this->_aliases['civicrm_contribution_soft']}.pcp_id
-LEFT JOIN civicrm_contribution {$this->_aliases['civicrm_contribution']}
- ON {$this->_aliases['civicrm_contribution_soft']}.contribution_id =
+LEFT JOIN civicrm_contribution {$this->_aliases['civicrm_contribution']}
+ ON {$this->_aliases['civicrm_contribution_soft']}.contribution_id =
{$this->_aliases['civicrm_contribution']}.id
-LEFT JOIN civicrm_contact {$this->_aliases['civicrm_contact']}
- ON {$this->_aliases['civicrm_pcp']}.contact_id =
- {$this->_aliases['civicrm_contact']}.id
+LEFT JOIN civicrm_contact {$this->_aliases['civicrm_contact']}
+ ON {$this->_aliases['civicrm_pcp']}.contact_id =
+ {$this->_aliases['civicrm_contact']}.id
LEFT JOIN civicrm_contribution_page {$this->_aliases['civicrm_contribution_page']}
- ON {$this->_aliases['civicrm_pcp']}.page_id =
+ ON {$this->_aliases['civicrm_pcp']}.page_id =
{$this->_aliases['civicrm_contribution_page']}.id";
}