Newscoop\Entity\Repository\UserRepository::getExternalLoginCount PHP Méthode

    public function getExternalLoginCount()
    {
        $query = $this->createQueryBuilder('u')->select('COUNT(u)')->leftJoin('u.identities', 'ui')->where('ui.user IS NOT NULL')->andWhere('u.status = :status')->getQuery();
        $query->setParameter('status', User::STATUS_ACTIVE);
        return $query->getSingleScalarResult();
    }