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 "2025-06-07 05:00:00" AND "2025-06-08 04:59:59" ORDER BY dt ASC