public function getArticleAuthors($articleNumber, $languageCode) { $languageId = $this->_em->getRepository('Newscoop\\Entity\\Language')->findOneByCode($languageCode); $qb = $this->createQueryBuilder('au')->where('au.articleNumber = :articleNumber')->andWhere('au.languageId = :languageId')->setParameters(array('articleNumber' => $articleNumber, 'languageId' => $languageId))->orderBy('au.order', 'asc'); $countQueryBuilder = clone $qb; $countQueryBuilder->select('COUNT(au)'); $count = $countQueryBuilder->getQuery()->getSingleScalarResult(); $query = $qb->getQuery(); $query->setHint('knp_paginator.count', $count); return $query; }