Kod
$queryBuilder->select('c.id AS cid', 'c.name', 'a.id AS aid', 'a.title')
->from('ArticlesCategory', 'c')
->leftJoin('Articles', 'a', \Doctrine\ORM\Query\Expr\Join::WITH, 'c.id = a.category')
->where('a.status = :status')
->setParameter('status', 'active')
//->groupBy('a.id')
//->setMaxResults(3)
->orderBy('c.id', 'ASC')
->addOrderBy('a.uploaded_at', 'DESC');
->from('ArticlesCategory', 'c')
->leftJoin('Articles', 'a', \Doctrine\ORM\Query\Expr\Join::WITH, 'c.id = a.category')
->where('a.status = :status')
->setParameter('status', 'active')
//->groupBy('a.id')
//->setMaxResults(3)
->orderBy('c.id', 'ASC')
->addOrderBy('a.uploaded_at', 'DESC');
Potrzebne po 3 artykuły z każdej kategorii.
Jak napisać zapytanie?