Untitled

    $query = Doctrine_Query::create()      ->select('st.id, COUNT(st.id) stcount')      ->from('Subscriber s INNER JOIN s.Subscriptions s2 INNER JOIN s2.SubscriptionType st')      ->where('s.installation_id = ?', array($this->installation_id))      ->groupby('st.id');    $this->subscriptionstypes = $query->execute();