Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT id,omschrijving,COUNT(deelnemer.account_naam) AS deelnemerAantal,
- (CASE (
- SELECT deelnemer.account_naam
- FROM competitie
- JOIN deelnemer ON competitie.id = deelnemer.competitie_id
- WHERE deelnemer.account_naam='jager684' AND competitie.id = comp.id)
- WHEN 'jager684' THEN true ELSE false END)
- AS neemtDeel
- FROM competitie as comp
- JOIN deelnemer ON comp.id = deelnemer.competitie_id
- GROUP BY comp.id;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement