VictorTkachenko81 / SymfonyBlog

            ->getSingleResult();

    }

    public function getArticleWithCountComment($slug)

    {

        return $this->createQueryBuilder('a')

            ->select('a, c, t, u, count(cm.id) as countComments')

            ->leftJoin('a.categories', 'c')

            ->leftJoin('a.tags', 't')

            ->leftJoin('a.comments', 'cm')

            ->join('a.user', 'u')

            ->where('a.slug = ?1')

            ->groupBy('a, c, t, u')

            ->setParameter(1, $slug)

            ->getQuery()

            ->getSingleResult();

    }

    public function getArticlesSorted($sortBy, $param, $page = 1, $max = 10)

    {

    }

    public function getPopularArticles($max = 5)

    {

        return $this->createQueryBuilder('a')

            ->select('a, u, avg(c.rating) as rating')

            ->leftJoin('a.comments', 'c')

            ->join('a.user', 'u')

            ->groupBy('a, u')

            ->orderBy('rating', 'DESC')

            ->setFirstResult(0)

            ->setMaxResults($max)

            ->getQuery()

            ->getResult();

    }

    public function getRecentArticles($max = 5)

    {