Třídová akce

Kód:

17

Tělo:

select
  pd2.OrderCreatedBy_ID as User_ID,
  sum(pd2.OrderPrintState) as xCount
from
  posdocuments2 PD2
  left join posdocuments PD on pd.id=pd2.Parent_ID
where
  (pd2.OrderKind>0) and
  (pd2.OrderPrintState=1) and
  (pd.Shop_ID=:Shop_ID)
group by
  pd2.OrderCreatedBy_ID

Generated by ABRA Software a.s. 27.10.2021 16:34:30