From 61f04d8b5488935f4c3d8b92cf38692e63a84fa4 Mon Sep 17 00:00:00 2001
From: MadLittleMods <MadLittleMods@users.noreply.github.com>
Date: Wed, 7 Jun 2023 17:51:27 +0000
Subject: deploy: 195b6a298d509518bf16d5a421d706ecb2ccdce6

---
 develop/usage/administration/admin_faq.html | 5 ++---
 1 file changed, 2 insertions(+), 3 deletions(-)

(limited to 'develop/usage/administration/admin_faq.html')

diff --git a/develop/usage/administration/admin_faq.html b/develop/usage/administration/admin_faq.html
index 11fa941258..d5f891e668 100644
--- a/develop/usage/administration/admin_faq.html
+++ b/develop/usage/administration/admin_faq.html
@@ -164,9 +164,8 @@ to make further changes.</p>
 <h2 id="what-servers-are-currently-participating-in-this-room"><a class="header" href="#what-servers-are-currently-participating-in-this-room">What servers are currently participating in this room?</a></h2>
 <p>Run this sql query on your db:</p>
 <pre><code class="language-sql">SELECT DISTINCT split_part(state_key, ':', 2)
-    FROM current_state_events AS c
-    INNER JOIN room_memberships AS m USING (room_id, event_id)
-    WHERE room_id = '!cURbafjkfsMDVwdRDQ:matrix.org' AND membership = 'join';
+FROM current_state_events
+WHERE room_id = '!cURbafjkfsMDVwdRDQ:matrix.org' AND membership = 'join';
 </code></pre>
 <h2 id="what-users-are-registered-on-my-server"><a class="header" href="#what-users-are-registered-on-my-server">What users are registered on my server?</a></h2>
 <pre><code class="language-sql">SELECT NAME from users;
-- 
cgit 1.5.1