error: querry::echec de mysql_query pour le sql select s.DateDebut, s.DateFin, s.TypeSejour, s.Rem as description from ( (select sg.DateDebut, sg.DateFin, sg.TypeSejour, sg.Rem from SejourGeneral as sg where sg.DateDebut >= date(now())) union (select sa.DateDebut, sa.DateFin, sa.TypeSejour, sa.Rem from SejourGeneralAlternatif as sa where sa.DateDebut >= date(now())) ) as s join (Select cache_Rech.DateDebut, cache_Rech.DateFin, cache_Rech.TypeSejour from cache_Rech use index (TheIndex6) Where cache_Rech.Status = 1 AND TypeSejour in ('') and IDLocation IN (select IDLocation from cacheLocation WHERE Capacite >= 6 and Capacite <= 8 ) AND DateDebut>=date(now()) GROUP BY DateDebut,DateFin ) as cr on s.DateDebut = cr.DateDebut and s.DateFin = cr.DateFin group by s.DateDebut, s.DateFin order by s.DateDebut desc;
error: querry::echec de mysql_query pour le sql select s.DateDebut, s.DateFin, s.TypeSejour, s.Rem as description from ( (select sg.DateDebut, sg.DateFin, sg.TypeSejour, sg.Rem from SejourGeneral as sg where sg.DateDebut >= date(now())) union (select sa.DateDebut, sa.DateFin, sa.TypeSejour, sa.Rem from SejourGeneralAlternatif as sa where sa.DateDebut >= date(now())) ) as s join (Select cache_Rech.DateDebut, cache_Rech.DateFin, cache_Rech.TypeSejour from cache_Rech use index (TheIndex6) Where cache_Rech.Status = 1 AND TypeSejour in ('') and IDLocation IN (select IDLocation from cacheLocation WHERE Capacite >= 6 and Capacite <= 8 ) AND DateDebut>=date(now()) GROUP BY DateDebut,DateFin ) as cr on s.DateDebut = cr.DateDebut and s.DateFin = cr.DateFin group by s.DateDebut, s.DateFin order by s.DateDebut desc;