$budget_node = Doctrine_Query::create() ->select('SUM(t.points) mysum, o.*') ->from('Orgnode o') ->innerJoin('o.transactions t') ->where( "o.id = ? AND t.created_at >= ? AND t.type = 'issue'", array($this->getId(),$budget->getStartDate() ) ) ->groupBy('o.id') ->execute(); print_r($budget_node->transactions->mysum); print_r($budget_node->mysum);