1 files changed, 0 insertions, 2 deletions
diff --git a/schema.sql b/schema.sql
index 65edadf..8cda3d8 100644
--- a/schema.sql
+++ b/schema.sql
@@ -256,8 +256,6 @@ create view user_dynamic_view as
 				and join_count = 0
 		) + (
 			select count(1) from unseen_games where user_id = users.user_id
-		) + (
-			select count(1) from unread_chats where user_id = users.user_id
 		)
 		as waiting,
 		is_banned