select t1.sa_orderitemsid,sum( ifnull(t1.outwarehouseqty,0)) sumoutwarehouseqty from sa_dispatch_items t1 where t1.siteid = $siteid$ AND t1.outwarehouseqty>0 and t1.sa_orderitemsid in $sa_orderitemsids$ group by t1.sa_orderitemsid
