id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc	mlocked
13073	Detailed channel listing repeats title when it has multiple program ratings	davos9554@…	Stuart Auchterlonie	"The query used in the detailed channel listing appears to repeat titles when there is more than 1 related programrating record.

It appears to be caused by this query from modules/tv/includes/programs.php


SELECT DISTINCT program.*,
                         UNIX_TIMESTAMP(program.starttime) AS starttime_unix,
                         UNIX_TIMESTAMP(program.endtime) AS endtime_unix,
                         IFNULL(programrating.system, """") AS rater,
                         IFNULL(programrating.rating, """") AS rating,
                         channel.callsign,
                         channel.channum
                  FROM program USE INDEX (id_start_end)
                       LEFT JOIN programrating USING (chanid, starttime)
                       LEFT JOIN channel USING (chanid)
                       LEFT JOIN credits USING (chanid, starttime)
                       LEFT JOIN people USING (person)
                 WHERE  program.chanid=1698
                 AND program.starttime = '2017-07-22 08:00:00'"	Bug Report - General	closed	minor	unknown	Plugin - MythWeb	0.28.1	medium	Duplicate			0