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