Erreur SQL !
SELECT *,SEANCES_TARIFS.Date as date_tarif, ADDTIME(debut_seance, "00:35:00") AS datemoinsQuinze , SEANCES.visa as VISA_CNC,numsemeinecnc.semaine,numsemeinecnc.fin as cnc_fin, numsemeinecnc.debut as cnc_debut,entree_film.reste, DATE_FORMAT(SEANCES.date, "%d/%m/%Y") as date_seance, ALLOCINE_FICHE.date as SN , DATE_FORMAT(debut_seance, "%Hh%i") as debut_seance_fr , DATE_FORMAT(debut_film, "%Hh%i") as debut_film_fr , DATE_FORMAT(fin_seance, "%Hh%i") as fin_seance_fr, DATE_FORMAT(SEANCES.date, "%w-%e-%c-%Y") as date_fonction, ALLOCINE_FICHE.duree as tps , SEANCES.ID_seance, BA.id_video, BA.url as url_video, GR_TARIF_detail.ID_seance as ID_seance_pack FROM SEANCES_TARIFS LEFT JOIN SEANCES ON SEANCES_TARIFS.ID_seance=SEANCES.ID_seance and SEANCES.site =SEANCES_TARIFS.ID_COMPLEXE LEFT OUTER JOIN TIXOS_ALLOCINE ON TIXOS_ALLOCINE.Visa=SEANCES.visa LEFT OUTER JOIN ALLOCINE_FICHE ON ALLOCINE_FICHE.idfilm=TIXOS_ALLOCINE.id_allocine LEFT OUTER JOIN GR_TARIF_detail ON GR_TARIF_detail.ID_seance = SEANCES.ID_seance and GR_TARIF_detail.date >= 2017-10-20 LEFT OUTER JOIN numsemeinecnc ON numsemeinecnc.debut <= SEANCES.date and numsemeinecnc.fin >= SEANCES.date LEFT OUTER JOIN entree_film ON entree_film.salle = SEANCES.Salle and `entree_film`.`h_debut` = `SEANCES`.`debut_seance` and entree_film.date=SEANCES.date LEFT OUTER JOIN BA ON BA.visa = SEANCES.visa WHERE SEANCES_TARIFS.Date = "2017-10-18" and debut_seance >= ADDTIME("", "-00:35:00") GROUP BY SEANCES_TARIFS.ID_seance ORDER BY SEANCES_TARIFS.Date ASC, debut_seance ASC LIMIT
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 21