select
  mz.kod as Kod_towaru,
  mz.opis as Nazwa_towaru,
  kh.kod as Magazyn,
  tw.typks as Kategoria,
  CASE WHEN iloscwp < 0 THEN iloscwp *(-1) ELSE 0 END as Ilosc_plus,
  przychod *-1 as Przychod,
  CASE WHEN iloscwp > 0 THEN iloscwp ELSE 0 END as Ilosc_minus,
  rozchod as Rozchod
from
  hm.mz as mz
  inner join hm.kh as kh on kh.id = mz.magazyn
  inner join hm.tw as tw on mz.idtw = tw.id
where
  mz.flag NOT IN ('9984', '9728', '8704', '8960')
  and mz.bufor = 0
  and mz.kompensata = 0

SELECT TW.id
   ,TW.katalog
   ,TW.rodzaj
   ,TW.znacznik
   ,TW.typ
   ,TW.subtyp
   ,TW.subtypext
   ,TW.vatsp
   ,TW.sww
   ,TW.pcn
   ,TW.jm
   ,TW.jmdef
   ,TW.jmdod1
   ,TW.przeljmdod1
   ,TW.jmdod2
   ,TW.przeljmdod2
   ,TW.przelkg
   ,TW.przeluz
   ,TW.jmuzup
   ,TW.nazwa
   ,TX.opis
   ,TW.kod
   ,ISNULL(a.wartosc, 0) + ISNULL(s.wartosc, 0)
   ,ISNULL(a.ilosc, 0) + ISNULL(s.stan, 0)
FROM TW
LEFT JOIN TX ON (TX.id = TW.idlongname)
JOIN (
   SELECT SM.idtw
      ,sum(ISNULL(SM.wartosc, 0)) wartosc
      ,sum(ISNULL(SM.stan, 0)) stan
   FROM SM
   JOIN ZZ ON ZZ.typ = 101
      AND ZZ.baza1 = 20
      AND ZZ.baza2 = 20
      AND ZZ.id1 = SM.magazyn
      AND ZZ.id2 = 32770
   WHERE SM.magazyn = 65563
   GROUP BY SM.idtw
   ) s ON TW.id = s.idtw
LEFT JOIN (
   SELECT MZ.idtw
      ,sum(ISNULL(MZ.ilosc, 0)) ilosc
      ,sum(ISNULL(przychod, 0) + ISNULL(rozchod, 0)) wartosc
   FROM MZ
   JOIN ZZ ON ZZ.typ = 101
      AND ZZ.baza1 = 20
      AND ZZ.baza2 = 20
      AND ZZ.id1 = MZ.magazyn
      AND ZZ.id2 = 32770
   WHERE MZ.data <= '2021-09-06'
      AND MZ.data >= '2021-09-11'
      AND ISNULL(MZ.bufor, 0) = 0
      AND (ISNULL(MZ.typ, 0) & 0x01) = 0
      AND MZ.magazyn = 65563
   GROUP BY MZ.idtw
   ) a ON TW.id = a.idtw
WHERE TW.subtyp = 0
   AND TW.typ = 0

   WHERE MZ.data <= '2021-09-06'
      AND MZ.data >= '2021-09-11'