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