SELECT        T.tw_Id AS TU_ID, T.tw_Nazwa AS TU_NAZWA, T.tw_Symbol AS TU_KOD, NULL AS TU_KODEX, T.tw_PKWiU AS TU_PKWIU, T.tw_JednMiary AS TU_JEDNOSTKA, S.st_Stan AS TU_ILOSC, ISNULL(CZ.cena_zakupu, 
                         0) AS TU_CENAJZAKUPU, C.tc_WalutaId AS TU_CENAJZWALUTA, C.tc_CenaNetto2 AS TU_CENAJHURTOWA, C.tc_Marza2 AS TU_CENAJHMARZA, C.tc_IdWaluta2 AS TU_CENAJHMWALUTA, 
                         C.tc_CenaNetto1 AS TU_CENAJDETALICZNA, C.tc_Marza1 AS TU_CENAJDMARZA, C.tc_IdWaluta1 AS TU_CENAJDWALUTA, C.tc_CenaNetto3 AS TU_CENAJSPECJALNA, C.tc_Marza3 AS TU_CENAJSMARZA, 
                         C.tc_IdWaluta3 AS TU_CENAJSWALUTA, R.rt_Procent AS TU_RABAT, SV.vat_Stawka AS TU_VAT, G.grt_Nazwa AS TU_GRUPATOWAROWA, M.mag_Id AS TU_MAGAZYNID, M.mag_Nazwa AS TU_MAGAZYNNAZWA, 
                         Z.zd_Zdjecie AS TU_ZDJECIE, NULL AS TU_ZDJECIE_PATH, T.tw_Opis AS TU_OPIS, ABS(S.st_StanRez) AS TU_REZERWACJA, T.tw_StanMin AS TU_STANMIN, T.tw_DostSymbol AS TU_SYMBOLTW_DOST, 
                         DOST.kh_Symbol AS TU_SYMBOL_DOST
FROM            dbo.tw__Towar AS T LEFT OUTER JOIN
                         dbo.kh__Kontrahent AS DOST ON DOST.kh_Id = T.tw_IdPodstDostawca LEFT OUTER JOIN
                         dbo.tw_Cena AS C ON T.tw_Id = C.tc_IdTowar LEFT OUTER JOIN
                             (SELECT        a.mr_TowId, ISNULL(b.mw_Cena, 0) AS cena_zakupu
                               FROM            (SELECT        MAX(mr_Id) AS mr_Id, mr_TowId
                                                         FROM            dbo.dok_MagRuch WITH (NOLOCK)
                                                         WHERE        (mr_Id = mr_SeriaId)
                                                         GROUP BY mr_TowId) AS x LEFT OUTER JOIN
                                                         dbo.dok_MagRuch AS a WITH (NOLOCK) ON a.mr_TowId = x.mr_TowId AND a.mr_Id = x.mr_Id LEFT OUTER JOIN
                                                         dbo.dok_MagWart AS b WITH (NOLOCK) ON a.mr_SeriaId = b.mw_SeriaId) AS CZ ON CZ.mr_TowId = T.tw_Id LEFT OUTER JOIN
                         dbo.tw_Stan AS S ON T.tw_Id = S.st_TowId LEFT OUTER JOIN
                         dbo.sl_StawkaVAT AS SV ON T.tw_IdVatSp = SV.vat_Id LEFT OUTER JOIN
                         dbo.sl_Rabat AS R ON T.tw_IdRabat = R.rt_id LEFT OUTER JOIN
                         dbo.sl_GrupaTw AS G ON T.tw_IdGrupa = G.grt_Id LEFT OUTER JOIN
                         dbo.sl_Magazyn AS M ON S.st_MagId = M.mag_Id LEFT OUTER JOIN
                         dbo.tw_ZdjecieTw AS Z ON T.tw_Id = Z.zd_IdTowar AND Z.zd_Glowne = 1
WHERE        (M.mag_Id = 1) OR
                         (M.mag_Id = 3)