select
        pocient.poc_id,
        pocient.poc_name,
        pocient.poc_fname,
        pocient.poc_lname,
        pocient.poc_dberth,
        adr_city.adrc_name,
        adr_street.adrs_name,
        pocient.adro_home1,
        pocient.adro_home2,
        pocient.adro_home3,
        priem.pr_date,
        diagnoz_full.dia_name
    from priem
        left join pocient on (priem.poc_id = pocient.poc_id)
        inner join podrazdelenij on (priem.podr_id = podrazdelenij.podr_id)
        right join diagnoz_full on (priem.dia_id = diagnoz_full.dia_id)
        inner join diagnoz_mkb on (priem.diamkb_id = diagnoz_mkb.diamkb_id)
        inner join adr_city on (adr_city.adrc_id = pocient.adrc_id)
        inner join adr_street on (adr_street.adrs_id = pocient.adrs_id)
    where
     (
        (
             priem.pr_date between :par1 AND :par2
        )
     )
     ORDER BY pocient.poc_id

List (cast(q.pr_date as varchar(20))|| ' -> ' ||cast(q.dia_name as varchar(300)), ',')