summary refs log tree commit diff
path: root/develop/usage
diff options
context:
space:
mode:
authorDMRobertson <DMRobertson@users.noreply.github.com>2023-10-12 15:19:42 +0000
committerDMRobertson <DMRobertson@users.noreply.github.com>2023-10-12 15:19:42 +0000
commit865daa2888379af5e0ccc00f57700af7e2710533 (patch)
tree7a46acf445817cd3b16f66ee71baa8cd8b0605dd /develop/usage
parentdeploy: 25c412b3c57962104d7a9452f03a0fca7e999bc2 (diff)
downloadsynapse-865daa2888379af5e0ccc00f57700af7e2710533.tar.xz
deploy: 166ffc0f23419bc99d9597fe95deaae3bbee7caf
Diffstat (limited to 'develop/usage')
-rw-r--r--develop/usage/administration/useful_sql_for_admins.html2
1 files changed, 1 insertions, 1 deletions
diff --git a/develop/usage/administration/useful_sql_for_admins.html b/develop/usage/administration/useful_sql_for_admins.html
index 2453388d11..1f683f4d6b 100644
--- a/develop/usage/administration/useful_sql_for_admins.html
+++ b/develop/usage/administration/useful_sql_for_admins.html
@@ -306,7 +306,7 @@ WHERE room_stats_state.room_id = event_json.room_id&quot; | psql -d synapse -h l
     rsc.joined_members, rsc.local_users_in_room, rss.join_rules
   FROM room_stats_state rss
   LEFT JOIN room_stats_current rsc USING (room_id)
-  WHERE room_id IN ( WHERE room_id IN (
+  WHERE room_id IN (
     '!OGEhHVWSdvArJzumhm:matrix.org',
     '!YTvKGNlinIzlkMTVRl:matrix.org' 
   );