diff options
| -rw-r--r-- | changelog.d/16477.doc | 1 | ||||
| -rw-r--r-- | docs/usage/administration/useful_sql_for_admins.md | 2 |
2 files changed, 2 insertions, 1 deletions
diff --git a/changelog.d/16477.doc b/changelog.d/16477.doc new file mode 100644 index 0000000000..ef66e5d305 --- /dev/null +++ b/changelog.d/16477.doc @@ -0,0 +1 @@ +Fix a typo in the sql for [useful SQL for admins document](https://matrix-org.github.io/synapse/latest/usage/administration/useful_sql_for_admins.html). diff --git a/docs/usage/administration/useful_sql_for_admins.md b/docs/usage/administration/useful_sql_for_admins.md index f3b97f9576..9f2cc9b957 100644 --- a/docs/usage/administration/useful_sql_for_admins.md +++ b/docs/usage/administration/useful_sql_for_admins.md @@ -193,7 +193,7 @@ SELECT rss.room_id, rss.name, rss.canonical_alias, rss.topic, rss.encryption, 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' ); |