SELECT channel.channel_name, program_title, TIME_FORMAT( start_time, '%H:%i' ) AS start_time, TIME_FORMAT( finish_time, '%H:%i' ) AS finish_time, TIME_FORMAT( (TIMEDIFF(finish_time,start_time)), '%H:%i' ) AS duration, widescreen, subtitles FROM program, channel WHERE date = CURRENT_DATE() AND finish_time BETWEEN CURRENT_TIME() AND ADDTIME(CURRENT_TIME(), '01:30:00') AND program.channel_id=channel.channel_id ORDER BY channel_name,start_time;