SharePoint ULS Log errors

10-25-2011 13:25:43.67 w2wp.exe - Windows SharePoint Services - Database - 880i - High:

System.Threading.ThreadAbortException: Thread was being aborted.
 at SNIReadSync(SNI_Conn* , SNI_Packet** , Int32 )
 at SNINativeMethodWrapper.SNIReadSync(SafeHandle pConn, IntPtr& packet, Int32 timeout)
 at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)
 at System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket()
 at System.Data.SqlClient.TdsParserStateObject.ReadBuffer()
 at System.Data.SqlClient.TdsParserStateObject.ReadByte()
 at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
 at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
 at System.Data.SqlClient.SqlDataReader.get_MetaData()
 at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
 at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
 at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
 at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
 at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
 at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
 at Microsoft.SharePoint.Utilities.SqlSession.ExecuteReader(SqlCommand command, CommandBehavior behavior)

10-25-2011 13:25:43.67 w2wp.exe - Windows SharePoint Services - Database - 880k - High:

at Microsoft.SharePoint.SPSqlClient.ExecuteQuery(Boolean& bSucceed)
 at Microsoft.SharePoint.Library.SPRequestInternalClass.GetListItemDataWithCallback(String bstrUrl, String bstrListName, String bstrViewName, String bstrViewXml, SAFEARRAYFLAGS fSafeArrayFlags, ISP2DSafeArrayWriter pSACallback, ISPDataCallback pPagingCallback, ISPDataCallback pSchemaCallback)
 at Microsoft.SharePoint.Library.SPRequest.GetListItemDataWithCallback(String bstrUrl, String bstrListName, String bstrViewName, String bstrViewXml, SAFEARRAYFLAGS fSafeArrayFlags, ISP2DSafeArrayWriter pSACallback, ISPDataCallback pPagingCallback, ISPDataCallback pSchemaCallback)
 at Microsoft.SharePoint.SPListItemCollection.EnsureListItemsData()
 at Microsoft.SharePoint.SPListItemCollection.get_Count()
 at Microsoft.SharePoint.Publishing.WebControls.DocumentLibraryFileExistValidator.EvaluateIsValid()
 at System.Web.UI.WebControls.BaseValidator.Validate()
 at System.Web.UI.Page.Validate()
 at Microsoft.SharePoint.Publishing.Internal.CodeBehind.CreatePagePage.Validate()
 at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
 at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
 at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
 at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
 at System.Web.UI.Page.ProcessRequest()
 at System.Web.UI.Page.ProcessRequest(HttpContext context)
 at ASP._layouts_createpage_aspx.ProcessRequest(HttpContext context)
 at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
 at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
 at System.Web.HttpApplication.ApplicationStepManager.ResumeSteps(Exception error)
 at System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
 at System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
 at System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)
 at System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)

10-25-2011 13:25:43.69 w2wp.exe - Windows SharePoint Services - Database - 880l - High:

ConnectionString: 'Data Source=NCDOMSQL01;Initial Catalog=WSS_Content_87363d4b81154cf3810fe83d4c34ac56;Integrated Security=True;Enlist=False;Connect Timeout=15'    ConnectionState: Closed ConnectionTimeout: 15

10-25-2011 13:25:43.69 w2wp.exe - Windows SharePoint Services - Database - 880m - High:

SqlCommand: ' SELECT TOP 2147483648 t1.[TimeCreated] AS c0,t3.[nvarchar4] AS c10c5,UserData.[datetime1],t1.[Id] AS c15,t4.[nvarchar1] AS c17c3,UserData.[tp_ItemOrder],UserData.[nvarchar1],UserData.[int12],t20.[int2] AS c36,t1.[CheckinComment] AS c57,UserData.[ntext1],t37.[tp_ID] AS c51c4,UserData.[nvarchar19],UserData.[int7],t2.[nvarchar1] AS c2c3,UserData.[bit1],UserData.[nvarchar22],UserData.[int11],t20.[int8] AS c42,t20.[int13] AS c47,t36.[nvarchar7] AS c50c21,UserData.[tp_GUID],t1.[LeafName] AS c1,t3.[nvarchar5] AS c10c6,UserData.[nvarchar18],UserData.[int6],CASE WHEN DATALENGTH(t1.DirName) = 0 THEN t1.LeafName WHEN DATALENGTH(t1.LeafName) = 0 THEN t1.DirName ELSE t1.DirName + N'/' + t1.LeafName END  AS c11,t1.[ScopeId] AS c16,t4.[tp_ID] AS c17c4,UserData.[nvarchar21],UserData.[int10],t20.[int3] AS c37,t1.[Size] AS c53,UserData.[tp_WorkflowVersion],t1.[ParentVersionString] AS c58,UserData.[tp_CheckoutUserId],UserData.[nvarchar9],t14.[nvarchar7] AS c29c21,t37.[nvarchar4] AS c51c5,UserData.[tp_Level],UserData.[nvarchar17],UserData.[int5],t12.[nvarchar7] AS c27c21,t13.[nvarchar7] AS c28c21,UserData.[ntext9],UserData.[nvarchar20],t10.[nvarchar7] AS c25c21,t11.[nvarchar7] AS c26c21,t20.[int14] AS c48,t2.[tp_ID] AS c2c4,UserData.[tp_Modified],UserData.[nvarchar8],t8.[nvarchar7] AS c23c21,t9.[nvarchar7] AS c24c21,t20.[int9] AS c43,UserData.[tp_UIVersion],t3.[tp_Created] AS c10c7,UserData.[nvarchar16],t7.[nvarchar7] AS c22c21,t1.[IsCheckoutToLocal] AS c12,t4.[nvarchar4] AS c17c5,UserData.[ntext8],t6.[nvarchar7] AS c20c21,UserData.[int4],t20.[int4] AS c38,UserData.[tp_UIVersionString],t1.[ParentLeafName] AS c59,UserData.[nvarchar7],UserData.[nvarchar29],t1.[LTCheckoutUserId] AS c54,UserData.[nvarchar15],UserData.[nvarchar32],t37.[nvarchar5] AS c51c6,UserData.[ntext7],UserData.[int3],t24.[nvarchar7] AS c38c21,t25.[nvarchar7] AS c39c21,t20.[int15] AS c49,t2.[nvarchar4] AS c2c5,t1.[Type] AS c8,UserData.[tp_ModerationStatus],UserData.[nvarchar6],UserData.[ntext14],UserData.[nvarchar28],t22.[nvarchar7] AS c36c21,t23.[nvarchar7] AS c37c21,t20.[int10] AS c44,UserData.[tp_Created],UserData.[tp_WorkflowInstanceID],UserData.[nvarchar14],t19.[nvarchar7] AS c34c21,t21.[nvarchar7] AS c35c21,UserData.[nvarchar31],t38.[nvarchar1] AS c3,t3.[nvarchar1] AS c10c3,t4.[nvarchar5] AS c17c6,UserData.[ntext6],UserData.[int2],t17.[nvarchar7] AS c32c21,t18.[nvarchar7] AS c33c21,t20.[int5] AS c39,UserData.[tp_ID],t1.[ProgId] AS c13,UserData.[nvarchar5],UserData.[ntext13],UserData.[nvarchar27],t16.[nvarchar7] AS c31c21,t1.[Size] AS c55,UserData.[tp_Editor],t15.[nvarchar7] AS c30c21,UserData.[int16],UserData.[nvarchar30],t20.[int16] AS c50,UserData.[tp_Author],t37.[tp_Created] AS c51c7,UserData.[int1],UserData.[nvarchar13],UserData.[ntext5],t2.[nvarchar5] AS c2c6,t1.[TimeLastModified] AS c9,UserData.[tp_ContentTypeId],t5.[nvarchar7] AS c18c19,UserData.[ntext12],UserData.[nvarchar26],t20.[int11] AS c45,t35.[nvarchar7] AS c49c21,UserData.[nvarchar4],UserData.[tp_Version],UserData.[int15],t20.[int6] AS c40,t33.[nvarchar7] AS c47c21,t34.[nvarchar7] AS c48c21,UserData.[tp_IsCurrentVersion],t3.[tp_ID] AS c10c4,UserData.[tp_HasCopyDestinations],UserData.[nvarchar12],UserData.[ntext4],UserData.[datetime3],t31.[nvarchar7] AS c45c21,t32.[nvarchar7] AS c46c21,t1.[MetaInfo] AS c14,t4.[tp_Created] AS c17c7,UserData.[ntext11],t20.[int1] AS c35,t29.[nvarchar7] AS c43c21,t30.[nvarchar7] AS c44c21,UserData.[nvarchar3],UserData.[nvarchar25],UserData.[int14],t28.[nvarchar7] AS c42c21,UserData.[tp_CopySource],UserData.[datetime2],UserData.[nvarchar11],UserData.[ntext3],t26.[nvarchar7] AS c40c21,t27.[nvarchar7] AS c41c21,t37.[nvarchar1] AS c51c3,UserData.[tp_InstanceID],UserData.[ntext10],UserData.[int9],t20.[int12] AS c46,t2.[tp_Created] AS c2c7,UserData.[nvarchar2],UserData.[tp_ContentType],UserData.[nvarchar24],UserData.[int13],t20.[int7] AS c41,UserData.[ntext2],UserData.[nvarchar10],UserData.[int8],UserData.[nvarchar23],t1.[DirName] AS c52 FROM UserData INNER MERGE  JOIN Docs AS t1 WITH(NOLOCK) ON ( 1 = 1  AND UserData.[tp_RowOrdinal] = 0 AND t1.SiteId = UserData.tp_SiteId AND t1.SiteId = @L2 AND t1.DirName = UserData.tp_DirName  AND t1.LeafName = UserData.tp_LeafName  AND t1.Level = UserData.tp_Level  AND  (UserData.tp_Level = 255 AND t1.LTCheckoutUserId =@IU OR (UserData.tp_Level = 1 AND (UserData.tp_DraftOwnerId IS NULL OR  (UserData.tp_DraftOwnerId <>@IU AND t1.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR UserData.tp_Level = 2 AND (UserData.tp_DraftOwnerId = @IU OR t1.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t1.LTCheckoutUserId IS NULL OR t1.LTCheckoutUserId <> @IU )) AND (1 = 1)) LEFT OUTER JOIN AllUserData AS t2 WITH(NOLOCK, INDEX=AllUserData_PK) ON (UserData.[tp_Editor]=t2.[tp_ID] AND UserData.[tp_RowOrdinal] = 0 AND t2.[tp_RowOrdinal] = 0 AND ( (t2.tp_IsCurrent = 1) )  AND t2.[tp_CalculatedVersion] = 0  AND t2.[tp_DeleteTransactionId] = 0x  AND t2.tp_ListId = @L3 AND UserData.tp_ListId = @L4) LEFT OUTER JOIN AllUserData AS t3 WITH(NOLOCK, INDEX=AllUserData_PK) ON (UserData.[tp_CheckoutUserId]=t3.[tp_ID] AND UserData.[tp_RowOrdinal] = 0 AND t3.[tp_RowOrdinal] = 0 AND ( (t3.tp_IsCurrent = 1) )  AND t3.[tp_CalculatedVersion] = 0  AND t3.[tp_DeleteTransactionId] = 0x  AND t3.tp_ListId = @L3 AND UserData.tp_ListId = @L4) LEFT OUTER JOIN AllUserData AS t4 WITH(NOLOCK, INDEX=AllUserData_PK) ON (UserData.[int1]=t4.[tp_ID] AND UserData.[tp_RowOrdinal] = 0 AND t4.[tp_RowOrdinal] = 0 AND ( (t4.tp_IsCurrent = 1) )  AND t4.[tp_CalculatedVersion] = 0  AND t4.[tp_DeleteTransactionId] = 0x  AND t4.tp_ListId = @L3 AND UserData.tp_ListId = @L4) LEFT OUTER JOIN AllUserData AS t5 WITH(NOLOCK, INDEX=AllUserData_PK) ON (UserData.[int2]=t5.[tp_ID] AND UserData.[tp_RowOrdinal] = 0 AND t5.[tp_RowOrdinal] = 0 AND ( (t5.tp_Level= 255 AND t5.tp_CheckoutUserId = @IU OR  ( t5.tp_Level  = 2 AND t5.tp_DraftOwnerId IS NOT NULL OR t5.tp_Level  = 1 AND t5.tp_DraftOwnerId IS  NULL  ) AND ( t5.tp_CheckoutUserId IS  NULL  OR t5.tp_CheckoutUserId <> @IU)) )  AND t5.[tp_CalculatedVersion] = 0  AND t5.[tp_DeleteTransactionId] = 0x  AND t5.tp_ListId = @L5 AND UserData.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t6_u WITH(NOLOCK)  INNER JOIN Docs AS t6_d WITH(NOLOCK) ON (t6_d.DoclibRowId = t6_u.tp_ID  AND t6_d.SiteId = t6_u.tp_SiteId AND t6_d.SiteId = @L2 AND t6_d.DirName = t6_u.tp_DirName  AND t6_d.LeafName = t6_u.tp_LeafName  AND t6_d.Level = t6_u.tp_Level  AND  (t6_u.tp_Level = 255 AND t6_d.LTCheckoutUserId =@IU OR (t6_u.tp_Level = 1 AND (t6_u.tp_DraftOwnerId IS NULL OR  (t6_u.tp_DraftOwnerId <>@IU AND t6_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t6_u.tp_Level = 2 AND (t6_u.tp_DraftOwnerId = @IU OR t6_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t6_d.LTCheckoutUserId IS NULL OR t6_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t6 ON (UserData.[int3]=t6.[tp_ID] AND UserData.[tp_RowOrdinal] = 0 AND t6.[tp_RowOrdinal] = 0 AND t6.tp_ListId = @L6 AND UserData.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t7_u WITH(NOLOCK)  INNER JOIN Docs AS t7_d WITH(NOLOCK) ON (t7_d.DoclibRowId = t7_u.tp_ID  AND t7_d.SiteId = t7_u.tp_SiteId AND t7_d.SiteId = @L2 AND t7_d.DirName = t7_u.tp_DirName  AND t7_d.LeafName = t7_u.tp_LeafName  AND t7_d.Level = t7_u.tp_Level  AND  (t7_u.tp_Level = 255 AND t7_d.LTCheckoutUserId =@IU OR (t7_u.tp_Level = 1 AND (t7_u.tp_DraftOwnerId IS NULL OR  (t7_u.tp_DraftOwnerId <>@IU AND t7_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t7_u.tp_Level = 2 AND (t7_u.tp_DraftOwnerId = @IU OR t7_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t7_d.LTCheckoutUserId IS NULL OR t7_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t7 ON (UserData.[int4]=t7.[tp_ID] AND UserData.[tp_RowOrdinal] = 0 AND t7.[tp_RowOrdinal] = 0 AND t7.tp_ListId = @L6 AND UserData.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t8_u WITH(NOLOCK)  INNER JOIN Docs AS t8_d WITH(NOLOCK) ON (t8_d.DoclibRowId = t8_u.tp_ID  AND t8_d.SiteId = t8_u.tp_SiteId AND t8_d.SiteId = @L2 AND t8_d.DirName = t8_u.tp_DirName  AND t8_d.LeafName = t8_u.tp_LeafName  AND t8_d.Level = t8_u.tp_Level  AND  (t8_u.tp_Level = 255 AND t8_d.LTCheckoutUserId =@IU OR (t8_u.tp_Level = 1 AND (t8_u.tp_DraftOwnerId IS NULL OR  (t8_u.tp_DraftOwnerId <>@IU AND t8_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t8_u.tp_Level = 2 AND (t8_u.tp_DraftOwnerId = @IU OR t8_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t8_d.LTCheckoutUserId IS NULL OR t8_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t8 ON (UserData.[int5]=t8.[tp_ID] AND UserData.[tp_RowOrdinal] = 0 AND t8.[tp_RowOrdinal] = 0 AND t8.tp_ListId = @L6 AND UserData.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t9_u WITH(NOLOCK)  INNER JOIN Docs AS t9_d WITH(NOLOCK) ON (t9_d.DoclibRowId = t9_u.tp_ID  AND t9_d.SiteId = t9_u.tp_SiteId AND t9_d.SiteId = @L2 AND t9_d.DirName = t9_u.tp_DirName  AND t9_d.LeafName = t9_u.tp_LeafName  AND t9_d.Level = t9_u.tp_Level  AND  (t9_u.tp_Level = 255 AND t9_d.LTCheckoutUserId =@IU OR (t9_u.tp_Level = 1 AND (t9_u.tp_DraftOwnerId IS NULL OR  (t9_u.tp_DraftOwnerId <>@IU AND t9_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t9_u.tp_Level = 2 AND (t9_u.tp_DraftOwnerId = @IU OR t9_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t9_d.LTCheckoutUserId IS NULL OR t9_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t9 ON (UserData.[int6]=t9.[tp_ID] AND UserData.[tp_RowOrdinal] = 0 AND t9.[tp_RowOrdinal] = 0 AND t9.tp_ListId = @L6 AND UserData.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t10_u WITH(NOLOCK)  INNER JOIN Docs AS t10_d WITH(NOLOCK) ON (t10_d.DoclibRowId = t10_u.tp_ID  AND t10_d.SiteId = t10_u.tp_SiteId AND t10_d.SiteId = @L2 AND t10_d.DirName = t10_u.tp_DirName  AND t10_d.LeafName = t10_u.tp_LeafName  AND t10_d.Level = t10_u.tp_Level  AND  (t10_u.tp_Level = 255 AND t10_d.LTCheckoutUserId =@IU OR (t10_u.tp_Level = 1 AND (t10_u.tp_DraftOwnerId IS NULL OR  (t10_u.tp_DraftOwnerId <>@IU AND t10_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t10_u.tp_Level = 2 AND (t10_u.tp_DraftOwnerId = @IU OR t10_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t10_d.LTCheckoutUserId IS NULL OR t10_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t10 ON (UserData.[int7]=t10.[tp_ID] AND UserData.[tp_RowOrdinal] = 0 AND t10.[tp_RowOrdinal] = 0 AND t10.tp_ListId = @L6 AND UserData.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t11_u WITH(NOLOCK)  INNER JOIN Docs AS t11_d WITH(NOLOCK) ON (t11_d.DoclibRowId = t11_u.tp_ID  AND t11_d.SiteId = t11_u.tp_SiteId AND t11_d.SiteId = @L2 AND t11_d.DirName = t11_u.tp_DirName  AND t11_d.LeafName = t11_u.tp_LeafName  AND t11_d.Level = t11_u.tp_Level  AND  (t11_u.tp_Level = 255 AND t11_d.LTCheckoutUserId =@IU OR (t11_u.tp_Level = 1 AND (t11_u.tp_DraftOwnerId IS NULL OR  (t11_u.tp_DraftOwnerId <>@IU AND t11_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t11_u.tp_Level = 2 AND (t11_u.tp_DraftOwnerId = @IU OR t11_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t11_d.LTCheckoutUserId IS NULL OR t11_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t11 ON (UserData.[int8]=t11.[tp_ID] AND UserData.[tp_RowOrdinal] = 0 AND t11.[tp_RowOrdinal] = 0 AND t11.tp_ListId = @L6 AND UserData.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t12_u WITH(NOLOCK)  INNER JOIN Docs AS t12_d WITH(NOLOCK) ON (t12_d.DoclibRowId = t12_u.tp_ID  AND t12_d.SiteId = t12_u.tp_SiteId AND t12_d.SiteId = @L2 AND t12_d.DirName = t12_u.tp_DirName  AND t12_d.LeafName = t12_u.tp_LeafName  AND t12_d.Level = t12_u.tp_Level  AND  (t12_u.tp_Level = 255 AND t12_d.LTCheckoutUserId =@IU OR (t12_u.tp_Level = 1 AND (t12_u.tp_DraftOwnerId IS NULL OR  (t12_u.tp_DraftOwnerId <>@IU AND t12_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t12_u.tp_Level = 2 AND (t12_u.tp_DraftOwnerId = @IU OR t12_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t12_d.LTCheckoutUserId IS NULL OR t12_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t12 ON (UserData.[int9]=t12.[tp_ID] AND UserData.[tp_RowOrdinal] = 0 AND t12.[tp_RowOrdinal] = 0 AND t12.tp_ListId = @L6 AND UserData.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t13_u WITH(NOLOCK)  INNER JOIN Docs AS t13_d WITH(NOLOCK) ON (t13_d.DoclibRowId = t13_u.tp_ID  AND t13_d.SiteId = t13_u.tp_SiteId AND t13_d.SiteId = @L2 AND t13_d.DirName = t13_u.tp_DirName  AND t13_d.LeafName = t13_u.tp_LeafName  AND t13_d.Level = t13_u.tp_Level  AND  (t13_u.tp_Level = 255 AND t13_d.LTCheckoutUserId =@IU OR (t13_u.tp_Level = 1 AND (t13_u.tp_DraftOwnerId IS NULL OR  (t13_u.tp_DraftOwnerId <>@IU AND t13_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t13_u.tp_Level = 2 AND (t13_u.tp_DraftOwnerId = @IU OR t13_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t13_d.LTCheckoutUserId IS NULL OR t13_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t13 ON (UserData.[int10]=t13.[tp_ID] AND UserData.[tp_RowOrdinal] = 0 AND t13.[tp_RowOrdinal] = 0 AND t13.tp_ListId = @L6 AND UserData.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t14_u WITH(NOLOCK)  INNER JOIN Docs AS t14_d WITH(NOLOCK) ON (t14_d.DoclibRowId = t14_u.tp_ID  AND t14_d.SiteId = t14_u.tp_SiteId AND t14_d.SiteId = @L2 AND t14_d.DirName = t14_u.tp_DirName  AND t14_d.LeafName = t14_u.tp_LeafName  AND t14_d.Level = t14_u.tp_Level  AND  (t14_u.tp_Level = 255 AND t14_d.LTCheckoutUserId =@IU OR (t14_u.tp_Level = 1 AND (t14_u.tp_DraftOwnerId IS NULL OR  (t14_u.tp_DraftOwnerId <>@IU AND t14_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t14_u.tp_Level = 2 AND (t14_u.tp_DraftOwnerId = @IU OR t14_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t14_d.LTCheckoutUserId IS NULL OR t14_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t14 ON (UserData.[int11]=t14.[tp_ID] AND UserData.[tp_RowOrdinal] = 0 AND t14.[tp_RowOrdinal] = 0 AND t14.tp_ListId = @L6 AND UserData.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t15_u WITH(NOLOCK)  INNER JOIN Docs AS t15_d WITH(NOLOCK) ON (t15_d.DoclibRowId = t15_u.tp_ID  AND t15_d.SiteId = t15_u.tp_SiteId AND t15_d.SiteId = @L2 AND t15_d.DirName = t15_u.tp_DirName  AND t15_d.LeafName = t15_u.tp_LeafName  AND t15_d.Level = t15_u.tp_Level  AND  (t15_u.tp_Level = 255 AND t15_d.LTCheckoutUserId =@IU OR (t15_u.tp_Level = 1 AND (t15_u.tp_DraftOwnerId IS NULL OR  (t15_u.tp_DraftOwnerId <>@IU AND t15_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t15_u.tp_Level = 2 AND (t15_u.tp_DraftOwnerId = @IU OR t15_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t15_d.LTCheckoutUserId IS NULL OR t15_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t15 ON (UserData.[int12]=t15.[tp_ID] AND UserData.[tp_RowOrdinal] = 0 AND t15.[tp_RowOrdinal] = 0 AND t15.tp_ListId = @L6 AND UserData.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t16_u WITH(NOLOCK)  INNER JOIN Docs AS t16_d WITH(NOLOCK) ON (t16_d.DoclibRowId = t16_u.tp_ID  AND t16_d.SiteId = t16_u.tp_SiteId AND t16_d.SiteId = @L2 AND t16_d.DirName = t16_u.tp_DirName  AND t16_d.LeafName = t16_u.tp_LeafName  AND t16_d.Level = t16_u.tp_Level  AND  (t16_u.tp_Level = 255 AND t16_d.LTCheckoutUserId =@IU OR (t16_u.tp_Level = 1 AND (t16_u.tp_DraftOwnerId IS NULL OR  (t16_u.tp_DraftOwnerId <>@IU AND t16_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t16_u.tp_Level = 2 AND (t16_u.tp_DraftOwnerId = @IU OR t16_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t16_d.LTCheckoutUserId IS NULL OR t16_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t16 ON (UserData.[int13]=t16.[tp_ID] AND UserData.[tp_RowOrdinal] = 0 AND t16.[tp_RowOrdinal] = 0 AND t16.tp_ListId = @L6 AND UserData.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t17_u WITH(NOLOCK)  INNER JOIN Docs AS t17_d WITH(NOLOCK) ON (t17_d.DoclibRowId = t17_u.tp_ID  AND t17_d.SiteId = t17_u.tp_SiteId AND t17_d.SiteId = @L2 AND t17_d.DirName = t17_u.tp_DirName  AND t17_d.LeafName = t17_u.tp_LeafName  AND t17_d.Level = t17_u.tp_Level  AND  (t17_u.tp_Level = 255 AND t17_d.LTCheckoutUserId =@IU OR (t17_u.tp_Level = 1 AND (t17_u.tp_DraftOwnerId IS NULL OR  (t17_u.tp_DraftOwnerId <>@IU AND t17_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t17_u.tp_Level = 2 AND (t17_u.tp_DraftOwnerId = @IU OR t17_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t17_d.LTCheckoutUserId IS NULL OR t17_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t17 ON (UserData.[int14]=t17.[tp_ID] AND UserData.[tp_RowOrdinal] = 0 AND t17.[tp_RowOrdinal] = 0 AND t17.tp_ListId = @L6 AND UserData.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t18_u WITH(NOLOCK)  INNER JOIN Docs AS t18_d WITH(NOLOCK) ON (t18_d.DoclibRowId = t18_u.tp_ID  AND t18_d.SiteId = t18_u.tp_SiteId AND t18_d.SiteId = @L2 AND t18_d.DirName = t18_u.tp_DirName  AND t18_d.LeafName = t18_u.tp_LeafName  AND t18_d.Level = t18_u.tp_Level  AND  (t18_u.tp_Level = 255 AND t18_d.LTCheckoutUserId =@IU OR (t18_u.tp_Level = 1 AND (t18_u.tp_DraftOwnerId IS NULL OR  (t18_u.tp_DraftOwnerId <>@IU AND t18_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t18_u.tp_Level = 2 AND (t18_u.tp_DraftOwnerId = @IU OR t18_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t18_d.LTCheckoutUserId IS NULL OR t18_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t18 ON (UserData.[int15]=t18.[tp_ID] AND UserData.[tp_RowOrdinal] = 0 AND t18.[tp_RowOrdinal] = 0 AND t18.tp_ListId = @L6 AND UserData.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t19_u WITH(NOLOCK)  INNER JOIN Docs AS t19_d WITH(NOLOCK) ON (t19_d.DoclibRowId = t19_u.tp_ID  AND t19_d.SiteId = t19_u.tp_SiteId AND t19_d.SiteId = @L2 AND t19_d.DirName = t19_u.tp_DirName  AND t19_d.LeafName = t19_u.tp_LeafName  AND t19_d.Level = t19_u.tp_Level  AND  (t19_u.tp_Level = 255 AND t19_d.LTCheckoutUserId =@IU OR (t19_u.tp_Level = 1 AND (t19_u.tp_DraftOwnerId IS NULL OR  (t19_u.tp_DraftOwnerId <>@IU AND t19_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t19_u.tp_Level = 2 AND (t19_u.tp_DraftOwnerId = @IU OR t19_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t19_d.LTCheckoutUserId IS NULL OR t19_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t19 ON (UserData.[int16]=t19.[tp_ID] AND UserData.[tp_RowOrdinal] = 0 AND t19.[tp_RowOrdinal] = 0 AND t19.tp_ListId = @L6 AND UserData.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t20_u WITH(NOLOCK)  INNER JOIN Docs AS t20_d WITH(NOLOCK) ON (t20_d.DoclibRowId = t20_u.tp_ID  AND t20_d.SiteId = t20_u.tp_SiteId AND t20_d.SiteId = @L2 AND t20_d.DirName = t20_u.tp_DirName  AND t20_d.LeafName = t20_u.tp_LeafName  AND t20_d.Level = t20_u.tp_Level  AND  (t20_u.tp_Level = 255 AND t20_d.LTCheckoutUserId =@IU OR (t20_u.tp_Level = 1 AND (t20_u.tp_DraftOwnerId IS NULL OR  (t20_u.tp_DraftOwnerId <>@IU AND t20_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t20_u.tp_Level = 2 AND (t20_u.tp_DraftOwnerId = @IU OR t20_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t20_d.LTCheckoutUserId IS NULL OR t20_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t20 ON (UserData.[tp_ID]=t20.[tp_ID] AND UserData.[tp_RowOrdinal] = 0 AND t20.[tp_RowOrdinal] = 1 AND t20.tp_ListId = @L4 AND UserData.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t21_u WITH(NOLOCK)  INNER JOIN Docs AS t21_d WITH(NOLOCK) ON (t21_d.DoclibRowId = t21_u.tp_ID  AND t21_d.SiteId = t21_u.tp_SiteId AND t21_d.SiteId = @L2 AND t21_d.DirName = t21_u.tp_DirName  AND t21_d.LeafName = t21_u.tp_LeafName  AND t21_d.Level = t21_u.tp_Level  AND  (t21_u.tp_Level = 255 AND t21_d.LTCheckoutUserId =@IU OR (t21_u.tp_Level = 1 AND (t21_u.tp_DraftOwnerId IS NULL OR  (t21_u.tp_DraftOwnerId <>@IU AND t21_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t21_u.tp_Level = 2 AND (t21_u.tp_DraftOwnerId = @IU OR t21_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t21_d.LTCheckoutUserId IS NULL OR t21_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t21 ON (t20.[int1]=t21.[tp_ID] AND t20.[tp_RowOrdinal] = 1 AND t21.[tp_RowOrdinal] = 0 AND t21.tp_ListId = @L6 AND t20.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t22_u WITH(NOLOCK)  INNER JOIN Docs AS t22_d WITH(NOLOCK) ON (t22_d.DoclibRowId = t22_u.tp_ID  AND t22_d.SiteId = t22_u.tp_SiteId AND t22_d.SiteId = @L2 AND t22_d.DirName = t22_u.tp_DirName  AND t22_d.LeafName = t22_u.tp_LeafName  AND t22_d.Level = t22_u.tp_Level  AND  (t22_u.tp_Level = 255 AND t22_d.LTCheckoutUserId =@IU OR (t22_u.tp_Level = 1 AND (t22_u.tp_DraftOwnerId IS NULL OR  (t22_u.tp_DraftOwnerId <>@IU AND t22_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t22_u.tp_Level = 2 AND (t22_u.tp_DraftOwnerId = @IU OR t22_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t22_d.LTCheckoutUserId IS NULL OR t22_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t22 ON (t20.[int2]=t22.[tp_ID] AND t20.[tp_RowOrdinal] = 1 AND t22.[tp_RowOrdinal] = 0 AND t22.tp_ListId = @L6 AND t20.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t23_u WITH(NOLOCK)  INNER JOIN Docs AS t23_d WITH(NOLOCK) ON (t23_d.DoclibRowId = t23_u.tp_ID  AND t23_d.SiteId = t23_u.tp_SiteId AND t23_d.SiteId = @L2 AND t23_d.DirName = t23_u.tp_DirName  AND t23_d.LeafName = t23_u.tp_LeafName  AND t23_d.Level = t23_u.tp_Level  AND  (t23_u.tp_Level = 255 AND t23_d.LTCheckoutUserId =@IU OR (t23_u.tp_Level = 1 AND (t23_u.tp_DraftOwnerId IS NULL OR  (t23_u.tp_DraftOwnerId <>@IU AND t23_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t23_u.tp_Level = 2 AND (t23_u.tp_DraftOwnerId = @IU OR t23_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t23_d.LTCheckoutUserId IS NULL OR t23_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t23 ON (t20.[int3]=t23.[tp_ID] AND t20.[tp_RowOrdinal] = 1 AND t23.[tp_RowOrdinal] = 0 AND t23.tp_ListId = @L6 AND t20.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t24_u WITH(NOLOCK)  INNER JOIN Docs AS t24_d WITH(NOLOCK) ON (t24_d.DoclibRowId = t24_u.tp_ID  AND t24_d.SiteId = t24_u.tp_SiteId AND t24_d.SiteId = @L2 AND t24_d.DirName = t24_u.tp_DirName  AND t24_d.LeafName = t24_u.tp_LeafName  AND t24_d.Level = t24_u.tp_Level  AND  (t24_u.tp_Level = 255 AND t24_d.LTCheckoutUserId =@IU OR (t24_u.tp_Level = 1 AND (t24_u.tp_DraftOwnerId IS NULL OR  (t24_u.tp_DraftOwnerId <>@IU AND t24_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t24_u.tp_Level = 2 AND (t24_u.tp_DraftOwnerId = @IU OR t24_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t24_d.LTCheckoutUserId IS NULL OR t24_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t24 ON (t20.[int4]=t24.[tp_ID] AND t20.[tp_RowOrdinal] = 1 AND t24.[tp_RowOrdinal] = 0 AND t24.tp_ListId = @L6 AND t20.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t25_u WITH(NOLOCK)  INNER JOIN Docs AS t25_d WITH(NOLOCK) ON (t25_d.DoclibRowId = t25_u.tp_ID  AND t25_d.SiteId = t25_u.tp_SiteId AND t25_d.SiteId = @L2 AND t25_d.DirName = t25_u.tp_DirName  AND t25_d.LeafName = t25_u.tp_LeafName  AND t25_d.Level = t25_u.tp_Level  AND  (t25_u.tp_Level = 255 AND t25_d.LTCheckoutUserId =@IU OR (t25_u.tp_Level = 1 AND (t25_u.tp_DraftOwnerId IS NULL OR  (t25_u.tp_DraftOwnerId <>@IU AND t25_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t25_u.tp_Level = 2 AND (t25_u.tp_DraftOwnerId = @IU OR t25_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t25_d.LTCheckoutUserId IS NULL OR t25_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t25 ON (t20.[int5]=t25.[tp_ID] AND t20.[tp_RowOrdinal] = 1 AND t25.[tp_RowOrdinal] = 0 AND t25.tp_ListId = @L6 AND t20.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t26_u WITH(NOLOCK)  INNER JOIN Docs AS t26_d WITH(NOLOCK) ON (t26_d.DoclibRowId = t26_u.tp_ID  AND t26_d.SiteId = t26_u.tp_SiteId AND t26_d.SiteId = @L2 AND t26_d.DirName = t26_u.tp_DirName  AND t26_d.LeafName = t26_u.tp_LeafName  AND t26_d.Level = t26_u.tp_Level  AND  (t26_u.tp_Level = 255 AND t26_d.LTCheckoutUserId =@IU OR (t26_u.tp_Level = 1 AND (t26_u.tp_DraftOwnerId IS NULL OR  (t26_u.tp_DraftOwnerId <>@IU AND t26_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t26_u.tp_Level = 2 AND (t26_u.tp_DraftOwnerId = @IU OR t26_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t26_d.LTCheckoutUserId IS NULL OR t26_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t26 ON (t20.[int6]=t26.[tp_ID] AND t20.[tp_RowOrdinal] = 1 AND t26.[tp_RowOrdinal] = 0 AND t26.tp_ListId = @L6 AND t20.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t27_u WITH(NOLOCK)  INNER JOIN Docs AS t27_d WITH(NOLOCK) ON (t27_d.DoclibRowId = t27_u.tp_ID  AND t27_d.SiteId = t27_u.tp_SiteId AND t27_d.SiteId = @L2 AND t27_d.DirName = t27_u.tp_DirName  AND t27_d.LeafName = t27_u.tp_LeafName  AND t27_d.Level = t27_u.tp_Level  AND  (t27_u.tp_Level = 255 AND t27_d.LTCheckoutUserId =@IU OR (t27_u.tp_Level = 1 AND (t27_u.tp_DraftOwnerId IS NULL OR  (t27_u.tp_DraftOwnerId <>@IU AND t27_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t27_u.tp_Level = 2 AND (t27_u.tp_DraftOwnerId = @IU OR t27_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t27_d.LTCheckoutUserId IS NULL OR t27_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t27 ON (t20.[int7]=t27.[tp_ID] AND t20.[tp_RowOrdinal] = 1 AND t27.[tp_RowOrdinal] = 0 AND t27.tp_ListId = @L6 AND t20.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t28_u WITH(NOLOCK)  INNER JOIN Docs AS t28_d WITH(NOLOCK) ON (t28_d.DoclibRowId = t28_u.tp_ID  AND t28_d.SiteId = t28_u.tp_SiteId AND t28_d.SiteId = @L2 AND t28_d.DirName = t28_u.tp_DirName  AND t28_d.LeafName = t28_u.tp_LeafName  AND t28_d.Level = t28_u.tp_Level  AND  (t28_u.tp_Level = 255 AND t28_d.LTCheckoutUserId =@IU OR (t28_u.tp_Level = 1 AND (t28_u.tp_DraftOwnerId IS NULL OR  (t28_u.tp_DraftOwnerId <>@IU AND t28_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t28_u.tp_Level = 2 AND (t28_u.tp_DraftOwnerId = @IU OR t28_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t28_d.LTCheckoutUserId IS NULL OR t28_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t28 ON (t20.[int8]=t28.[tp_ID] AND t20.[tp_RowOrdinal] = 1 AND t28.[tp_RowOrdinal] = 0 AND t28.tp_ListId = @L6 AND t20.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t29_u WITH(NOLOCK)  INNER JOIN Docs AS t29_d WITH(NOLOCK) ON (t29_d.DoclibRowId = t29_u.tp_ID  AND t29_d.SiteId = t29_u.tp_SiteId AND t29_d.SiteId = @L2 AND t29_d.DirName = t29_u.tp_DirName  AND t29_d.LeafName = t29_u.tp_LeafName  AND t29_d.Level = t29_u.tp_Level  AND  (t29_u.tp_Level = 255 AND t29_d.LTCheckoutUserId =@IU OR (t29_u.tp_Level = 1 AND (t29_u.tp_DraftOwnerId IS NULL OR  (t29_u.tp_DraftOwnerId <>@IU AND t29_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t29_u.tp_Level = 2 AND (t29_u.tp_DraftOwnerId = @IU OR t29_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t29_d.LTCheckoutUserId IS NULL OR t29_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t29 ON (t20.[int9]=t29.[tp_ID] AND t20.[tp_RowOrdinal] = 1 AND t29.[tp_RowOrdinal] = 0 AND t29.tp_ListId = @L6 AND t20.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t30_u WITH(NOLOCK)  INNER JOIN Docs AS t30_d WITH(NOLOCK) ON (t30_d.DoclibRowId = t30_u.tp_ID  AND t30_d.SiteId = t30_u.tp_SiteId AND t30_d.SiteId = @L2 AND t30_d.DirName = t30_u.tp_DirName  AND t30_d.LeafName = t30_u.tp_LeafName  AND t30_d.Level = t30_u.tp_Level  AND  (t30_u.tp_Level = 255 AND t30_d.LTCheckoutUserId =@IU OR (t30_u.tp_Level = 1 AND (t30_u.tp_DraftOwnerId IS NULL OR  (t30_u.tp_DraftOwnerId <>@IU AND t30_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t30_u.tp_Level = 2 AND (t30_u.tp_DraftOwnerId = @IU OR t30_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t30_d.LTCheckoutUserId IS NULL OR t30_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t30 ON (t20.[int10]=t30.[tp_ID] AND t20.[tp_RowOrdinal] = 1 AND t30.[tp_RowOrdinal] = 0 AND t30.tp_ListId = @L6 AND t20.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t31_u WITH(NOLOCK)  INNER JOIN Docs AS t31_d WITH(NOLOCK) ON (t31_d.DoclibRowId = t31_u.tp_ID  AND t31_d.SiteId = t31_u.tp_SiteId AND t31_d.SiteId = @L2 AND t31_d.DirName = t31_u.tp_DirName  AND t31_d.LeafName = t31_u.tp_LeafName  AND t31_d.Level = t31_u.tp_Level  AND  (t31_u.tp_Level = 255 AND t31_d.LTCheckoutUserId =@IU OR (t31_u.tp_Level = 1 AND (t31_u.tp_DraftOwnerId IS NULL OR  (t31_u.tp_DraftOwnerId <>@IU AND t31_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t31_u.tp_Level = 2 AND (t31_u.tp_DraftOwnerId = @IU OR t31_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t31_d.LTCheckoutUserId IS NULL OR t31_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t31 ON (t20.[int11]=t31.[tp_ID] AND t20.[tp_RowOrdinal] = 1 AND t31.[tp_RowOrdinal] = 0 AND t31.tp_ListId = @L6 AND t20.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t32_u WITH(NOLOCK)  INNER JOIN Docs AS t32_d WITH(NOLOCK) ON (t32_d.DoclibRowId = t32_u.tp_ID  AND t32_d.SiteId = t32_u.tp_SiteId AND t32_d.SiteId = @L2 AND t32_d.DirName = t32_u.tp_DirName  AND t32_d.LeafName = t32_u.tp_LeafName  AND t32_d.Level = t32_u.tp_Level  AND  (t32_u.tp_Level = 255 AND t32_d.LTCheckoutUserId =@IU OR (t32_u.tp_Level = 1 AND (t32_u.tp_DraftOwnerId IS NULL OR  (t32_u.tp_DraftOwnerId <>@IU AND t32_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t32_u.tp_Level = 2 AND (t32_u.tp_DraftOwnerId = @IU OR t32_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t32_d.LTCheckoutUserId IS NULL OR t32_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t32 ON (t20.[int12]=t32.[tp_ID] AND t20.[tp_RowOrdinal] = 1 AND t32.[tp_RowOrdinal] = 0 AND t32.tp_ListId = @L6 AND t20.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t33_u WITH(NOLOCK)  INNER JOIN Docs AS t33_d WITH(NOLOCK) ON (t33_d.DoclibRowId = t33_u.tp_ID  AND t33_d.SiteId = t33_u.tp_SiteId AND t33_d.SiteId = @L2 AND t33_d.DirName = t33_u.tp_DirName  AND t33_d.LeafName = t33_u.tp_LeafName  AND t33_d.Level = t33_u.tp_Level  AND  (t33_u.tp_Level = 255 AND t33_d.LTCheckoutUserId =@IU OR (t33_u.tp_Level = 1 AND (t33_u.tp_DraftOwnerId IS NULL OR  (t33_u.tp_DraftOwnerId <>@IU AND t33_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t33_u.tp_Level = 2 AND (t33_u.tp_DraftOwnerId = @IU OR t33_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t33_d.LTCheckoutUserId IS NULL OR t33_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t33 ON (t20.[int13]=t33.[tp_ID] AND t20.[tp_RowOrdinal] = 1 AND t33.[tp_RowOrdinal] = 0 AND t33.tp_ListId = @L6 AND t20.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t34_u WITH(NOLOCK)  INNER JOIN Docs AS t34_d WITH(NOLOCK) ON (t34_d.DoclibRowId = t34_u.tp_ID  AND t34_d.SiteId = t34_u.tp_SiteId AND t34_d.SiteId = @L2 AND t34_d.DirName = t34_u.tp_DirName  AND t34_d.LeafName = t34_u.tp_LeafName  AND t34_d.Level = t34_u.tp_Level  AND  (t34_u.tp_Level = 255 AND t34_d.LTCheckoutUserId =@IU OR (t34_u.tp_Level = 1 AND (t34_u.tp_DraftOwnerId IS NULL OR  (t34_u.tp_DraftOwnerId <>@IU AND t34_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t34_u.tp_Level = 2 AND (t34_u.tp_DraftOwnerId = @IU OR t34_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t34_d.LTCheckoutUserId IS NULL OR t34_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t34 ON (t20.[int14]=t34.[tp_ID] AND t20.[tp_RowOrdinal] = 1 AND t34.[tp_RowOrdinal] = 0 AND t34.tp_ListId = @L6 AND t20.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t35_u WITH(NOLOCK)  INNER JOIN Docs AS t35_d WITH(NOLOCK) ON (t35_d.DoclibRowId = t35_u.tp_ID  AND t35_d.SiteId = t35_u.tp_SiteId AND t35_d.SiteId = @L2 AND t35_d.DirName = t35_u.tp_DirName  AND t35_d.LeafName = t35_u.tp_LeafName  AND t35_d.Level = t35_u.tp_Level  AND  (t35_u.tp_Level = 255 AND t35_d.LTCheckoutUserId =@IU OR (t35_u.tp_Level = 1 AND (t35_u.tp_DraftOwnerId IS NULL OR  (t35_u.tp_DraftOwnerId <>@IU AND t35_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t35_u.tp_Level = 2 AND (t35_u.tp_DraftOwnerId = @IU OR t35_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t35_d.LTCheckoutUserId IS NULL OR t35_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t35 ON (t20.[int15]=t35.[tp_ID] AND t20.[tp_RowOrdinal] = 1 AND t35.[tp_RowOrdinal] = 0 AND t35.tp_ListId = @L6 AND t20.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t36_u WITH(NOLOCK)  INNER JOIN Docs AS t36_d WITH(NOLOCK) ON (t36_d.DoclibRowId = t36_u.tp_ID  AND t36_d.SiteId = t36_u.tp_SiteId AND t36_d.SiteId = @L2 AND t36_d.DirName = t36_u.tp_DirName  AND t36_d.LeafName = t36_u.tp_LeafName  AND t36_d.Level = t36_u.tp_Level  AND  (t36_u.tp_Level = 255 AND t36_d.LTCheckoutUserId =@IU OR (t36_u.tp_Level = 1 AND (t36_u.tp_DraftOwnerId IS NULL OR  (t36_u.tp_DraftOwnerId <>@IU AND t36_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t36_u.tp_Level = 2 AND (t36_u.tp_DraftOwnerId = @IU OR t36_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t36_d.LTCheckoutUserId IS NULL OR t36_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t36 ON (t20.[int16]=t36.[tp_ID] AND t20.[tp_RowOrdinal] = 1 AND t36.[tp_RowOrdinal] = 0 AND t36.tp_ListId = @L6 AND t20.tp_ListId = @L4) LEFT OUTER JOIN AllUserData AS t37 WITH(NOLOCK, INDEX=AllUserData_PK) ON (UserData.[tp_Author]=t37.[tp_ID] AND UserData.[tp_RowOrdinal] = 0 AND t37.[tp_RowOrdinal] = 0 AND ( (t37.tp_IsCurrent = 1) )  AND t37.[tp_CalculatedVersion] = 0  AND t37.[tp_DeleteTransactionId] = 0x  AND t37.tp_ListId = @L3 AND UserData.tp_ListId = @L4) LEFT OUTER JOIN AllUserData AS t38 WITH(NOLOCK, INDEX=AllUserData_PK) ON (t1.[LTCheckoutUserId]=t38.[tp_ID] AND t38.[tp_RowOrdinal] = 0 AND ( (t38.tp_IsCurrent = 1) )  AND t38.[tp_CalculatedVersion] = 0  AND t38.[tp_DeleteTransactionId] = 0x  AND t38.tp_ListId = @L3) WHERE  (UserData.tp_Level= 255 AND UserData.tp_CheckoutUserId = @IU OR  ( UserData.tp_Level  <> 255 AND (UserData.tp_CheckoutUserId IS  NULL  OR UserData.tp_CheckoutUserId <> @IU))) AND UserData.tp_SiteId=@L2 AND (UserData.tp_DirName=@DN OR UserData.tp_DirName LIKE @DNEL+N'/%') AND UserData.tp_RowOrdinal=0 AND (((t1.DirName=@L7DNP AND t1.LeafName=@L8DNP)) AND t1.SiteId=@L2 AND (t1.DirName=@DN OR t1.DirName LIKE @DNEL+N'/%')) ORDER BY UserData.[tp_ID] Asc OPTION (FORCE ORDER) '     CommandType: Text CommandTimeout: 0     Parameter: '@L0' Type: UniqueIdentifier Size: 0 Direction: Input Value: '00000000-0000-0000-0000-000000000000'     Parameter: '@L2' Type: UniqueIdentifier Size: 0 Direction: Input Value: 'a2d3bc48-f9b1-4a7b-a8f4-d5fbf683c633'     Parameter: '@IU' Type: Int Size: 0 Direction: Input Value: '1073741823'     Parameter: '@L3' Type: UniqueIdentifier Size: 0 Direction: Input Value: '9b8768c9-a82b-4a06-a843-246afd6231f0'     Parameter: '@L4' Type: UniqueIdentifier Size: 0 Direction: Input Value: '735aa0a3-e7dc-4caa-85ba-57285bd06f07'     Parameter: '@L5' Type: UniqueIdentifier Size: 0 Direction: Input Value: '646bb40d-60b2-485c-aa68-3a1bf84a855c'     Parameter: '@L6' Type: UniqueIdentifier Size: 0 Direction: Input Value: '877ecf41-5d7d-4157-8e03-bd96bc63bf92'     Parameter: '@L7DNP' Type: NVarChar Size: 260 Direction: Input Value: 'Sider'     Parameter: '@L8DNP' Type: NVarChar Size: 260 Direction: Input Value: 'testigenigen.aspx'     Parameter: '@DN' Type: NVarChar Size: 260 Direction: Input Value: 'Sider'     Parameter: 'DNEL' Type: NVarChar Size: 1024 Direction: Input Value: 'Sider'

10-26-2011 13:24:43.69 - w2wp.exe - Windows SharePoint Services - Database - 8sli - Monitorable:

List item query elapsed time: 538955 milliseconds, Additional data (if available): Query HRESULT: 80131530 List internal name, flags, and URL: {735AA0A3-E7DC-4CAA-85BA-57285BD06F07}, flags=0x000000022cdc108c, URL="http://www.letpension.dk/_layouts/CreatePage.aspx?List={735AA0A3-E7DC-4CAA-85BA-57285BD06F07}&RootFolder=/Sider&ContentTypeId=0x010100C568DB52D9D0A14D9B2FDCC96666E9F2007948130EC3DB064584E219954237AF390055466FF47432DD49A7C989013249DED7&Source=/Sider/Forms/AllItems.aspx" Query XML: "<Query><Where><Eq><FieldRef Name="FileRef"/><Value Type="Text">Sider/testigenigen.aspx</Value></Eq></Where></Query>" SQL Query: " SELECT TOP 2147483648 t1.[TimeCreated] AS c0,t3.[nvarchar4] AS c10c5,UserData.[datetime1],t1.[Id] AS c15,t4.[nvarchar1] AS c17c3,UserData.[tp_ItemOrder],UserData.[nvarchar1],UserData.[int12],t20.[int2] AS c36,t1.[CheckinComment] AS c57,UserData.[ntext1],t37.[tp_ID] AS c51c4,UserData.[nvarchar19],UserData.[int7],t2.[nvarchar1] AS c2c3,UserData.[bit1],UserData.[nvarchar22],UserData.[int11],t20.[int8] AS c42,t20.[int13] AS c47,t36.[nvarchar7] AS c50c21,UserData.[tp_GUID],t1.[LeafName] AS c1,t3.[nvarchar5] AS c10c6,UserData.[nvarchar18],UserData.[int6],CASE WHEN DATALENGTH(t1.DirName) = 0 THEN t1.LeafName WHEN DATALENGTH(t1.LeafName) = 0 THEN t1.DirName ELSE t1.DirName + N'/' + t1.LeafName END  AS c11,t1.[ScopeId] AS c16,t4.[tp_ID] AS c17c4,UserData.[nvarchar21],UserData.[int10],t20.[int3] AS c37,t1.[Size] AS c53,UserData.[tp_WorkflowVersion],t1.[ParentVersionString] AS c58,UserData.[tp_CheckoutUserId],UserData.[nvarchar9],t14.[nvarchar7] AS c29c21,t37.[nvarchar4] AS c51c5,UserData.[tp_Level],UserData.[nvarchar17],UserData.[int5],t12.[nvarchar7] AS c27c21,t13.[nvarchar7] AS c28c21,UserData.[ntext9],UserData.[nvarchar20],t10.[nvarchar7] AS c25c21,t11.[nvarchar7] AS c26c21,t20.[int14] AS c48,t2.[tp_ID] AS c2c4,UserData.[tp_Modified],UserData.[nvarchar8],t8.[nvarchar7] AS c23c21,t9.[nvarchar7] AS c24c21,t20.[int9] AS c43,UserData.[tp_UIVersion],t3.[tp_Created] AS c10c7,UserData.[nvarchar16],t7.[nvarchar7] AS c22c21,t1.[IsCheckoutToLocal] AS c12,t4.[nvarchar4] AS c17c5,UserData.[ntext8],t6.[nvarchar7] AS c20c21,UserData.[int4],t20.[int4] AS c38,UserData.[tp_UIVersionString],t1.[ParentLeafName] AS c59,UserData.[nvarchar7],UserData.[nvarchar29],t1.[LTCheckoutUserId] AS c54,UserData.[nvarchar15],UserData.[nvarchar32],t37.[nvarchar5] AS c51c6,UserData.[ntext7],UserData.[int3],t24.[nvarchar7] AS c38c21,t25.[nvarchar7] AS c39c21,t20.[int15] AS c49,t2.[nvarchar4] AS c2c5,t1.[Type] AS c8,UserData.[tp_ModerationStatus],UserData.[nvarchar6],UserData.[ntext14],UserData.[nvarchar28],t22.[nvarchar7] AS c36c21,t23.[nvarchar7] AS c37c21,t20.[int10] AS c44,UserData.[tp_Created],UserData.[tp_WorkflowInstanceID],UserData.[nvarchar14],t19.[nvarchar7] AS c34c21,t21.[nvarchar7] AS c35c21,UserData.[nvarchar31],t38.[nvarchar1] AS c3,t3.[nvarchar1] AS c10c3,t4.[nvarchar5] AS c17c6,UserData.[ntext6],UserData.[int2],t17.[nvarchar7] AS c32c21,t18.[nvarchar7] AS c33c21,t20.[int5] AS c39,UserData.[tp_ID],t1.[ProgId] AS c13,UserData.[nvarchar5],UserData.[ntext13],UserData.[nvarchar27],t16.[nvarchar7] AS c31c21,t1.[Size] AS c55,UserData.[tp_Editor],t15.[nvarchar7] AS c30c21,UserData.[int16],UserData.[nvarchar30],t20.[int16] AS c50,UserData.[tp_Author],t37.[tp_Created] AS c51c7,UserData.[int1],UserData.[nvarchar13],UserData.[ntext5],t2.[nvarchar5] AS c2c6,t1.[TimeLastModified] AS c9,UserData.[tp_ContentTypeId],t5.[nvarchar7] AS c18c19,UserData.[ntext12],UserData.[nvarchar26],t20.[int11] AS c45,t35.[nvarchar7] AS c49c21,UserData.[nvarchar4],UserData.[tp_Version],UserData.[int15],t20.[int6] AS c40,t33.[nvarchar7] AS c47c21,t34.[nvarchar7] AS c48c21,UserData.[tp_IsCurrentVersion],t3.[tp_ID] AS c10c4,UserData.[tp_HasCopyDestinations],UserData.[nvarchar12],UserData.[ntext4],UserData.[datetime3],t31.[nvarchar7] AS c45c21,t32.[nvarchar7] AS c46c21,t1.[MetaInfo] AS c14,t4.[tp_Created] AS c17c7,UserData.[ntext11],t20.[int1] AS c35,t29.[nvarchar7] AS c43c21,t30.[nvarchar7] AS c44c21,UserData.[nvarchar3],UserData.[nvarchar25],UserData.[int14],t28.[nvarchar7] AS c42c21,UserData.[tp_CopySource],UserData.[datetime2],UserData.[nvarchar11],UserData.[ntext3],t26.[nvarchar7] AS c40c21,t27.[nvarchar7] AS c41c21,t37.[nvarchar1] AS c51c3,UserData.[tp_InstanceID],UserData.[ntext10],UserData.[int9],t20.[int12] AS c46,t2.[tp_Created] AS c2c7,UserData.[nvarchar2],UserData.[tp_ContentType],UserData.[nvarchar24],UserData.[int13],t20.[int7] AS c41,UserData.[ntext2],UserData.[nvarchar10],UserData.[int8],UserData.[nvarchar23],t1.[DirName] AS c52 FROM UserData INNER MERGE  JOIN Docs AS t1 WITH(NOLOCK) ON ( 1 = 1  AND UserData.[tp_RowOrdinal] = 0 AND t1.SiteId = UserData.tp_SiteId AND t1.SiteId = @L2 AND t1.DirName = UserData.tp_DirName  AND t1.LeafName = UserData.tp_LeafName  AND t1.Level = UserData.tp_Level  AND  (UserData.tp_Level = 255 AND t1.LTCheckoutUserId =@IU OR (UserData.tp_Level = 1 AND (UserData.tp_DraftOwnerId IS NULL OR  (UserData.tp_DraftOwnerId <>@IU AND t1.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR UserData.tp_Level = 2 AND (UserData.tp_DraftOwnerId = @IU OR t1.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t1.LTCheckoutUserId IS NULL OR t1.LTCheckoutUserId <> @IU )) AND (1 = 1)) LEFT OUTER JOIN AllUserData AS t2 WITH(NOLOCK, INDEX=AllUserData_PK) ON (UserData.[tp_Editor]=t2.[tp_ID] AND UserData.[tp_RowOrdinal] = 0 AND t2.[tp_RowOrdinal] = 0 AND ( (t2.tp_IsCurrent = 1) )  AND t2.[tp_CalculatedVersion] = 0  AND t2.[tp_DeleteTransactionId] = 0x  AND t2.tp_ListId = @L3 AND UserData.tp_ListId = @L4) LEFT OUTER JOIN AllUserData AS t3 WITH(NOLOCK, INDEX=AllUserData_PK) ON (UserData.[tp_CheckoutUserId]=t3.[tp_ID] AND UserData.[tp_RowOrdinal] = 0 AND t3.[tp_RowOrdinal] = 0 AND ( (t3.tp_IsCurrent = 1) )  AND t3.[tp_CalculatedVersion] = 0  AND t3.[tp_DeleteTransactionId] = 0x  AND t3.tp_ListId = @L3 AND UserData.tp_ListId = @L4) LEFT OUTER JOIN AllUserData AS t4 WITH(NOLOCK, INDEX=AllUserData_PK) ON (UserData.[int1]=t4.[tp_ID] AND UserData.[tp_RowOrdinal] = 0 AND t4.[tp_RowOrdinal] = 0 AND ( (t4.tp_IsCurrent = 1) )  AND t4.[tp_CalculatedVersion] = 0  AND t4.[tp_DeleteTransactionId] = 0x  AND t4.tp_ListId = @L3 AND UserData.tp_ListId = @L4) LEFT OUTER JOIN AllUserData AS t5 WITH(NOLOCK, INDEX=AllUserData_PK) ON (UserData.[int2]=t5.[tp_ID] AND UserData.[tp_RowOrdinal] = 0 AND t5.[tp_RowOrdinal] = 0 AND ( (t5.tp_Level= 255 AND t5.tp_CheckoutUserId = @IU OR  ( t5.tp_Level  = 2 AND t5.tp_DraftOwnerId IS NOT NULL OR t5.tp_Level  = 1 AND t5.tp_DraftOwnerId IS  NULL  ) AND ( t5.tp_CheckoutUserId IS  NULL  OR t5.tp_CheckoutUserId <> @IU)) )  AND t5.[tp_CalculatedVersion] = 0  AND t5.[tp_DeleteTransactionId] = 0x  AND t5.tp_ListId = @L5 AND UserData.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t6_u WITH(NOLOCK)  INNER JOIN Docs AS t6_d WITH(NOLOCK) ON (t6_d.DoclibRowId = t6_u.tp_ID  AND t6_d.SiteId = t6_u.tp_SiteId AND t6_d.SiteId = @L2 AND t6_d.DirName = t6_u.tp_DirName  AND t6_d.LeafName = t6_u.tp_LeafName  AND t6_d.Level = t6_u.tp_Level  AND  (t6_u.tp_Level = 255 AND t6_d.LTCheckoutUserId =@IU OR (t6_u.tp_Level = 1 AND (t6_u.tp_DraftOwnerId IS NULL OR  (t6_u.tp_DraftOwnerId <>@IU AND t6_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t6_u.tp_Level = 2 AND (t6_u.tp_DraftOwnerId = @IU OR t6_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t6_d.LTCheckoutUserId IS NULL OR t6_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t6 ON (UserData.[int3]=t6.[tp_ID] AND UserData.[tp_RowOrdinal] = 0 AND t6.[tp_RowOrdinal] = 0 AND t6.tp_ListId = @L6 AND UserData.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t7_u WITH(NOLOCK)  INNER JOIN Docs AS t7_d WITH(NOLOCK) ON (t7_d.DoclibRowId = t7_u.tp_ID  AND t7_d.SiteId = t7_u.tp_SiteId AND t7_d.SiteId = @L2 AND t7_d.DirName = t7_u.tp_DirName  AND t7_d.LeafName = t7_u.tp_LeafName  AND t7_d.Level = t7_u.tp_Level  AND  (t7_u.tp_Level = 255 AND t7_d.LTCheckoutUserId =@IU OR (t7_u.tp_Level = 1 AND (t7_u.tp_DraftOwnerId IS NULL OR  (t7_u.tp_DraftOwnerId <>@IU AND t7_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t7_u.tp_Level = 2 AND (t7_u.tp_DraftOwnerId = @IU OR t7_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t7_d.LTCheckoutUserId IS NULL OR t7_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t7 ON (UserData.[int4]=t7.[tp_ID] AND UserData.[tp_RowOrdinal] = 0 AND t7.[tp_RowOrdinal] = 0 AND t7.tp_ListId = @L6 AND UserData.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t8_u WITH(NOLOCK)  INNER JOIN Docs AS t8_d WITH(NOLOCK) ON (t8_d.DoclibRowId = t8_u.tp_ID  AND t8_d.SiteId = t8_u.tp_SiteId AND t8_d.SiteId = @L2 AND t8_d.DirName = t8_u.tp_DirName  AND t8_d.LeafName = t8_u.tp_LeafName  AND t8_d.Level = t8_u.tp_Level  AND  (t8_u.tp_Level = 255 AND t8_d.LTCheckoutUserId =@IU OR (t8_u.tp_Level = 1 AND (t8_u.tp_DraftOwnerId IS NULL OR  (t8_u.tp_DraftOwnerId <>@IU AND t8_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t8_u.tp_Level = 2 AND (t8_u.tp_DraftOwnerId = @IU OR t8_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t8_d.LTCheckoutUserId IS NULL OR t8_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t8 ON (UserData.[int5]=t8.[tp_ID] AND UserData.[tp_RowOrdinal] = 0 AND t8.[tp_RowOrdinal] = 0 AND t8.tp_ListId = @L6 AND UserData.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t9_u WITH(NOLOCK)  INNER JOIN Docs AS t9_d WITH(NOLOCK) ON (t9_d.DoclibRowId = t9_u.tp_ID  AND t9_d.SiteId = t9_u.tp_SiteId AND t9_d.SiteId = @L2 AND t9_d.DirName = t9_u.tp_DirName  AND t9_d.LeafName = t9_u.tp_LeafName  AND t9_d.Level = t9_u.tp_Level  AND  (t9_u.tp_Level = 255 AND t9_d.LTCheckoutUserId =@IU OR (t9_u.tp_Level = 1 AND (t9_u.tp_DraftOwnerId IS NULL OR  (t9_u.tp_DraftOwnerId <>@IU AND t9_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t9_u.tp_Level = 2 AND (t9_u.tp_DraftOwnerId = @IU OR t9_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t9_d.LTCheckoutUserId IS NULL OR t9_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t9 ON (UserData.[int6]=t9.[tp_ID] AND UserData.[tp_RowOrdinal] = 0 AND t9.[tp_RowOrdinal] = 0 AND t9.tp_ListId = @L6 AND UserData.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t10_u WITH(NOLOCK)  INNER JOIN Docs AS t10_d WITH(NOLOCK) ON (t10_d.DoclibRowId = t10_u.tp_ID  AND t10_d.SiteId = t10_u.tp_SiteId AND t10_d.SiteId = @L2 AND t10_d.DirName = t10_u.tp_DirName  AND t10_d.LeafName = t10_u.tp_LeafName  AND t10_d.Level = t10_u.tp_Level  AND  (t10_u.tp_Level = 255 AND t10_d.LTCheckoutUserId =@IU OR (t10_u.tp_Level = 1 AND (t10_u.tp_DraftOwnerId IS NULL OR  (t10_u.tp_DraftOwnerId <>@IU AND t10_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t10_u.tp_Level = 2 AND (t10_u.tp_DraftOwnerId = @IU OR t10_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t10_d.LTCheckoutUserId IS NULL OR t10_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t10 ON (UserData.[int7]=t10.[tp_ID] AND UserData.[tp_RowOrdinal] = 0 AND t10.[tp_RowOrdinal] = 0 AND t10.tp_ListId = @L6 AND UserData.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t11_u WITH(NOLOCK)  INNER JOIN Docs AS t11_d WITH(NOLOCK) ON (t11_d.DoclibRowId = t11_u.tp_ID  AND t11_d.SiteId = t11_u.tp_SiteId AND t11_d.SiteId = @L2 AND t11_d.DirName = t11_u.tp_DirName  AND t11_d.LeafName = t11_u.tp_LeafName  AND t11_d.Level = t11_u.tp_Level  AND  (t11_u.tp_Level = 255 AND t11_d.LTCheckoutUserId =@IU OR (t11_u.tp_Level = 1 AND (t11_u.tp_DraftOwnerId IS NULL OR  (t11_u.tp_DraftOwnerId <>@IU AND t11_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t11_u.tp_Level = 2 AND (t11_u.tp_DraftOwnerId = @IU OR t11_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t11_d.LTCheckoutUserId IS NULL OR t11_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t11 ON (UserData.[int8]=t11.[tp_ID] AND UserData.[tp_RowOrdinal] = 0 AND t11.[tp_RowOrdinal] = 0 AND t11.tp_ListId = @L6 AND UserData.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t12_u WITH(NOLOCK)  INNER JOIN Docs AS t12_d WITH(NOLOCK) ON (t12_d.DoclibRowId = t12_u.tp_ID  AND t12_d.SiteId = t12_u.tp_SiteId AND t12_d.SiteId = @L2 AND t12_d.DirName = t12_u.tp_DirName  AND t12_d.LeafName = t12_u.tp_LeafName  AND t12_d.Level = t12_u.tp_Level  AND  (t12_u.tp_Level = 255 AND t12_d.LTCheckoutUserId =@IU OR (t12_u.tp_Level = 1 AND (t12_u.tp_DraftOwnerId IS NULL OR  (t12_u.tp_DraftOwnerId <>@IU AND t12_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t12_u.tp_Level = 2 AND (t12_u.tp_DraftOwnerId = @IU OR t12_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t12_d.LTCheckoutUserId IS NULL OR t12_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t12 ON (UserData.[int9]=t12.[tp_ID] AND UserData.[tp_RowOrdinal] = 0 AND t12.[tp_RowOrdinal] = 0 AND t12.tp_ListId = @L6 AND UserData.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t13_u WITH(NOLOCK)  INNER JOIN Docs AS t13_d WITH(NOLOCK) ON (t13_d.DoclibRowId = t13_u.tp_ID  AND t13_d.SiteId = t13_u.tp_SiteId AND t13_d.SiteId = @L2 AND t13_d.DirName = t13_u.tp_DirName  AND t13_d.LeafName = t13_u.tp_LeafName  AND t13_d.Level = t13_u.tp_Level  AND  (t13_u.tp_Level = 255 AND t13_d.LTCheckoutUserId =@IU OR (t13_u.tp_Level = 1 AND (t13_u.tp_DraftOwnerId IS NULL OR  (t13_u.tp_DraftOwnerId <>@IU AND t13_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t13_u.tp_Level = 2 AND (t13_u.tp_DraftOwnerId = @IU OR t13_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t13_d.LTCheckoutUserId IS NULL OR t13_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t13 ON (UserData.[int10]=t13.[tp_ID] AND UserData.[tp_RowOrdinal] = 0 AND t13.[tp_RowOrdinal] = 0 AND t13.tp_ListId = @L6 AND UserData.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t14_u WITH(NOLOCK)  INNER JOIN Docs AS t14_d WITH(NOLOCK) ON (t14_d.DoclibRowId = t14_u.tp_ID  AND t14_d.SiteId = t14_u.tp_SiteId AND t14_d.SiteId = @L2 AND t14_d.DirName = t14_u.tp_DirName  AND t14_d.LeafName = t14_u.tp_LeafName  AND t14_d.Level = t14_u.tp_Level  AND  (t14_u.tp_Level = 255 AND t14_d.LTCheckoutUserId =@IU OR (t14_u.tp_Level = 1 AND (t14_u.tp_DraftOwnerId IS NULL OR  (t14_u.tp_DraftOwnerId <>@IU AND t14_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t14_u.tp_Level = 2 AND (t14_u.tp_DraftOwnerId = @IU OR t14_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t14_d.LTCheckoutUserId IS NULL OR t14_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t14 ON (UserData.[int11]=t14.[tp_ID] AND UserData.[tp_RowOrdinal] = 0 AND t14.[tp_RowOrdinal] = 0 AND t14.tp_ListId = @L6 AND UserData.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t15_u WITH(NOLOCK)  INNER JOIN Docs AS t15_d WITH(NOLOCK) ON (t15_d.DoclibRowId = t15_u.tp_ID  AND t15_d.SiteId = t15_u.tp_SiteId AND t15_d.SiteId = @L2 AND t15_d.DirName = t15_u.tp_DirName  AND t15_d.LeafName = t15_u.tp_LeafName  AND t15_d.Level = t15_u.tp_Level  AND  (t15_u.tp_Level = 255 AND t15_d.LTCheckoutUserId =@IU OR (t15_u.tp_Level = 1 AND (t15_u.tp_DraftOwnerId IS NULL OR  (t15_u.tp_DraftOwnerId <>@IU AND t15_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t15_u.tp_Level = 2 AND (t15_u.tp_DraftOwnerId = @IU OR t15_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t15_d.LTCheckoutUserId IS NULL OR t15_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t15 ON (UserData.[int12]=t15.[tp_ID] AND UserData.[tp_RowOrdinal] = 0 AND t15.[tp_RowOrdinal] = 0 AND t15.tp_ListId = @L6 AND UserData.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t16_u WITH(NOLOCK)  INNER JOIN Docs AS t16_d WITH(NOLOCK) ON (t16_d.DoclibRowId = t16_u.tp_ID  AND t16_d.SiteId = t16_u.tp_SiteId AND t16_d.SiteId = @L2 AND t16_d.DirName = t16_u.tp_DirName  AND t16_d.LeafName = t16_u.tp_LeafName  AND t16_d.Level = t16_u.tp_Level  AND  (t16_u.tp_Level = 255 AND t16_d.LTCheckoutUserId =@IU OR (t16_u.tp_Level = 1 AND (t16_u.tp_DraftOwnerId IS NULL OR  (t16_u.tp_DraftOwnerId <>@IU AND t16_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t16_u.tp_Level = 2 AND (t16_u.tp_DraftOwnerId = @IU OR t16_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t16_d.LTCheckoutUserId IS NULL OR t16_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t16 ON (UserData.[int13]=t16.[tp_ID] AND UserData.[tp_RowOrdinal] = 0 AND t16.[tp_RowOrdinal] = 0 AND t16.tp_ListId = @L6 AND UserData.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t17_u WITH(NOLOCK)  INNER JOIN Docs AS t17_d WITH(NOLOCK) ON (t17_d.DoclibRowId = t17_u.tp_ID  AND t17_d.SiteId = t17_u.tp_SiteId AND t17_d.SiteId = @L2 AND t17_d.DirName = t17_u.tp_DirName  AND t17_d.LeafName = t17_u.tp_LeafName  AND t17_d.Level = t17_u.tp_Level  AND  (t17_u.tp_Level = 255 AND t17_d.LTCheckoutUserId =@IU OR (t17_u.tp_Level = 1 AND (t17_u.tp_DraftOwnerId IS NULL OR  (t17_u.tp_DraftOwnerId <>@IU AND t17_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t17_u.tp_Level = 2 AND (t17_u.tp_DraftOwnerId = @IU OR t17_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t17_d.LTCheckoutUserId IS NULL OR t17_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t17 ON (UserData.[int14]=t17.[tp_ID] AND UserData.[tp_RowOrdinal] = 0 AND t17.[tp_RowOrdinal] = 0 AND t17.tp_ListId = @L6 AND UserData.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t18_u WITH(NOLOCK)  INNER JOIN Docs AS t18_d WITH(NOLOCK) ON (t18_d.DoclibRowId = t18_u.tp_ID  AND t18_d.SiteId = t18_u.tp_SiteId AND t18_d.SiteId = @L2 AND t18_d.DirName = t18_u.tp_DirName  AND t18_d.LeafName = t18_u.tp_LeafName  AND t18_d.Level = t18_u.tp_Level  AND  (t18_u.tp_Level = 255 AND t18_d.LTCheckoutUserId =@IU OR (t18_u.tp_Level = 1 AND (t18_u.tp_DraftOwnerId IS NULL OR  (t18_u.tp_DraftOwnerId <>@IU AND t18_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t18_u.tp_Level = 2 AND (t18_u.tp_DraftOwnerId = @IU OR t18_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t18_d.LTCheckoutUserId IS NULL OR t18_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t18 ON (UserData.[int15]=t18.[tp_ID] AND UserData.[tp_RowOrdinal] = 0 AND t18.[tp_RowOrdinal] = 0 AND t18.tp_ListId = @L6 AND UserData.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t19_u WITH(NOLOCK)  INNER JOIN Docs AS t19_d WITH(NOLOCK) ON (t19_d.DoclibRowId = t19_u.tp_ID  AND t19_d.SiteId = t19_u.tp_SiteId AND t19_d.SiteId = @L2 AND t19_d.DirName = t19_u.tp_DirName  AND t19_d.LeafName = t19_u.tp_LeafName  AND t19_d.Level = t19_u.tp_Level  AND  (t19_u.tp_Level = 255 AND t19_d.LTCheckoutUserId =@IU OR (t19_u.tp_Level = 1 AND (t19_u.tp_DraftOwnerId IS NULL OR  (t19_u.tp_DraftOwnerId <>@IU AND t19_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t19_u.tp_Level = 2 AND (t19_u.tp_DraftOwnerId = @IU OR t19_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t19_d.LTCheckoutUserId IS NULL OR t19_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t19 ON (UserData.[int16]=t19.[tp_ID] AND UserData.[tp_RowOrdinal] = 0 AND t19.[tp_RowOrdinal] = 0 AND t19.tp_ListId = @L6 AND UserData.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t20_u WITH(NOLOCK)  INNER JOIN Docs AS t20_d WITH(NOLOCK) ON (t20_d.DoclibRowId = t20_u.tp_ID  AND t20_d.SiteId = t20_u.tp_SiteId AND t20_d.SiteId = @L2 AND t20_d.DirName = t20_u.tp_DirName  AND t20_d.LeafName = t20_u.tp_LeafName  AND t20_d.Level = t20_u.tp_Level  AND  (t20_u.tp_Level = 255 AND t20_d.LTCheckoutUserId =@IU OR (t20_u.tp_Level = 1 AND (t20_u.tp_DraftOwnerId IS NULL OR  (t20_u.tp_DraftOwnerId <>@IU AND t20_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t20_u.tp_Level = 2 AND (t20_u.tp_DraftOwnerId = @IU OR t20_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t20_d.LTCheckoutUserId IS NULL OR t20_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t20 ON (UserData.[tp_ID]=t20.[tp_ID] AND UserData.[tp_RowOrdinal] = 0 AND t20.[tp_RowOrdinal] = 1 AND t20.tp_ListId = @L4 AND UserData.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t21_u WITH(NOLOCK)  INNER JOIN Docs AS t21_d WITH(NOLOCK) ON (t21_d.DoclibRowId = t21_u.tp_ID  AND t21_d.SiteId = t21_u.tp_SiteId AND t21_d.SiteId = @L2 AND t21_d.DirName = t21_u.tp_DirName  AND t21_d.LeafName = t21_u.tp_LeafName  AND t21_d.Level = t21_u.tp_Level  AND  (t21_u.tp_Level = 255 AND t21_d.LTCheckoutUserId =@IU OR (t21_u.tp_Level = 1 AND (t21_u.tp_DraftOwnerId IS NULL OR  (t21_u.tp_DraftOwnerId <>@IU AND t21_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t21_u.tp_Level = 2 AND (t21_u.tp_DraftOwnerId = @IU OR t21_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t21_d.LTCheckoutUserId IS NULL OR t21_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t21 ON (t20.[int1]=t21.[tp_ID] AND t20.[tp_RowOrdinal] = 1 AND t21.[tp_RowOrdinal] = 0 AND t21.tp_ListId = @L6 AND t20.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t22_u WITH(NOLOCK)  INNER JOIN Docs AS t22_d WITH(NOLOCK) ON (t22_d.DoclibRowId = t22_u.tp_ID  AND t22_d.SiteId = t22_u.tp_SiteId AND t22_d.SiteId = @L2 AND t22_d.DirName = t22_u.tp_DirName  AND t22_d.LeafName = t22_u.tp_LeafName  AND t22_d.Level = t22_u.tp_Level  AND  (t22_u.tp_Level = 255 AND t22_d.LTCheckoutUserId =@IU OR (t22_u.tp_Level = 1 AND (t22_u.tp_DraftOwnerId IS NULL OR  (t22_u.tp_DraftOwnerId <>@IU AND t22_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t22_u.tp_Level = 2 AND (t22_u.tp_DraftOwnerId = @IU OR t22_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t22_d.LTCheckoutUserId IS NULL OR t22_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t22 ON (t20.[int2]=t22.[tp_ID] AND t20.[tp_RowOrdinal] = 1 AND t22.[tp_RowOrdinal] = 0 AND t22.tp_ListId = @L6 AND t20.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t23_u WITH(NOLOCK)  INNER JOIN Docs AS t23_d WITH(NOLOCK) ON (t23_d.DoclibRowId = t23_u.tp_ID  AND t23_d.SiteId = t23_u.tp_SiteId AND t23_d.SiteId = @L2 AND t23_d.DirName = t23_u.tp_DirName  AND t23_d.LeafName = t23_u.tp_LeafName  AND t23_d.Level = t23_u.tp_Level  AND  (t23_u.tp_Level = 255 AND t23_d.LTCheckoutUserId =@IU OR (t23_u.tp_Level = 1 AND (t23_u.tp_DraftOwnerId IS NULL OR  (t23_u.tp_DraftOwnerId <>@IU AND t23_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t23_u.tp_Level = 2 AND (t23_u.tp_DraftOwnerId = @IU OR t23_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t23_d.LTCheckoutUserId IS NULL OR t23_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t23 ON (t20.[int3]=t23.[tp_ID] AND t20.[tp_RowOrdinal] = 1 AND t23.[tp_RowOrdinal] = 0 AND t23.tp_ListId = @L6 AND t20.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t24_u WITH(NOLOCK)  INNER JOIN Docs AS t24_d WITH(NOLOCK) ON (t24_d.DoclibRowId = t24_u.tp_ID  AND t24_d.SiteId = t24_u.tp_SiteId AND t24_d.SiteId = @L2 AND t24_d.DirName = t24_u.tp_DirName  AND t24_d.LeafName = t24_u.tp_LeafName  AND t24_d.Level = t24_u.tp_Level  AND  (t24_u.tp_Level = 255 AND t24_d.LTCheckoutUserId =@IU OR (t24_u.tp_Level = 1 AND (t24_u.tp_DraftOwnerId IS NULL OR  (t24_u.tp_DraftOwnerId <>@IU AND t24_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t24_u.tp_Level = 2 AND (t24_u.tp_DraftOwnerId = @IU OR t24_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t24_d.LTCheckoutUserId IS NULL OR t24_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t24 ON (t20.[int4]=t24.[tp_ID] AND t20.[tp_RowOrdinal] = 1 AND t24.[tp_RowOrdinal] = 0 AND t24.tp_ListId = @L6 AND t20.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t25_u WITH(NOLOCK)  INNER JOIN Docs AS t25_d WITH(NOLOCK) ON (t25_d.DoclibRowId = t25_u.tp_ID  AND t25_d.SiteId = t25_u.tp_SiteId AND t25_d.SiteId = @L2 AND t25_d.DirName = t25_u.tp_DirName  AND t25_d.LeafName = t25_u.tp_LeafName  AND t25_d.Level = t25_u.tp_Level  AND  (t25_u.tp_Level = 255 AND t25_d.LTCheckoutUserId =@IU OR (t25_u.tp_Level = 1 AND (t25_u.tp_DraftOwnerId IS NULL OR  (t25_u.tp_DraftOwnerId <>@IU AND t25_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t25_u.tp_Level = 2 AND (t25_u.tp_DraftOwnerId = @IU OR t25_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t25_d.LTCheckoutUserId IS NULL OR t25_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t25 ON (t20.[int5]=t25.[tp_ID] AND t20.[tp_RowOrdinal] = 1 AND t25.[tp_RowOrdinal] = 0 AND t25.tp_ListId = @L6 AND t20.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t26_u WITH(NOLOCK)  INNER JOIN Docs AS t26_d WITH(NOLOCK) ON (t26_d.DoclibRowId = t26_u.tp_ID  AND t26_d.SiteId = t26_u.tp_SiteId AND t26_d.SiteId = @L2 AND t26_d.DirName = t26_u.tp_DirName  AND t26_d.LeafName = t26_u.tp_LeafName  AND t26_d.Level = t26_u.tp_Level  AND  (t26_u.tp_Level = 255 AND t26_d.LTCheckoutUserId =@IU OR (t26_u.tp_Level = 1 AND (t26_u.tp_DraftOwnerId IS NULL OR  (t26_u.tp_DraftOwnerId <>@IU AND t26_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t26_u.tp_Level = 2 AND (t26_u.tp_DraftOwnerId = @IU OR t26_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t26_d.LTCheckoutUserId IS NULL OR t26_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t26 ON (t20.[int6]=t26.[tp_ID] AND t20.[tp_RowOrdinal] = 1 AND t26.[tp_RowOrdinal] = 0 AND t26.tp_ListId = @L6 AND t20.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t27_u WITH(NOLOCK)  INNER JOIN Docs AS t27_d WITH(NOLOCK) ON (t27_d.DoclibRowId = t27_u.tp_ID  AND t27_d.SiteId = t27_u.tp_SiteId AND t27_d.SiteId = @L2 AND t27_d.DirName = t27_u.tp_DirName  AND t27_d.LeafName = t27_u.tp_LeafName  AND t27_d.Level = t27_u.tp_Level  AND  (t27_u.tp_Level = 255 AND t27_d.LTCheckoutUserId =@IU OR (t27_u.tp_Level = 1 AND (t27_u.tp_DraftOwnerId IS NULL OR  (t27_u.tp_DraftOwnerId <>@IU AND t27_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t27_u.tp_Level = 2 AND (t27_u.tp_DraftOwnerId = @IU OR t27_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t27_d.LTCheckoutUserId IS NULL OR t27_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t27 ON (t20.[int7]=t27.[tp_ID] AND t20.[tp_RowOrdinal] = 1 AND t27.[tp_RowOrdinal] = 0 AND t27.tp_ListId = @L6 AND t20.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t28_u WITH(NOLOCK)  INNER JOIN Docs AS t28_d WITH(NOLOCK) ON (t28_d.DoclibRowId = t28_u.tp_ID  AND t28_d.SiteId = t28_u.tp_SiteId AND t28_d.SiteId = @L2 AND t28_d.DirName = t28_u.tp_DirName  AND t28_d.LeafName = t28_u.tp_LeafName  AND t28_d.Level = t28_u.tp_Level  AND  (t28_u.tp_Level = 255 AND t28_d.LTCheckoutUserId =@IU OR (t28_u.tp_Level = 1 AND (t28_u.tp_DraftOwnerId IS NULL OR  (t28_u.tp_DraftOwnerId <>@IU AND t28_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t28_u.tp_Level = 2 AND (t28_u.tp_DraftOwnerId = @IU OR t28_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t28_d.LTCheckoutUserId IS NULL OR t28_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t28 ON (t20.[int8]=t28.[tp_ID] AND t20.[tp_RowOrdinal] = 1 AND t28.[tp_RowOrdinal] = 0 AND t28.tp_ListId = @L6 AND t20.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t29_u WITH(NOLOCK)  INNER JOIN Docs AS t29_d WITH(NOLOCK) ON (t29_d.DoclibRowId = t29_u.tp_ID  AND t29_d.SiteId = t29_u.tp_SiteId AND t29_d.SiteId = @L2 AND t29_d.DirName = t29_u.tp_DirName  AND t29_d.LeafName = t29_u.tp_LeafName  AND t29_d.Level = t29_u.tp_Level  AND  (t29_u.tp_Level = 255 AND t29_d.LTCheckoutUserId =@IU OR (t29_u.tp_Level = 1 AND (t29_u.tp_DraftOwnerId IS NULL OR  (t29_u.tp_DraftOwnerId <>@IU AND t29_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t29_u.tp_Level = 2 AND (t29_u.tp_DraftOwnerId = @IU OR t29_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t29_d.LTCheckoutUserId IS NULL OR t29_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t29 ON (t20.[int9]=t29.[tp_ID] AND t20.[tp_RowOrdinal] = 1 AND t29.[tp_RowOrdinal] = 0 AND t29.tp_ListId = @L6 AND t20.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t30_u WITH(NOLOCK)  INNER JOIN Docs AS t30_d WITH(NOLOCK) ON (t30_d.DoclibRowId = t30_u.tp_ID  AND t30_d.SiteId = t30_u.tp_SiteId AND t30_d.SiteId = @L2 AND t30_d.DirName = t30_u.tp_DirName  AND t30_d.LeafName = t30_u.tp_LeafName  AND t30_d.Level = t30_u.tp_Level  AND  (t30_u.tp_Level = 255 AND t30_d.LTCheckoutUserId =@IU OR (t30_u.tp_Level = 1 AND (t30_u.tp_DraftOwnerId IS NULL OR  (t30_u.tp_DraftOwnerId <>@IU AND t30_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t30_u.tp_Level = 2 AND (t30_u.tp_DraftOwnerId = @IU OR t30_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t30_d.LTCheckoutUserId IS NULL OR t30_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t30 ON (t20.[int10]=t30.[tp_ID] AND t20.[tp_RowOrdinal] = 1 AND t30.[tp_RowOrdinal] = 0 AND t30.tp_ListId = @L6 AND t20.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t31_u WITH(NOLOCK)  INNER JOIN Docs AS t31_d WITH(NOLOCK) ON (t31_d.DoclibRowId = t31_u.tp_ID  AND t31_d.SiteId = t31_u.tp_SiteId AND t31_d.SiteId = @L2 AND t31_d.DirName = t31_u.tp_DirName  AND t31_d.LeafName = t31_u.tp_LeafName  AND t31_d.Level = t31_u.tp_Level  AND  (t31_u.tp_Level = 255 AND t31_d.LTCheckoutUserId =@IU OR (t31_u.tp_Level = 1 AND (t31_u.tp_DraftOwnerId IS NULL OR  (t31_u.tp_DraftOwnerId <>@IU AND t31_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t31_u.tp_Level = 2 AND (t31_u.tp_DraftOwnerId = @IU OR t31_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t31_d.LTCheckoutUserId IS NULL OR t31_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t31 ON (t20.[int11]=t31.[tp_ID] AND t20.[tp_RowOrdinal] = 1 AND t31.[tp_RowOrdinal] = 0 AND t31.tp_ListId = @L6 AND t20.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t32_u WITH(NOLOCK)  INNER JOIN Docs AS t32_d WITH(NOLOCK) ON (t32_d.DoclibRowId = t32_u.tp_ID  AND t32_d.SiteId = t32_u.tp_SiteId AND t32_d.SiteId = @L2 AND t32_d.DirName = t32_u.tp_DirName  AND t32_d.LeafName = t32_u.tp_LeafName  AND t32_d.Level = t32_u.tp_Level  AND  (t32_u.tp_Level = 255 AND t32_d.LTCheckoutUserId =@IU OR (t32_u.tp_Level = 1 AND (t32_u.tp_DraftOwnerId IS NULL OR  (t32_u.tp_DraftOwnerId <>@IU AND t32_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t32_u.tp_Level = 2 AND (t32_u.tp_DraftOwnerId = @IU OR t32_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t32_d.LTCheckoutUserId IS NULL OR t32_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t32 ON (t20.[int12]=t32.[tp_ID] AND t20.[tp_RowOrdinal] = 1 AND t32.[tp_RowOrdinal] = 0 AND t32.tp_ListId = @L6 AND t20.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t33_u WITH(NOLOCK)  INNER JOIN Docs AS t33_d WITH(NOLOCK) ON (t33_d.DoclibRowId = t33_u.tp_ID  AND t33_d.SiteId = t33_u.tp_SiteId AND t33_d.SiteId = @L2 AND t33_d.DirName = t33_u.tp_DirName  AND t33_d.LeafName = t33_u.tp_LeafName  AND t33_d.Level = t33_u.tp_Level  AND  (t33_u.tp_Level = 255 AND t33_d.LTCheckoutUserId =@IU OR (t33_u.tp_Level = 1 AND (t33_u.tp_DraftOwnerId IS NULL OR  (t33_u.tp_DraftOwnerId <>@IU AND t33_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t33_u.tp_Level = 2 AND (t33_u.tp_DraftOwnerId = @IU OR t33_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t33_d.LTCheckoutUserId IS NULL OR t33_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t33 ON (t20.[int13]=t33.[tp_ID] AND t20.[tp_RowOrdinal] = 1 AND t33.[tp_RowOrdinal] = 0 AND t33.tp_ListId = @L6 AND t20.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t34_u WITH(NOLOCK)  INNER JOIN Docs AS t34_d WITH(NOLOCK) ON (t34_d.DoclibRowId = t34_u.tp_ID  AND t34_d.SiteId = t34_u.tp_SiteId AND t34_d.SiteId = @L2 AND t34_d.DirName = t34_u.tp_DirName  AND t34_d.LeafName = t34_u.tp_LeafName  AND t34_d.Level = t34_u.tp_Level  AND  (t34_u.tp_Level = 255 AND t34_d.LTCheckoutUserId =@IU OR (t34_u.tp_Level = 1 AND (t34_u.tp_DraftOwnerId IS NULL OR  (t34_u.tp_DraftOwnerId <>@IU AND t34_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t34_u.tp_Level = 2 AND (t34_u.tp_DraftOwnerId = @IU OR t34_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t34_d.LTCheckoutUserId IS NULL OR t34_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t34 ON (t20.[int14]=t34.[tp_ID] AND t20.[tp_RowOrdinal] = 1 AND t34.[tp_RowOrdinal] = 0 AND t34.tp_ListId = @L6 AND t20.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t35_u WITH(NOLOCK)  INNER JOIN Docs AS t35_d WITH(NOLOCK) ON (t35_d.DoclibRowId = t35_u.tp_ID  AND t35_d.SiteId = t35_u.tp_SiteId AND t35_d.SiteId = @L2 AND t35_d.DirName = t35_u.tp_DirName  AND t35_d.LeafName = t35_u.tp_LeafName  AND t35_d.Level = t35_u.tp_Level  AND  (t35_u.tp_Level = 255 AND t35_d.LTCheckoutUserId =@IU OR (t35_u.tp_Level = 1 AND (t35_u.tp_DraftOwnerId IS NULL OR  (t35_u.tp_DraftOwnerId <>@IU AND t35_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t35_u.tp_Level = 2 AND (t35_u.tp_DraftOwnerId = @IU OR t35_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t35_d.LTCheckoutUserId IS NULL OR t35_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t35 ON (t20.[int15]=t35.[tp_ID] AND t20.[tp_RowOrdinal] = 1 AND t35.[tp_RowOrdinal] = 0 AND t35.tp_ListId = @L6 AND t20.tp_ListId = @L4) LEFT OUTER JOIN (SELECT * FROM UserData AS t36_u WITH(NOLOCK)  INNER JOIN Docs AS t36_d WITH(NOLOCK) ON (t36_d.DoclibRowId = t36_u.tp_ID  AND t36_d.SiteId = t36_u.tp_SiteId AND t36_d.SiteId = @L2 AND t36_d.DirName = t36_u.tp_DirName  AND t36_d.LeafName = t36_u.tp_LeafName  AND t36_d.Level = t36_u.tp_Level  AND  (t36_u.tp_Level = 255 AND t36_d.LTCheckoutUserId =@IU OR (t36_u.tp_Level = 1 AND (t36_u.tp_DraftOwnerId IS NULL OR  (t36_u.tp_DraftOwnerId <>@IU AND t36_d.ScopeId NOT IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A')))  OR t36_u.tp_Level = 2 AND (t36_u.tp_DraftOwnerId = @IU OR t36_d.ScopeId IN ('F9E4ED35-6054-456F-AD60-ACCD562BE50A'))) AND (t36_d.LTCheckoutUserId IS NULL OR t36_d.LTCheckoutUserId <> @IU )) AND (1 = 1))) AS t36 ON (t20.[int16]=t36.[tp_ID] AND t20.[tp_RowOrdinal] = 1 AND t36.[tp_RowOrdinal] = 0 AND t36.tp_ListId = @L6 AND t20.tp_ListId = @L4) LEFT OUTER JOIN AllUserData AS t37 WITH(NOLOCK, INDEX=AllUserData_PK) ON (UserData.[tp_Author]=t37.[tp_ID] AND UserData.[tp_RowOrdinal] = 0 AND t37.[tp_RowOrdinal] = 0 AND ( (t37.tp_IsCurrent = 1) )  AND t37.[tp_CalculatedVersion] = 0  AND t37.[tp_DeleteTransactionId] = 0x  AND t37.tp_ListId = @L3 AND UserData.tp_ListId = @L4) LEFT OUTER JOIN AllUserData AS t38 WITH(NOLOCK, INDEX=AllUserData_PK) ON (t1.[LTCheckoutUserId]=t38.[tp_ID] AND t38.[tp_RowOrdinal] = 0 AND ( (t38.tp_IsCurrent = 1) )  AND t38.[tp_CalculatedVersion] = 0  AND t38.[tp_DeleteTransactionId] = 0x  AND t38.tp_ListId = @L3) WHERE  (UserData.tp_Level= 255 AND UserData.tp_CheckoutUserId = @IU OR  ( UserData.tp_Level  <> 255 AND (UserData.tp_CheckoutUserId IS  NULL  OR UserData.tp_CheckoutUserId <> @IU))) AND UserData.tp_SiteId=@L2 AND (UserData.tp_DirName=@DN OR UserData.tp_DirName LIKE @DNEL+N'/%') AND UserData.tp_RowOrdinal=0 AND (((t1.DirName=@L7DNP AND t1.LeafName=@L8DNP)) AND t1.SiteId=@L2 AND (t1.DirName=@DN OR t1.DirName LIKE @DNEL+N'/%')) ORDER BY UserData.[tp_ID] Asc OPTION (FORCE ORDER) "

10-26-2011 13:24:43.69 - w2wp.exe - Windows SharePoint Services - General - 8w2w - Medium:

Unknown SPRequest error occurred. More information: 0x80131530

10-26-2011 13:24:43.69 - w2wp.exe - Windows SharePoint Services - General - 8dzz - High:

Exception Type: System.Web.HttpException  Exception Message: Request timed out.