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 '2012-02-10 21:56:46' AND '2012-02-11 20:56:46' 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 '2012-02-10 21:56:46' AND '2012-02-11 20:56:46' at line 1