Simplify count_real_users SQL to only count user_type is null rows

Signed-off-by: Jason Robinson <jasonr@matrix.org>

1 files changed, 1 insertions, 1 deletions

diff --git a/synapse/storage/registration.py b/synapse/storage/registration.py

index 54b0846c54..c0ca25733b 100644
--- a/synapse/storage/registration.py
+++ b/synapse/storage/registration.py
@@ -450,7 +450,7 @@ class RegistrationWorkerStore(SQLBaseStore):
 
         def _count_users(txn):
             txn.execute(
-                "SELECT COUNT(*) AS users FROM users where user_type is null or user_type = ''"
+                "SELECT COUNT(*) AS users FROM users where user_type is null"
             )
             rows = self.cursor_to_dict(txn)
             if rows: