From 166ffc0f23419bc99d9597fe95deaae3bbee7caf Mon Sep 17 00:00:00 2001 From: Laurence Gill Date: Thu, 12 Oct 2023 16:18:32 +0100 Subject: Fix typo in useful_sql_for_admins.md (#16477) --- changelog.d/16477.doc | 1 + docs/usage/administration/useful_sql_for_admins.md | 2 +- 2 files changed, 2 insertions(+), 1 deletion(-) create mode 100644 changelog.d/16477.doc 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' ); -- cgit 1.4.1