select man.ufs_nmk as manager,ex.ufs_nmk as expeditor,
tov.skln_cd,nak.sklnk_nmr,nak.sklnk_dat,skln_rcd,sklgr_nm,
nak.sklnk_kagidnm,
tov.skln_nm,
poz.trds_qtosn,
poz.trds_sum,
case adr.ptn_rcd--adr.filia_adr
when  '4350' then adr.filia_email
else adr.filia_adr
end as address
from sklnk nak
left join trds poz on nak.sklnk_rcd=poz.trds_rcdhdr
left join skln tov on tov.skln_rcd=poz.trds_rcdnom
left join ptnrk agn on nak.sklnk_kagrcd=agn.ptn_rcd
left join ptnfilk adr on adr.filia_rcd=nak.sklnk_gpladr and  agn.ptn_rcd=adr.ptn_rcd
left join ufprv mm on mm.uf_tblrcd=nak.sklnk_rcd and mm.uf_rkrcd=148
left join ufprv ee on ee.uf_tblrcd=nak.sklnk_rcd and ee.uf_rkrcd=150
left join UFSPR man on man.ufs_cds=mm.UF_rkvalS and man.ufs_rcd=3
left join UFSPR ex on ex.ufs_cds=ee.UF_rkvalS and ex.ufs_rcd=7
left join sklgr gr on tov.skln_rcdgrp=gr.sklgr_rcd
where sklnk_type=3 and sklnk_mov=0
and  trds_typhdr=1
and sklnk_dat>='2011-04-01'
and sklnk_dat<='2011-05-01'