public function getSnippetTemplatesForArticle($articleNr, $languageCode, $show = 'enabled') { $em = $this->getEntityManager(); $snippetTemplateIDsQuery = $em->getRepository('Newscoop\\Entity\\Snippet')->getArticleSnippetQueryBuilder($articleNr, $languageCode, $show)->select('template.id'); $snippetTemplateIDsQueryResult = $snippetTemplateIDsQuery->distinct()->getQuery()->getResult(); $ids = array_map('current', $snippetTemplateIDsQueryResult); $queryBuilder = $this->createQueryBuilder('template'); $queryBuilder->add('where', $queryBuilder->expr()->in('template.id', $ids)); return $queryBuilder->getQuery(); }