Главная » Поступающим в 2025 году » Расписание и результаты вступительных испытаний

SELECT u.lastname, u.secondname, u.firstname, u.sex, abt_app.id_execution, sub.name subject_name, m.subject_id, sp.id speciality_id, m.mark, m.exam_building_id building, m.date_plan edate, m.etime, m.is_published, aai.phone_mob, IF(comp.id_form=1,'очно',IF(comp.id_form=2,'заочно','очно-заочно')) spec_type_id, IF(abt_app.is_budget=1, 'бюджет', IF(abt_app.is_budget=0, 'договор', 'бюджет/договор')) payment_type_id, sp.code, CONCAT(sp.name, IF(prof.title_2 IS NOT NULL, CONCAT(' (', prof.title_1, '. ', prof.title_2, ')'), IF(prof.title_1 IS NOT NULL, CONCAT(' (', prof.title_1, ')'), '')) ) 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 abt_comp_groups a LEFT OUTER JOIN abt_competitions comp ON comp.id = a.id_competition LEFT OUTER JOIN abt_app ON abt_app.id = a.id_app LEFT OUTER JOIN user_execution ue ON ue.id = abt_app.id_execution LEFT OUTER JOIN user u ON u.id = ue.id_user LEFT OUTER JOIN abit_add_info aai ON aai.id_execution=abt_app.id_execution LEFT OUTER JOIN abt_directions sp ON sp.id=comp.id_direction LEFT OUTER JOIN abt_profiles prof ON prof.id=comp.id_profile LEFT OUTER JOIN marks m ON m.id_comp_group = a.id LEFT OUTER JOIN abt_subjects 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-06-19')) AND a.is_deleted=0 AND m.exam_type=2 AND m.date_plan=UNIX_TIMESTAMP('2024-08-03') AND abt_app.is_deleted=0 GROUP BY u.lastname, u.firstname, m.date_plan, m.etime, m.subject_id, comp.id_form ORDER BY m.etime, u.lastname, a.id ASC