with waitingFulfillment as ( SELECT o.ordernum, o.orderid, o.orderdate, o.FSPro_UserID, o.RequesterFName, o.RequesterLName, o.RequesterFName + ' ' + o.RequesterLName as RequesterName, o.Email, o.dtneeded, o.status, o.shp_Date, o.shp_Company, t.orderTypeCode, t.orderTypeDesc, t.orderTypeSysType, floor( 10191817 * sqrt( orderid * log10( orderid ))) as tk, concat('SMPLORDFUL',orderid) as fulfillTrackingCode FROM tbl_POS_Orders o with(nolock) INNER JOIN tbl_POS_OrderTypes t with(nolock) on o.smpl_orderTypeId = t.orderTypeId WHERE o.OwnerID = AND o.FSL_TableCode = AND o.FulfillmentUserId = AND o.status in ('APS') AND o.smpl_orderTypeId = AND o.FSPro_UserID = AND (o.orderNum LIKE OR o.RequesterFName LIKE OR o.RequesterLName LIKE ) ), orders as ( select w.*, r.requestURL, r.disposition from waitingFulfillment w left outer join tbl_WRK_UserRequests r with(nolock) on r.requestTrackingCode = w.fulfillTrackingCode where r.ownerId = and r.ownerType = and r.disposition in ('?','Z') and ( r.fromUserId = or r.toUserId = ) ) #forJSON( 'orders', attributes.dataStore, 'orderdate desc' )#