INNER JOIN events.event_type_secteur USING (ety_id)
INNER JOIN events.secteur_events ON event_type_secteur.sec_id = secteur_events.sec_id
INNER JOIN events.events USING(evs_id)
+ LEFT JOIN events.events_statut USING (evs_id)
INNER JOIN events.categorie_events USING (evs_id)
LEFT JOIN events.events_categorie ON event.eca_id = events_categorie.eca_id
INNER JOIN events.event_personne USING(eve_id)
AND (prm_grp_id ISNULL OR prm_grp_id = personne_groupe.grp_id)
AND (prm_per_ids ISNULL OR event_personne.per_id = ANY(prm_per_ids))
AND (events.ety_id ISNULL OR events.ety_id = event.ety_id)) sub
+ AND (NOT events.evs_locked OR events_statut.sta_id = personne_info_integer_get(prm_token, event_personne.per_id, 'statut_usager'))
GROUP BY
eca_nom,
ety_id,