SELECT TOP (100) PERCENT T0.OpprId, T0.CardCode, T1.CardName, T2.SlpName AS Sales, T10.USER_CODE, T3.Name AS Contact, T6.Descript AS FolderLocation, T1.GroupNum AS PaymentTerm, T0.Name, COALESCE (T0.ChnCrdCode, N'') AS EngCode, COALESCE (T0.ChnCrdName, N'') AS Engineer, T0.OpenDate, T0.PredDate, T0.MaxSumSys, T0.WtSumSys, T0.Memo AS SalesCycleStrategy, T0.Status, T0.StatusRem, T0.StepLast AS LastStage, T5.Descript AS ActualStage, T0.StepLast AS StageNo, T0.CloseDate, T0.PrjCode, T8.PrjName, COALESCE (T0.U_FCSDK_Net_SAP, 0) AS NetSAP, T5.Descript AS Stage, (SELECT TOP (1) Recontact FROM dbo.OCLG AS S0 WHERE (parentId = T0.OpprId) AND (parentType = 97) ORDER BY Recontact DESC) AS LastActivityDate, DATEDIFF(d, (SELECT TOP (1) Recontact FROM dbo.OCLG AS S0 WHERE (parentId = T0.OpprId) AND (parentType = 97) ORDER BY Recontact DESC), GETDATE()) AS DaysLastActivity, (SELECT TOP (1) ClgCode FROM dbo.OCLG AS S0 WHERE (parentId = T0.OpprId) AND (parentType = 97) ORDER BY Recontact DESC) AS LastActivityCode, (SELECT TOP (1) Details FROM dbo.OCLG AS S0 WHERE (parentId = T0.OpprId) AND (parentType = 97) ORDER BY Recontact DESC) AS LastActivitySubject, (SELECT TOP (1) LEFT(S1.firstName, 1) + LEFT(S1.lastName, 1) AS Initials FROM dbo.OCLG AS S0 INNER JOIN dbo.OHEM AS S1 ON S0.AttendUser = S1.userId WHERE (S0.parentId = T0.OpprId) AND (S0.parentType = 97) ORDER BY S0.Recontact DESC) AS LastActivityInitials, (SELECT COUNT(ClgCode) AS Expr1 FROM dbo.OCLG AS S0 WHERE (parentId = T0.OpprId) AND (parentType = 97)) AS ActivityCount, (SELECT COUNT(ClgCode) AS Expr1 FROM dbo.OCLG AS S1 WHERE (parentType = 97) AND (DATEDIFF(d, Recontact, GETDATE()) < 5) AND (parentId = T0.OpprId)) AS NewActivityCount, (SELECT TOP (1) CloseDate FROM dbo.OPR1 AS S3 WHERE (T0.OpprId = OpprId) ORDER BY CloseDate DESC) AS StageClose, (SELECT TOP (1) DocNumber FROM dbo.OPR1 AS S3 WHERE (T0.OpprId = OpprId) AND (ObjType = 23) ORDER BY CloseDate DESC) AS LastQuote, (SELECT TOP (1) DocNumber FROM dbo.OPR1 AS S3 WHERE (T0.OpprId = OpprId) AND (ObjType = 17) ORDER BY CloseDate DESC) AS LastOrder, (SELECT TOP (1) DocNumber FROM dbo.OPR1 AS S3 WHERE (T0.OpprId = OpprId) AND (ObjType = 15) ORDER BY CloseDate DESC) AS LastDelivery, (SELECT COUNT(DocNumber) AS Expr1 FROM dbo.OPR1 AS S3 WHERE (T0.OpprId = OpprId) AND (ObjType = 15)) AS TotalDelivery, (SELECT TOP (1) DocNumber FROM dbo.OPR1 AS S3 WHERE (T0.OpprId = OpprId) AND (ObjType = 13) ORDER BY CloseDate DESC) AS LastInvoice, (SELECT COUNT(DocNumber) AS Expr1 FROM dbo.OPR1 AS S3 WHERE (T0.OpprId = OpprId) AND (ObjType = 13)) AS TotalInvoice, (SELECT TOP (100) PERCENT COUNT(DocEntry) AS Expr1 FROM dbo.BP_Summary AS S0 WHERE (Type = 'Quote') AND (CardCode = T0.CardCode)) AS QuoteCount, (SELECT TOP (1) DocEntry AS Expr1 FROM dbo.BP_Summary AS S0 WHERE (Type = 'Quote') AND (CardCode = T0.CardCode) ORDER BY DocDate DESC) AS QuoteDoc, (SELECT TOP (1) DocDate AS Expr1 FROM dbo.BP_Summary AS S0 WHERE (Type = 'Quote') AND (CardCode = T0.CardCode) ORDER BY Expr1 DESC) AS QuoteDate, (SELECT TOP (1) Initials AS Expr1 FROM dbo.BP_Summary AS S0 WHERE (Type = 'Quote') AND (CardCode = T0.CardCode) ORDER BY DocEntry DESC) AS QuoteInitials, (SELECT TOP (100) PERCENT COUNT(DocEntry) AS Expr1 FROM dbo.BP_Summary AS S0 WHERE (Type = 'Activity') AND (CardCode = T0.CardCode)) AS ActCount, (SELECT TOP (1) DocDate AS Expr1 FROM dbo.BP_Summary AS S0 WHERE (Type = 'Activity') AND (CardCode = T0.CardCode) ORDER BY Expr1 DESC) AS ActDate, (SELECT TOP (1) DocEntry AS Expr1 FROM dbo.BP_Summary AS S0 WHERE (Type = 'Activity') AND (CardCode = T0.CardCode) ORDER BY DocDate DESC) AS ActEntry, (SELECT TOP (1) Initials AS Expr1 FROM dbo.BP_Summary AS S0 WHERE (Type = 'Activity') AND (CardCode = T0.CardCode) ORDER BY DocDate DESC) AS ActInitials, COALESCE ((SELECT TOP (1) Details AS Expr1 FROM dbo.BP_Summary AS S0 WHERE (Type = 'Activity') AND (CardCode = T0.CardCode) ORDER BY DocDate DESC), N'- No Activity Detail -') AS ActDetails, (SELECT TOP (100) PERCENT COUNT(DocEntry) AS Expr1 FROM dbo.BP_Summary AS S0 WHERE (Type = 'Service Call') AND (CardCode = T0.CardCode)) AS ServCount, (SELECT TOP (1) DocEntry AS Expr1 FROM dbo.BP_Summary AS S0 WHERE (Type = 'Service Call') AND (CardCode = T0.CardCode) ORDER BY DocDate DESC) AS ServDoc, COALESCE ((SELECT TOP (1) Details AS Expr1 FROM dbo.BP_Summary AS S0 WHERE (Type = 'Service Call') AND (CardCode = T0.CardCode) ORDER BY DocDate DESC), N'- No Service Calls -') AS ServDetail FROM dbo.OOPR AS T0 INNER JOIN dbo.OCRD AS T1 ON T0.CardCode = T1.CardCode INNER JOIN dbo.OSLP AS T2 ON T0.SlpCode = T2.SlpCode LEFT OUTER JOIN dbo.OCPR AS T3 ON T0.CprCode = T3.CntctCode INNER JOIN dbo.OOST AS T5 ON T0.StepLast = T5.Num LEFT OUTER JOIN dbo.OOIR AS T6 ON T0.IntRate = T6.Num LEFT OUTER JOIN dbo.OTER AS T7 ON T0.Territory = T7.territryID LEFT OUTER JOIN dbo.OPRJ AS T8 ON T0.PrjCode = T8.PrjCode LEFT OUTER JOIN dbo.OHEM AS T9 ON T2.SlpCode = T9.salesPrson LEFT OUTER JOIN dbo.OUSR AS T10 ON T9.userId = T10.USERID