select mep.id, mep.indiv_id, mep.event_id,

                (select ssr.bdate
                from disp.md_event_patient mep1
                left join disp.md_event_service_patient mesp on mesp.event_patient_id = mep1.id
                left join disp.md_event_service mes on mes.id = mesp.service_id
                left join md_norm_document_service mnds on mnds.id = mes.doc_service_id
                left join (select ssr.id, msr.case_id, ssr.service_id, ssr.bdate from MD_SRV_RENDERED msr
                left join SR_SRV_RENDERED ssr on ssr.id = msr.id) as ssr on ssr.case_id = mep1.case_id and
                ssr.service_id = mes.service_id
                where mep1.id = mep.id and mnds.code in ('Д1.18','ПОВ_11')) --limit 1)

            , (select ssr.bdate from disp.md_event_patient mep1
                left join disp.md_event_service_patient mesp on mesp.event_patient_id = mep1.id
                left join disp.md_event_service mes on mes.id = mesp.service_id

                left join disp.md_event me on me.id=mep.event_id
                left join md_standard ms on ms.id = me.standard_id
                left join md_norm_document_service mnds on mnds.id = mes.doc_service_id

                left join (select ssr.id, msr.case_id, ssr.service_id, ssr.res_group_id, ssr.bdate from MD_SRV_RENDERED
                msr
                left join SR_SRV_RENDERED ssr on ssr.id = msr.id) as ssr on ssr.case_id = mep1.case_id and
                ssr.service_id = mes.service_id
                where mep1.id = mep.id and mnds.code = 'Д1.02' limit 1)
            , md.health_group_id, md.is_d, (case when (md.health_group_id is null) then (select exists(select 1 from md_srv_rendered msr
                join md_referral r on r.service_id = msr.id
                join md_referral_type rt on rt.id = r.referral_type_id
                where msr.case_id = mep.case_id and rt.code = '37'))
                else md.is_2_stage end)
            , md.is_therapy, md.adv_therapy, md.is_go_to_diagnostics_without, md.is_go_to_sanatorium, md.is_sanatorium, md.is_go_to_diagnostics_in, md.mes_id, me.mes_id, me.name, po.short_name, ffst.name, mct.name, me.event_type, me.org_id, me.org_id, mc.id, (select diagnos_id from mc_diagnosis where case_id=mc.id and is_main = true), mc.care_regimen_id
                from disp.md_event_patient mep
                left join disp.md_event me on me.id=mep.event_id
                left join pim_organization po on po.id = me.org_id
                left join fin_funding_source_type ffst on ffst.id = me.pay_type
                left join disp.md_event_type met on met.id = me.event_type
                left join mc_case_type mct on mct.id = met.case_type_id
                left join disp.md_dispr md on md.id=mep.id
              	left join mc_case mc on mc.id=mep.case_id
                where mep.id=45871196
                order by 1
             --limit 1