SELECT CONCAT(`set`.name_set,'-',spt.name_spt,'-',lvl.name_lvl,'-',clg.name_clg) as course,scg.grade_scg,scg.status_scg,prd.name_prd, csb.name_csb,CONCAT(std.first_name_std,' ',std.last_name_std) as name
FROM student_criteria_grade scg
JOIN subject_course sbc ON scg.serial_sbc = sbc.serial_sbc
JOIN subject sbj ON sbj.serial_sbj = sbc.serial_sbj
JOIN cat_subject csb ON sbj.serial_csb = csb.serial_csb
JOIN student std ON std.serial_std = scg.serial_std
JOIN period prd ON scg.serial_prd = prd.serial_prd
JOIN course crs ON crs.serial_crs = scg.serial_crs
JOIN class_group clg ON crs.serial_clg = clg.serial_clg
JOIN level lvl ON lvl.serial_lvl = crs.serial_lvl
JOIN specialty spt ON spt.serial_spt = crs.serial_spt
JOIN section `set` ON `set`.serial_set = crs.serial_set
ORDER BY name,name_prd,name_csb