array_agg(jeux_choisis.participant_id) AS participants,
(COUNT(*) + (CASE WHEN bool_and(jeux_choisis.participant_id is null) THEN -1 ELSE 0 END)) as nb_vote
FROM
jeux
LEFT JOIN jeux_choisis ON jeux.id = jeux_choisis.jeu_id
array_agg(jeux_choisis.participant_id) AS participants,
(COUNT(*) + (CASE WHEN bool_and(jeux_choisis.participant_id is null) THEN -1 ELSE 0 END)) as nb_vote
FROM
jeux
LEFT JOIN jeux_choisis ON jeux.id = jeux_choisis.jeu_id