Расписание и результаты вступительных испытаний 28.09.2020

SELECT u.lastname, u.secondname, u.firstname, u.sex, a.id_execution, sub.name subject_name, m.subject_id, a.cg_id speciality_id, m.mark, m.exam_building_id building, m.date_plan edate, m.etime, m.is_published, aai.phone_mob, IF(a.spec_type_id=1,'очно',IF(a.spec_type_id=2,'заочно','очно-заочно')) spec_type_id, IF(a.payment_type_id=1, 'бюджет', IF(a.payment_type_id=2, 'договор', 'бюджет/договор')) payment_type_id, sp.code, sp.name spec, es.ctime consult_time, DATE_FORMAT( es.cdate , '%d.%m.%Y' ) consult_date, IF(u.sex=1,'М','Ж') sex, lka_sn.snils snils_value, ue.personal_number FROM app a LEFT OUTER JOIN user u ON u.id = a.user_id LEFT OUTER JOIN abit_add_info aai ON aai.id_execution=a.id_execution LEFT OUTER JOIN user_execution ue ON ue.id = a.id_execution LEFT OUTER JOIN spec sp ON sp.id=a.cg_id LEFT OUTER JOIN marks m ON m.app_id = a.id LEFT OUTER JOIN subjects_abt sub ON sub.id = m.subject_id LEFT OUTER JOIN exam_schedule es ON es.subject_id = m.subject_id AND es.edate=DATE_FORMAT( FROM_UNIXTIME( m.date_plan ) , '%Y-%m-%d' ) AND es.etime=m.etime LEFT OUTER JOIN lka_snils lka_sn ON lka_sn.id_user=u.id WHERE u.lastname IS NOT NULL AND m.date_plan>UNIX_TIMESTAMP(DATE_FORMAT(NOW(),'%Y-03-10')) AND a.is_deleted=0 AND m.exam_type=2 AND m.date_plan=UNIX_TIMESTAMP('2020-09-28') GROUP BY u.lastname, u.firstname, m.date_plan, m.etime ORDER BY m.etime, u.lastname, a.id ASC

Вступительные испытания не найдены