select id_teacher, fio, post, teachersanddepartments.id_department, name_of_department, id_subject, name_of_subject, specific, subjects.id_department, name_of_department,
id_classroom, number_of_classroom, specific, classrooms.id_department, name_of_department, id_group, name_of_group, groups.id_department, name_of_department,
specifics, daytime, pair, NUMERATOR_DENOMINATOR, keyy, typekey
from ((((classes join teachers using(id_teacher) join teachersanddepartments using(id_teacher) join departments using(id_department))
join subjects using (id_subject) join departments using(id_department))
join classrooms using(id_classroom) join departments using(id_department))
join groups using (id_group) join departments using(id_department))