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 "2020-09-21 05:00:00" AND "2020-09-22 04:59:59" ORDER BY dt ASC