$products = $this->getDoctrine()->getEntityManager()
->createQueryBuilder()
->select ('p.fixtureId, p.date')
->addSelect('pp.name AS hometm')
->addSelect('dp.name AS awaytm')
->from('AppBundle:fixture', 'p')
->innerJoin('AppBundle:teams', 'pp', 'with', "p.hometeam = pp.teamId")
->innerJoin('AppBundle:teams', 'dp', 'with', "p.awayteam = dp.teamId")
->where('p.leagueId = :leagueId')
->andWhere('p.date LIKE :date')
->setParameter('leagueId', $leagueid )
->setParameter('date', '%' .$leaguedate . '%')
->orderBy('p.date', 'ASC')
->getQuery()
->getResult();