SELECT emission.titre as titre_emission, generique.titre as titre_generique, emission.id_FR, DATE_FORMAT(DATE_ADD(dateReelle,INTERVAL "2:0" HOUR_MINUTE),'%Y-%m-%d %H:%i:%s') dateR, dateReelle FROM (diffusion,onlinefiche as emission) LEFT JOIN onlinefiche AS generique ON emission.id_generique=generique.id WHERE emission.id=diffusion.id_fiche AND diffusion.id_signal= AND diffusion.dateReelle BETWEEN '2009-07-03 21:13:07' AND '2009-07-04 19:13:07' ORDER BY dateReelle DESC LIMIT 0,1 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 'AND diffusion.dateReelle BETWEEN '2009-07-03 21:13:07' AND '2009-07-04 19:13:07' at line 1