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'