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(); }