SELECT  ROW_NUMBER() OVER ( ORDER BY mes_wi.AutoID DESC ) AS rownum ,
        mes_wi.AutoID ,
        b_pd.CustomerID ,
        c.CustomerName ,
        cwo.ProductID ,
        b_pd.ProductName ,
        cwo.FabDevice ,
        cwo.Org ,
        cwo.WaferLot ,
        cwo.TargetDevice ,
        cwo.IsTax ,
        cwo.IsReturn ,
        mes_wo.Plan_StartTime ,
        cwo.WONumber ,
        cpo.Cust_PO ,
        mes_wi.IsArrived ,
        mes_wi.ArrivedTime ,
        mes_wi.CartonNo ,
        mes_wi.IsIQC ,
        mes_wi.IQCTime ,
        mes_wi.IsWIP ,
        mes_wi.WIPTime ,
        mes_wi.IsOutStock ,
        mes_wi.OutStockTime ,
        cwo.TradeType ,
        mes_wi.IsFGIN ,
        mes_wi.FGINTime ,
        mes_wi.IsScrap ,
        mes_wi.ScrapTime ,
        mes_wo_wi.WorkorderID ,
        mes_wi.IsPKG ,
        mes_wi.PKGTime ,
        mes_wi.IsShipping ,
        mes_wi.ShippingTime ,
        mes_wi.DieQty ,
        mes_wi.WaferNo ,
        mes_wo.WlcspLot ,
        mes_wi.Yield ,
        mes_wi.LMContext ,
        b_pd1.ProductName AS WO_ProductName ,
        mes_wi.GoodDie ,
        mes_wi.BadDie ,
        DATEDIFF(Day, ( SELECT  DATEADD(Hour, 8, mes_wop.OutTime) AS OutTime
                        FROM    MES_WorkorderProcess mes_wop
                        WHERE   mes_wop.WorkorderID = mes_wo_wi.WorkorderID
                                AND mes_wop.Sequence = 1
                                AND mes_wop.Deleted = 0
                      ), mes_wi.FGINTime) AS ProcessCT
FROM    MES_WaferInfo mes_wi
        LEFT OUTER JOIN Customer_WO cwo ON cwo.AutoID = mes_wi.CustomerWOID
        LEFT OUTER JOIN Customer_PO cpo ON cpo.AutoID = cwo.CustomerPOID
        LEFT OUTER JOIN Base_Product b_pd ON b_pd.AutoID = cwo.ProductID
        LEFT OUTER JOIN Customer c ON c.AutoID = b_pd.CustomerID
        LEFT OUTER JOIN MES_Workorder_WaferInfo mes_wo_wi ON mes_wo_wi.WaferInfoID = mes_wi.AutoID