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 / user / sql / query_occurrences_by_participant.sql
at main 8 lines 272 B view raw
kacaii.dev :art: lowercase all sql code
61f7a9ea
1-- 󰡦 Find all occurrences a user participated in 2select u.id 3from public.user_account as u 4inner join public.brigade_membership as bm 5 on u.id = bm.user_id 6inner join public.occurrence_brigade as ob 7 on bm.brigade_id = ob.brigade_id 8where ob.occurrence_id = $1;