summary refs log tree commit diff
path: root/develop/usage/administration/useful_sql_for_admins.html
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/administration/useful_sql_for_admins.html
parentdeploy: 25c412b3c57962104d7a9452f03a0fca7e999bc2 (diff)
downloadsynapse-865daa2888379af5e0ccc00f57700af7e2710533.tar.xz
deploy: 166ffc0f23419bc99d9597fe95deaae3bbee7caf
Diffstat (limited to 'develop/usage/administration/useful_sql_for_admins.html')
-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' );