summary refs log tree commit diff
path: root/latest/usage/administration/useful_sql_for_admins.html
diff options
context:
space:
mode:
authorDMRobertson <DMRobertson@users.noreply.github.com>2023-10-24 13:24:24 +0000
committerDMRobertson <DMRobertson@users.noreply.github.com>2023-10-24 13:24:24 +0000
commit743d74598df3a3d958157568ca6d549e787d3ee5 (patch)
tree131d58249614ec84495f354a5c0e98efc5eb9835 /latest/usage/administration/useful_sql_for_admins.html
parentdeploy: 6ec98810e394588d0ff000b1875c8b70edc8c327 (diff)
downloadsynapse-743d74598df3a3d958157568ca6d549e787d3ee5.tar.xz
deploy: 79f48b2b4fd6a90d919dc64f5a8d393c50cd5652
Diffstat (limited to 'latest/usage/administration/useful_sql_for_admins.html')
-rw-r--r--latest/usage/administration/useful_sql_for_admins.html2
1 files changed, 1 insertions, 1 deletions
diff --git a/latest/usage/administration/useful_sql_for_admins.html b/latest/usage/administration/useful_sql_for_admins.html

index 2453388d11..1f683f4d6b 100644 --- a/latest/usage/administration/useful_sql_for_admins.html +++ b/latest/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' );