/** * @param League $league * @param int $season * * @return Fixture[] */ public function findByLeagueAndSeasonWithEvents(League $league, $season) { $qb = $this->_em->createQueryBuilder(); $qb->select(array('f', 'e')); $qb->from('CoreBundle:Fixture', 'f'); $qb->where('f.league = :league'); $qb->setParameter('league', $league->getId()); $qb->andWhere('f.season = :season'); $qb->setParameter('season', $season); $qb->join('f.events', 'e'); return $qb->getQuery()->getResult(); }