Administrace komentářů

select zb.idzbozi, zb.TypKarty, st.Status, moc.CenaBez, zb.CisloZbozi, zb.NazevZbozi, st.PopisStZb, zb.stavsklad, moc.
vis-# CenasDPH
vis-#                , coalesce(cen.Cen3=1, false) as Cen3, coalesce(cen.Cen1=1, false) as Cen1, coalesce(cen.Cen5=1, false) as Cen5
vis-#         , coalesce(cen.OCen3=1, false) as OCen3, coalesce(cen.OCen1=1, false) as OCen1, coalesce(cen.OCen5=1, false) as OCen5
vis-#           from visgl.zbozi zb
vis-#           left join (
vis(#                 select idzbozi , max(case when idcenik = 3 then 1 else 0 end) as Cen3, max(case when idcenik = 1 then 1 else 0 end) as Cen1, max(case when idcenik = 5 then 1 else 0 end) as Cen5
vis(#         , max(case when idcenik = 3 then 1 else 0 end) as OCen3, max(case when idcenik = 1 then 1 else 0 end) as OCen1, max(case when idcenik = 5 then 1 else 0 end) as OCen5
vis(#                   from visgl.zb_cenik
vis(#               where '2011-03-30' BETWEEN PlatiOd AND coalesce(PlatiDo, '2100-01-01')
vis(#                  group by 1
vis(#          ) cen on zb.idzbozi = cen.idzbozi
vis-#           left join visgl.Zb_Status_Akt st ON zb.IDZbozi = st.IDZbozi
vis-#           left join visgl.Zb_Cena_Akt moc ON zb.IDZbozi = moc.IDZbozi
vis-#           left join visgl.Zatrid_LRZ lrz ON zb.IDZatrid = lrz.IDLinie
vis-#           left join visgl.Znacky zna ON lrz.IDZnacky = zna.IDZnacky
vis-#          where 1=1  AND zb.TypKarty = 'Z' AND (lrz.IDZnacky IN ( 1))
vis-#          order by zb.TypKarty desc, zb.NazevZbozi
vis-# ;

 select cast(Sum(vydejpol0_.pocetks) as int4) as col_0_0_ from visgl.vydejpol vydejpol0_, visgl.zbozi zbozi1_, visgl.vydejdl vydejdl2_ where vydejpol0_.idzbozi=zbozi1_.idzbozi and vydejpol0_.iddl=vydejdl2_.iddl  and zbozi1_.idzatrid=((53)::int4) and vydejdl2_.idprodejny=((317)::int4) and vydejdl2_.datum>=((E'2010-03-29 00:00:00.000000')::timestamptz) and vydejpol0_.typradku='Z'
vis-# ;