diff options
Diffstat (limited to 'query')
| -rw-r--r-- | query/members.sql | 8 |
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 = ?; |