Reservations 
            $requete_statistique = "select a.Nom, date(c.DateHeureDebut) as Date, TIME_FORMAT(time(c.DateHeureDebut),'%H:%i') as 'HeureDébut', TIME_FORMAT(time(c.DateHeureFin),'%H:%i') as 'HeureFin', c.PlacesMax as 'Places max', count(r.IDKey) As 'Réservées', ifnull(sum(r.Etat),0) as 'Fréquentation', a.NumeroTypeAcces, DateCreation, a.ID
            from WebCreneauActivite c left join WebReservationActivite r on r.NumeroCreneauxActivite=c.ID , WebActivite a
            where c.ActiviteID=a.ID and c.DateHeureDebut>=:DATEDEBUT and c.DateHeureFin<=:DATEFIN  and c.IDInscriptionActivite = 0
            group by c.ID
            order by c.DateHeureDebut
            ";