SELECT
TIME_FORMAT(h.hora_inicio, '%H:%i') AS inicio,
TIME_FORMAT(h.hora_fim, '%H:%i') AS fim,
DATE_FORMAT( h.data, '%d-%m-%Y' ) AS `data` ,
h.id_docente AS docente,
s.sala AS sala,
h.id_tipo AS tipo,
hr.id_curso AS curso,
hr.id_plano AS plano,
( SELECT Nome_Disc FROM disc_real WHERE ID_Disc_Real = hr.id_cadeira ) AS cadeira,
( SELECT Ano FROM disc_plano WHERE ID_Plano LIKE hr.id_plano AND ID_Disc_Plano LIKE hr.id_curso ) AS ano,
hr.id_regime AS regime
FROM
`horarios` h,
horarios_ref hr,
salas s
WHERE
hr.id = h.id_horario AND
h.id_sala = s.id AND
WEEKOFYEAR( h.data ) = '$semana' AND
DATE_FORMAT( h.data, '%w' ) = '$dia' AND
hr.id_curso = '$curso'