kacaii.dev / senac-brigade-server
wip: currently rewriting the project as a full stack application tangled.org/kacaii.dev/sigo
gleam
fork atom
senac-brigade-server / src / app / domain / occurrence / sql / query_participants.sql
at main 7 lines 287 B view raw
kacaii.dev :art: lowercase all sql code
61f7a9ea
1-- 󰀖 Find all users that participated in a occurrence 2select distinct participant.user_id 3from public.brigade_membership as participant 4inner join public.occurrence_brigade as ob 5 on participant.brigade_id = ob.brigade_id 6where ob.occurrence_id = $1 7order by participant.user_id;