SELECT        ei.entrant_surname, ei.entrant_name, ei.entrant_patronymic,
                             (SELECT        ic.identity_control_value
                               FROM            identity_control AS ic INNER JOIN
                                                         control AS c ON ic.control_id = c.control_id
                               WHERE        (i.identity_id = ic.identity_id) AND (c.control_type_id = 1)) AS series,
                             (SELECT        ic.identity_control_value
                               FROM            identity_control AS ic INNER JOIN
                                                         control AS c ON ic.control_id = c.control_id
                               WHERE        (i.identity_id = ic.identity_id) AND (c.control_type_id = 2)) AS number, it.identity_type_short_name,
                         CASE WHEN ei.entrant_sex = 1 THEN 'М' ELSE 'Ж' END AS Пол, CONVERT(varchar(10), COALESCE (ei.entrant_birthday, '01.01.2010'), 104) AS birthday,
                         en.entrant_part_type_id AS код_категории_участника, NULL AS Код_региона,
                         CASE WHEN edu_doc.edu_doc_medal = 0 THEN 0 WHEN edu_doc.edu_doc_medal = 1 THEN 1 ELSE 2 END AS Медаль, 0 AS Признак_спец_рассадки,
                         edu_form.edu_form_id AS Код_формы_обучения, CASE WHEN en.citizenship_id IN (7, 8, 4, 2, 18, 11, 20, 9, 19, 3, 5, 10, 6, 12)
                         THEN 1 WHEN en.citizenship_id = 1 THEN 0 ELSE 2 END AS Гражданство,
                             (SELECT        TOP (1) exam_id
                               FROM            exam_result
                               WHERE        (admission_campagn.admission_campagn_id = 2) AND (exam_id IN (389, 390, 391, 392, 393, 394, 395, 396, 398, 399)) AND
                                                         (exam_result_status_id = 4) AND (ei.entrant_info_id = entrant_info_id)) AS ExAm
FROM            entrant AS en INNER JOIN
                         entrant_info AS ei ON en.entrant_info_id = ei.entrant_info_id INNER JOIN
                         [identity] AS i ON ei.entrant_info_id = i.entrant_info_id INNER JOIN
                         identity_type AS it ON i.identity_type_id = it.identity_type_id INNER JOIN
                         app_request AS ar ON ar.entrant_info_id = ei.entrant_info_id AND ar.app_request_priority_spec = 1 INNER JOIN
                         edu AS e ON e.edu_id = ar.edu_id INNER JOIN
                         subdivision_data AS sd ON sd.subdivision_id = e.sub_subdivision_id INNER JOIN
                         edu_form ON e.edu_form_id = edu_form.edu_form_id INNER JOIN
                         edu_doc ON en.entrant_info_id = edu_doc.entrant_info_id INNER JOIN
                         entrant ON ar.entrant_info_id = entrant.entrant_info_id AND edu_doc.entrant_info_id = entrant.entrant_info_id INNER JOIN
                         entrant2adm_camp ON en.entrant_info_id = entrant2adm_camp.entrant_info_id AND entrant.entrant_info_id = entrant2adm_camp.entrant_info_id INNER JOIN
                         admission_campagn ON entrant2adm_camp.admission_campagn_id = admission_campagn.admission_campagn_id INNER JOIN
                         exam_result AS exam_result_1 ON en.entrant_info_id = exam_result_1.entrant_info_id AND entrant.entrant_info_id = exam_result_1.entrant_info_id
WHERE        (admission_campagn.admission_campagn_id = 2)