*/ class LabelRepository extends ServiceEntityRepository { public function __construct(ManagerRegistry $registry) { parent::__construct($registry, Label::class); } /** * @return list */ public function findUsage(): array { /** @var list */ return $this->createQueryBuilder('l') ->select('l.label AS label', 'COUNT(l.id) AS books') ->where('l.type = :type') ->setParameter('type', LabelType::TEXT->value) ->groupBy('l.label') ->orderBy('l.label', 'ASC') ->getQuery() ->getResult(); } }