SELECT DATE_FORMAT(dt,'%k:%i') AS orario, a.titolo, a.descrizione, a.id_programma, b.img FROM palinsesto a LEFT JOIN programmi b ON a.id_programma=b.id_programma WHERE dt BETWEEN "2024-09-10 05:00:00" AND "2024-09-11 04:59:59" ORDER BY dt ASC