select r.id, r.service_id, r.referral_type_id, r.order_number, r.referral_date, r.ref_organization_id, r.recv_organization_id, r.ref_department_id, r.department_id, r.ref_doctor_id, r.recv_doctor_id, r.diagnosis_id, rs.service_id, rs.service_prototype_id, re.speciality_id, re.profile_id, r.patient_id, r.step_id, msr.case_id, ro.short_name, eo.short_name, coalesce(s.name, sp.name), 'enable', $1,
                (select s.norm_document_id from md_standard s
                join disp.md_event me on s.id = me.standard_id
                join disp.md_event_patient mep on mep.event_id = me.id
                where mep.case_id = msr.case_id limit 1)
            , mep.id, mep.event_id,
                (select mes.last from disp.md_event_service mes
                join disp.md_event_service_patient mesp on mesp.event_patient_id = mep.id
                where mes.event_id = mep.event_id
                and mes.id = mesp.service_id
                and mes.service_id = s.id
                and mes.org_id = eo.id
                and mes.is_2_stage limit 1)
            , rds.code = '2', rds.code = '3', rds.name
                from md_referral r
                left join md_ref_document_status rds on rds.id = r.status_id
                left join md_referral_service rs on rs.referral_id = r.id
                left join disp.md_referral_extended re on r.id = re.id
                left join pim_organization ro on ro.id = r.ref_organization_id
                left join pim_organization eo on eo.id = r.recv_organization_id
                left join sr_service s on s.id = rs.service_id
                left join sr_srv_prototype sp on sp.id = rs.service_prototype_id
                left join sr_srv_rendered ssr on r.service_id = ssr.id
                left join md_srv_rendered msr on msr.id = ssr.id
                left join disp.md_event_patient mep on mep.case_id = msr.case_id
                where msr.case_id = $2 and $3=$4 and mep.event_id=$5
                order by 1
             limit 11