SELECT clinic_id AS "Клиника", i.surname || ' '|| i.NAME || ' ' ||i.patr_name AS "Врач",
o.short_name AS "Аптека",mrs.NAME AS "Признак рецепта", mr.series  AS "Серия", mr.number AS "Номер", mr.issue_dt AS "Дата выдачи", mrv.NAME AS "Срок действия", d.code || ' ' ||d.NAME AS "Заболевание",
ii.name_rus AS "МНН",
ih.name_trade AS "Торговое наименование",
mbd.form AS "Форма выпуска",
mrm.dosage AS "Дозировка",
mrm.dtd AS "D.t.d",
um.NAME AS "Signa",
mrm.count AS "Количество",
mrm.notes AS "Рекомендации приема (примечание)",
patient.surname ||' ' ||patient.surname  || ' '|| patient.surname ||  ' ' ||to_char(patient.birth_dt , 'dd.mm.yyyy')  as "Пациент"

FROM md_receipt mr
LEFT JOIN pim_employee pe ON pe.id = mr.employee_id
LEFT JOIN pim_individual i ON i.id = pe.individual_id
LEFT JOIN pim_organization o ON o.id = mr.pharmacy_id
LEFT JOIN md_receipt_sign mrs ON mrs.id = mr.sign_id
LEFT JOIN md_receipt_validity mrv ON mrv.id = mr.validity_id
LEFT JOIN md_diagnosis d ON d.id = mr.diagnosis_id
LEFT JOIN md_receipt_medicine mrm ON mrm.receipt_id = mr.id
LEFT JOIN inv_inn ii ON ii.id = mrm.inn_id
LEFT JOIN inv_holding ih ON ih.id = mrm.holding_id
LEFT JOIN md_receipt_medicine_using_mode um ON um.id = mrm.using_mode_id
LEFT JOIN  md_benefit_detalization mbd ON mbd.id =mrm.benefit_detalization_id
join pim_individual as patient on patient.id  =patient_id

WHERE (patient.id in (select "supp"."reciept_patient_search"($1))
or mr.series || mr.number like  ($1||'%')
or patient.id = $2
)
and
(COALESCE($3::date,current_date) between coalesce (mr.begin_date::DATE, '1900-01-01'::DATE) and  COALESCE(mr.end_date::DATE, '2900-01-01'::DATE)
)