SELECT Count(1)
FROM (SELECT DISTINCT s.ID AS OrderSourceID,
o.ServiceAdminID,
o.ServiceAdminName,
o.AmazonShipmentId,
o.ToWareHouseID,
s.OrderSourceName,
o.AddTime AS OrderAddTime,
o.OrderCode,
fhwh.ID AS DeliveryWareHouseID,
fhwh.WareHouseName AS DeliveryWareHouseName,
bkwh.ID AS RestockWareHouseID,
bkwh.WareHouseName AS RestockWareHouseName,
beikuExpand.TransitOutboundOrderCode,
o.TransportId,
t.TransportName,
beikuExpand.OrderBuildType,
( CASE
WHEN t.TransferType IS NULL THEN beikuExpand.TransferType
ELSE t.TransferType
END ) AS TransferType,
CASE
WHEN Isnull(ol.GroupSKU, '') <> '' THEN ol.GroupSKU
ELSE
CASE
WHEN Isnull(ol.SKU, '') <> '' THEN ol.SKU
ELSE
CASE
WHEN Isnull(oll.GroupSKU, '') = '' THEN oll.SKU
ELSE oll.GroupSKU
END
END
END SKU,
CASE
WHEN Isnull(ol.SellerSKU, '') = '' THEN oll.SellerSKU
ELSE ol.SellerSKU
END OrderSourceSKU,
CASE
WHEN Isnull(whp.ASIN, '') = '' THEN whp2.ASIN
ELSE whp.ASIN
END ASIN,
'' OverseasSKU,
CASE
WHEN beikuExpand.OrderBuildType = 2 THEN 0
ELSE
CASE
WHEN Isnull(CASE
WHEN Isnull(ol.GroupSKU, '') = '' THEN ( ol.ProductNum
+ Isnull(ol.ProductNumUpdate, 0) )
ELSE ( ol.GroupProductNum
+ Isnull(ol.GroupProductNumUpdate, 0) )
END, '') = '' THEN ( CASE
WHEN Isnull(oll.GroupSKU, '') = '' THEN ( oll.ProductNum
+ Isnull(oll.ProductNumUpdate, 0) )
ELSE ( oll.GroupProductNum
+ Isnull(oll.GroupProductNumUpdate, 0) )
END )
ELSE ( CASE
WHEN Isnull(ol.GroupSKU, '') = '' THEN ( ol.ProductNum
+ Isnull(ol.ProductNumUpdate, 0) )
ELSE ( ol.GroupProductNum
+ Isnull(ol.GroupProductNumUpdate, 0) )
END )
END
END ShipNumber,
COALESCE(p.ShipTime, o.ShipTime) ShipTime,
p.PackageState,
p.ID AS PackageID,
CASE
WHEN Isnull(p.TrackNumber, '') = '' THEN Isnull(o.TrackNumbers, '')
ELSE p.TrackNumber
END TrackNumber,
s.SaleAdminID,
s.SaleAdminName
FROM RB_OrderInfo o (NOLOCK)
LEFT JOIN RB_Procurement_Order_Package p (NOLOCK)
ON p.MergerPackageNo = o.OrderCode
AND p.CustomerID = o.CustomerID
LEFT JOIN dbo.RB_Procurement_Order_Package_OrderDetail (NOLOCK) opd
ON p.CustomerID = opd.CustomerID
AND p.ID = opd.PackageID
LEFT JOIN RB_OrderList ol (NOLOCK)
ON ol.ID = opd.OrderListID
AND ol.OrderCode = opd.OrderCode
AND ol.CustomerID = opd.CustomerID
LEFT JOIN RB_OrderList oll (NOLOCK)
ON oll.OrderCode = o.OrderCode
AND oll.CustomerID = o.CustomerID
LEFT JOIN RB_WareHouse_Product whp (NOLOCK)
ON whp.OrderSourceID = o.OrderSourceID
AND whp.CustomerID = ol.CustomerID
AND whp.OrderSourceSKU = ol.SellerSKU
LEFT JOIN RB_WareHouse_Product whp2 (NOLOCK)
ON whp2.OrderSourceID = o.OrderSourceID
AND whp2.CustomerID = oll.CustomerID
AND whp2.OrderSourceSKU = oll.SellerSKU
LEFT JOIN RB_OrderSource s (NOLOCK)
ON o.OrderSourceID = s.ID
AND s.CustomerID = o.CustomerID
LEFT JOIN RB_Transport t (NOLOCK)
ON o.TransportID = t.ID
AND o.CustomerID = t.CustomerID
LEFT JOIN RB_OrderInfo_BeikuExpand beikuExpand (NOLOCK)
ON beikuExpand.CustomerID = o.CustomerID
AND o.OrderCode = beikuExpand.OrderCode
LEFT JOIN RB_WareHouse bkwh (NOLOCK)
ON bkwh.CustomerID = o.CustomerID
AND o.ToWareHouseID = bkwh.ID
LEFT JOIN RB_WareHouse fhwh (NOLOCK)
ON fhwh.CustomerID = o.CustomerID
AND o.WareHouseID = fhwh.ID
WHERE o.CustomerID = @CustomerID
AND o.IsStockOrder = @IsStockOrder
AND o.OrderStatus <> @OrderStatus
AND o.AmazonShipmentId IN(SELECT Id
FROM @TbShipmentId)) AS PagerTable 
任务描述