SELECT
rasp_sh.shedday,
FLOOR(rasp_sh.shedhour/2+0.5) as ho,
rasp_sh.shedbegin_date,
rasp_sh.shedend_date,
rasp_sh.shedgroup,
rasp_prep.fam,
rasp_prep.name,
rasp_prep.otch,
rasp_pred.full,rasp_pred.id as pid,
rasp_rom.nazv,
rasp_sh.shedhour,
rasp_grp.name as gname,
rasp_ld.loadsgrpn,
rasp_stp.study_typesfull_name AS stdf,
rasp_grp.id as ngrp
FROM `rasp_sh`
LEFT outer JOIN rasp_ld on rasp_ld.loadsid=rasp_sh.shedload_id
INNER JOIN rasp_gp on rasp_ld.loadsnum=rasp_gp.grpinn and rasp_gp.grpggrp=rasp_sh.shedgroup
LEFT OUTER JOIN rasp_prep ON (rasp_prep.id = rasp_gp.grpteacher_id)
INNER JOIN rasp_pred ON (rasp_gp.grpsubject_id = rasp_pred.id)
INNER JOIN rasp_grp ON (rasp_ld.loadsklass_id_list = rasp_grp.id)
LEFT OUTER JOIN rasp_rom ON (rasp_sh.shedroom_id = rasp_rom.id)
LEFT OUTER JOIN rasp_stp ON (rasp_gp.grpstudy_type_id = rasp_stp.study_typesid)
WHERE rasp_grp.id=0 and
('' BETWEEN rasp_sh.shedbegin_date AND rasp_sh.shedend_date)
ORDER by
rasp_sh.shedday,ho
Прогула