SELECT mc.id, mc.clinic_id, mc.uid, '№' || COALESCE ( mc.uid, '' ) || ' Открыт:' || COALESCE ( to_char ( mc.create_date, 'dd.mm.yyyy' ), '' ) || ' ' || COALESCE ( md1.code, '' ) || ' ' || COALESCE ( md1.name, '' ), mc.closing_step_id, mc.patient_id, mc.create_date, ( SELECT row_to_json ( t ) FROM ( SELECT mct.id AS id, mct.name AS name FROM mc_case_type mct WHERE mc.case_type_id = mct.id ) AS t ), ( SELECT row_to_json ( l ) FROM ( SELECT mcl.id AS id, mcl.name AS name FROM mc_care_level mcl WHERE mc.care_level_id = mcl.id ) AS l ), ( SELECT row_to_json ( st ) FROM ( SELECT ffst.id AS id, ffst.name AS name FROM fin_funding_source_type ffst WHERE mc.funding_id = ffst.id ) AS st ), ( SELECT row_to_json ( r ) FROM ( SELECT mcr.id AS id, mcr.name AS name FROM mc_care_regimen mcr WHERE mc.care_regimen_id = mcr.id ) AS r ), ( SELECT row_to_json ( pf ) FROM ( SELECT mcpf.id AS id, mcpf.name AS name FROM md_care_providing_form mcpf WHERE mc.care_providing_form_id = mcpf.id ) AS pf ), ( SELECT row_to_json ( ig ) FROM ( SELECT mcig.id AS id, mcig.name AS name FROM mc_case_init_goal mcig WHERE mc.init_goal_id = mcig.id ) AS ig ), ( SELECT row_to_json ( pc ) FROM ( SELECT mcpc.id AS id, mcpc.name AS name FROM md_care_provision_condition mcpc WHERE mc.provision_condition_id = mcpc.id ) AS pc ), ( SELECT row_to_json ( ar ) FROM ( SELECT mar.id AS id, mar.name AS name FROM mc_admission_reason mar WHERE mc.admission_reason_id = mar.id ) AS ar ), FALSE, FALSE, ( SELECT ms.admission_date FROM mc_step ms WHERE ms.case_id = mc.id AND ms.admission_date + ms.admission_time = ( SELECT min ( ms1.admission_date + ms1.admission_time ) FROM mc_step ms1 WHERE ms1.case_id = mc.id LIMIT 1 ) LIMIT 1 ), '23981' FROM mc_case mc JOIN public.mc_case_type ct ON ct.id = mc.case_type_id LEFT JOIN mc_diagnosis md ON ( mc.main_diagnos_id = md.id ) LEFT JOIN md_diagnosis md1 ON ( md.diagnos_id = md1.id ) WHERE ct.case_mode_id = 1 AND EXISTS ( SELECT st.id FROM mc_step st WHERE st.case_id = mc.id AND st.profile_id IN ( SELECT DISTINCT prof.profile_id FROM public.sr_res_group_profile prof JOIN public.sr_res_group_relationship rel ON rel.group_id = prof.res_group_id JOIN public.pim_employee_position_resource pepr ON pepr.id = rel.resource_id WHERE pepr.employee_position_id = '23981' ) ) AND mc.id = '15831217' AND '23981' = '23981' ORDER BY mc.open_date DESC LIMIT 1;