public function getArticlesQueryByTopicIdAndLanguage($topicId, $languageCode, $defaultFallback = false) { $query = $this->getQueryBuilder()->select('node', 't')->from('Newscoop\\NewscoopBundle\\Entity\\Topic', 'node')->leftJoin('node.translations', 't')->where("t.field = 'title'")->andWhere('node.id = :id')->setParameter('id', $topicId); if ($defaultFallback) { return $this->setTranslatableHint($query->getQuery(), $languageCode); } $query->andWhere('t.locale = :locale')->setParameter('locale', $languageCode); return $query->getQuery(); }