Added a list of banned members server-side

1 files changed, 8 insertions, 0 deletions

diff --git a/query/members.sql b/query/members.sql
index 3d20b01..9110759 100644
--- a/query/members.sql
+++ b/query/members.sql
@@ -6,6 +6,14 @@ FROM members
 JOIN users ON users.id = members.user_id
 WHERE network_id = ? AND is_member = true;
 
+-- name: GetBannedMembers :many
+SELECT
+  sqlc.embed(users),
+  sqlc.embed(members)
+FROM members
+JOIN users ON users.id = members.user_id
+WHERE network_id = ? AND is_banned = true;
+
 -- name: GetMemberById :one
 SELECT * FROM members
 WHERE network_id = ? AND user_id = ?;