SELECT emission.titre as titre_emission, generique.titre as titre_generique, emission.id_FR, DATE_FORMAT(DATE_ADD(dateReelle,INTERVAL "1: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-01-07 04:35:22' AND '2009-01-08 03:35:22' 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-01-07 04:35:22' AND '2009-01-08 03:35:22' at line 1