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 DATE_FORMAT(DATE_ADD(dateReelle,INTERVAL "1:0" HOUR_MINUTE),'%Y-%m-%d %H:%i:%s') BETWEEN DATE_FORMAT('2010-02-10','%Y-%m-%d 00:00:00') AND DATE_FORMAT('2010-02-10 00:51:50','%Y-%m-%d %H:%i:%s') 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 DATE_FORMAT(DATE_ADD(dateReelle,INTERVAL "1:0" HOUR_MINUTE),'%Y-%m-%d %H:%i:' at line 1