SELECT t1.itemno, sum(t1.undeliqty) undeliqty FROM sa_orderitems t1 inner join sa_order t3 on t1.siteid=t3.siteid and t1.sa_orderid=t3.sa_orderid WHERE t3.STATUS in ('审核') and t1.siteid=$siteid$ and t1.itemno in $itemnos$ group by t1.itemno
