public function findAllCompetencesInUserCompetencesDQL(Competence $competence) { $query = $this->_em->createQuery('SELECT c FROM CentraleLilleKnowledgeBundle:UserCompetence c JOIN c.competence b WHERE b.id = :competence'); $query->setParameter('competence', $competence->getId()); $results = $query->getResult(); return $results; }