select PZ_Elem.TrE_KosztKsiegowy, PZ_Elem.TrE_Ilosc,PZ_Elem.TrE_KosztKsiegowy/PZ_Elem.TrE_Ilosc as Iloraz,* from sed.BudSubElem
join sed.BudElem on bse_belid = bel_belid
join CDN.ZlcNag on bel_trngidtyp = Zcn_GIDTyp AND bel_trngidnumer = Zcn_GIDNumer
JOIN CDN.ZlcElem ON ZcN_GIDTyp=ZcE_GIDTyp AND ZcN_GIDNumer=ZcE_GIDNumer AND
    ZCE_TwrTyp = bse_twrgidtyp and zce_TwrNumer = bse_twrgidnumer
JOIN cdn.TranAg On TrN_ZaNTyp=ZcE_GIDTyp AND TrN_ZaNNumer=ZcE_GIDNumer
JOIn CDN.TraElem ON TrN_GIDTyp=TrE_GIDTyp AND TrN_GIDNumer=TrE_GIDNumer AND
    tre_TwrTyp = bse_twrgidtyp and tre_TwrNumer = bse_twrgidnumer
JOIN CDN.TraSElem ON TrE_GIDTyp=TrS_GIDTyp AND TrE_GIDNumer=TrS_GIDNumer AND TrE_GIDLp=TrS_GIDLp
JOIN CDN.Dostawy ON Dst_GIDTyp=TrS_DstTyp AND Dst_GIDNumer=TrS_DstNumer
JOIN CDN.TraNag as PZ ON PZ.TrN_GIDTyp=Dst_TrnTyp AND PZ.TrN_GIDNumer=Dst_TrnNumer
JOIn CDN.TraElem as PZ_Elem ON PZ.TrN_GIDTyp=PZ_Elem.TrE_GIDTyp AND PZ.TrN_GIDNumer=PZ_Elem.TrE_GIDNumer AND
    PZ_Elem.tre_TwrTyp = bse_twrgidtyp and PZ_Elem.tre_TwrNumer = bse_twrgidnumer
where  bse_twrgidtyp = :twrtyp AND bse_twrgidnumer = :twrnumer
and bse_usuniety = 0
and bel_budid= :budid
ORDER BY CDN.TraNag.TrN_DataMag DESC