protected function getTotalLocationContentCount() { $platform = $this->connection->getDatabasePlatform(); $queryBuilder = $this->connection->createQueryBuilder(); $queryBuilder->select($platform->getCountExpression('DISTINCT contentobject_id'))->from('ezcontentobject_tree')->where($queryBuilder->expr()->neq('node_id', UrlAliasHandler::ROOT_LOCATION_ID)); return $queryBuilder->execute()->fetchColumn(); }