SELECT * FROM ARD_EVENTS INNER JOIN ARD_ETABLISSEMENTS ON (ARD_EVENTS.id_event_salle = ARD_ETABLISSEMENTS.id_etab) INNER JOIN ARD_GEO_VILLES ON (ARD_ETABLISSEMENTS.id_ville = ARD_GEO_VILLES.id_ville) INNER JOIN ARD_ETABLISSEMENTS_CLASSES ON (ARD_ETABLISSEMENTS.id_etab = ARD_ETABLISSEMENTS_CLASSES.id_etab) INNER JOIN ARD_CLASSES ON (ARD_ETABLISSEMENTS_CLASSES.id_classe = ARD_CLASSES.id_classe) INNER JOIN (SELECT * FROM ARD_EVENTS_DATES ORDER BY date_event) ARD_DATES ON (ARD_EVENTS.id_event = ARD_DATES.id_event) INNER JOIN ARD_EVENTS_GENRES ON (ARD_EVENTS.id_event_genre = ARD_EVENTS_GENRES.id_event_genre) INNER JOIN ARD_EVENTS_GENRES_PRINCIPAL ON (ARD_EVENTS_GENRES.id_event_genre_principal = ARD_EVENTS_GENRES_PRINCIPAL.id_event_genre_principal) WHERE ARD_ETABLISSEMENTS.id_etab = 6823 AND profil_event = 0 AND statut_event = 1 AND date_event >= '2018-07-21' GROUP BY ARD_EVENTS.id_event