SELECT workprogrammes.id, schoolsubjects.title, teachers.lastname, teachers.firstname, teachers.patronymic, classes.title, SUM(themes.time) time
FROM classes, teachers, schoolsubjects, workprogrammes LEFT JOIN themes ON workprogrammes.id = themes.id_workprogramme
WHERE workprogrammes.id_schoolsubject = schoolsubjects.id
AND workprogrammes.id_teacher = teachers.id
AND workprogrammes.id_class = classes.id;

SELECT workprogrammes.id, schoolsubjects.title, classes.title class, teachers.lastname, teachers.firstname, teachers.patronymic, IFNULL(SUM(themes.time),0) time
FROM workprogrammes LEFT JOIN themes ON workprogrammes.id = themes.id_workprogramme
INNER JOIN schoolsubjects ON workprogrammes.id_schoolsubject = schoolsubjects.id
INNER JOIN classes ON workprogrammes.id_class = classes.id
INNER JOIN teachers ON workprogrammes.id_teacher = teachers.id
GROUP BY workprogrammes.id;