Nsryjdtyk

Based on my example I try to get the last 5 comments from a Comment Entity, but only one comment for each Post Entity which is related to the Comment Entity.

Before I asked, I researched, but what I found here didn't make anything clear and didn't work either.

This my current query:

$lastComments = $this->em->getRepository('App:Comment')

            ->createQueryBuilder('c')

            ->select('p', 'c')

            ->leftJoin('c.post', 'p', 'WITH','p.id = c.post')

            ->andWhere('c.approved = :approved')->setParameter('approved', true)

            ->groupBy('p.id')

            ->orderBy("c.createdAt","desc")

            ->setMaxResults(5)

            ->getQuery()

            ->getResult();

Grouping the Post entity directly with groupBy throws me this error:

Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'symadmin.c0_.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by").