select t.tw_id, t.tw_symbol, t.tw_nazwa, t.tw_JednMiary, t.tw_IdGrupa,  sum(A.mr_pozostalo) as ilosc,  W.mw_cena as cena,  sum(dbo.fnInsMul( A.mr_pozostalo, W.mw_cena, 2 )) as wartosc,  t.tw_IdVatSp, t.tw_Rodzaj, max(a.mr_id) mr_id, max(a.mr_data) mr_data  from dok_magruch A  inner join tw__towar T on A.mr_TowId = T.tw_Id   inner join vwDokMagWart W on A.mr_SeriaId = W.mw_SeriaId  where    W.mw_pozid in (SELECT TOP 1 T.mw_pozid  FROM vwDokMagWart T  WHERE T.mw_SeriaId = W.mw_seriaid  ORDER BY mw_data DESC, mw_pozid DESC) and A.mr_pozostalo>0  and A.mr_magid in (1) group by t.tw_id, t.tw_symbol, t.tw_nazwa, t.tw_JednMiary, t.tw_IdGrupa,  W.mw_cena,t.tw_IdVatSp, t.tw_Rodzaj