Newscoop\Entity\Repository\RatingRepository::getArticleRating PHP Метод

    public function getArticleRating($articleId)
    {
        $queryBuilder = $this->getEntityManager()->createQueryBuilder()->select('r.articleId, COUNT(r.id) AS number_votes, AVG(r.ratingScore) AS avg_score, SUM(r.ratingScore) AS total_score')->from($this->getEntityName(), 'r')->where('r.articleId = :articleId')->groupBy('r.articleId');
        $query = $queryBuilder->getQuery()->setParameter('articleId', $articleId);
        return $query->getScalarResult();
    }