SELECT DISTINCT t8.[tp_Ordinal], t9.[nvarchar10] AS c4c5, t10.[nvarchar10] AS c8c5, t7.*, t2.[tp_ID] AS c4, t5.[tp_ID] AS c8 
FROM (
      SELECT TOP(2147483648) t1.[Type] AS c0, UserData.[float5], t6.[nvarchar10] AS c9c5, UserData.[tp_IsCurrentVersion], UserData.[int8], t4.[nvarchar10] AS c7c5, UserData.[nvarchar9], UserData.[tp_Created], UserData.[tp_ModerationStatus], UserData.[tp_Level], UserData.[tp_SiteId], UserData.[tp_CalculatedVersion], UserData.[nvarchar6], UserData.[bit2], UserData.[nvarchar1], t1.[ScopeId] AS c3, UserData.[tp_HasAttachment], UserData.[int1], UserData.[int6], UserData.[tp_Modified], 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 c2, UserData.[tp_DeleteTransactionId], UserData.[tp_ParentId], UserData.[tp_DocId], UserData.[int2], UserData.[tp_ID], UserData.[float6], UserData.[nvarchar16], t1.[SortBehavior] AS c1, UserData.[int4], t3.[nvarchar10] AS c6c5, UserData.[int9] 
      FROM AllUserData AS UserData WITH(INDEX=AllUserData_PK) 
      INNER JOIN Docs AS t1 WITH(NOLOCK) 
        ON (UserData.[tp_RowOrdinal] = 0) AND (t1.SiteId=UserData.tp_SiteId) AND (t1.SiteId = '8C20E0C0-676E-45FC-9A55-80EA23297E11') 
          AND (t1.ParentId = UserData.tp_ParentId) AND (t1.Id = UserData.tp_DocId) AND ( (UserData.tp_Level = 1 OR UserData.tp_Level =  2) ) 
          AND (t1.Level = UserData.tp_Level) AND (t1.IsCurrentVersion = 1) AND (t1.Level = 1 OR t1.Level =  2) 
          AND (UserData.[tp_ListID] ='C69A175F-7719-47F8-ADC4-3E46CDB24266') AND (UserData.[tp_CalculatedVersion] = 0 ) 
          AND (UserData.[tp_IsCurrentVersion] = CONVERT(bit,1) ) AND (UserData.[tp_DeleteTransactionId] = 0x ) 
      LEFT OUTER LOOP JOIN AllUserData AS t3 WITH(NOLOCK,INDEX=AllUserData_PK) 
        ON (UserData.[int2]=t3.[tp_ID]) AND (UserData.[tp_RowOrdinal] = 0) AND (t3.[tp_RowOrdinal] = 0) AND ( (t3.tp_Level = 1) ) 
          AND (t3.[tp_IsCurrentVersion] = CONVERT(bit,1) ) AND (t3.[tp_CalculatedVersion] = 0 ) AND (t3.[tp_DeleteTransactionId] = 0x ) 
          AND (t3.tp_ListId = 'ED47F84E-4309-4157-AA17-C8889BB45B03') AND (UserData.tp_ListId = 'C69A175F-7719-47F8-ADC4-3E46CDB24266') 
      LEFT OUTER LOOP JOIN AllUserData AS t4 WITH(NOLOCK,INDEX=AllUserData_PK) 
        ON (UserData.[int8]=t4.[tp_ID]) AND (UserData.[tp_RowOrdinal] = 0) AND (t4.[tp_RowOrdinal] = 0) AND ( (t4.tp_Level = 1) ) 
          AND (t4.[tp_IsCurrentVersion] = CONVERT(bit,1) ) AND (t4.[tp_CalculatedVersion] = 0 ) AND (t4.[tp_DeleteTransactionId] = 0x ) 
          AND (t4.tp_ListId = 'ED47F84E-4309-4157-AA17-C8889BB45B03') AND (UserData.tp_ListId = 'C69A175F-7719-47F8-ADC4-3E46CDB24266') 
      LEFT OUTER LOOP JOIN AllUserData AS t6 WITH(NOLOCK,INDEX=AllUserData_PK) 
        ON (UserData.[int9]=t6.[tp_ID]) AND (UserData.[tp_RowOrdinal] = 0) AND (t6.[tp_RowOrdinal] = 0) AND ( (t6.tp_Level = 1) ) 
          AND (t6.[tp_IsCurrentVersion] = CONVERT(bit,1) ) AND (t6.[tp_CalculatedVersion] = 0 ) AND (t6.[tp_DeleteTransactionId] = 0x ) 
          AND (t6.tp_ListId = 'ED47F84E-4309-4157-AA17-C8889BB45B03') AND (UserData.tp_ListId = 'C69A175F-7719-47F8-ADC4-3E46CDB24266') 
      WHERE (UserData.[tp_CalculatedVersion] = 0 ) AND (UserData.[tp_IsCurrentVersion] = CONVERT(bit,1) ) AND (UserData.[tp_DeleteTransactionId] = 0x ) 
            AND (UserData.tp_ListID='C69A175F-7719-47F8-ADC4-3E46CDB24266') AND ( (UserData.tp_Level = 1 OR UserData.tp_Level =  2)   AND (UserData.tp_IsCurrent = 1 ) ) AND (UserData.tp_SiteId='8C20E0C0-676E-45FC-9A55-80EA23297E11') AND (UserData.tp_RowOrdinal=0) AND (t1.SiteId='8C20E0C0-676E-45FC-9A55-80EA23297E11' 
            AND (t1.DirName=N'xxxxxxxx/xxxxxx/xxxxxxxxx/xxxxxxxxxx/Lists/NewRealEstates' OR t1.DirName LIKE N'xxxxxxxx/xxxxxxxxx/mxxxxxxxx/xxxxxxxxx/Lists/NewRealEstates'+N'/%') AND t1.SortBehavior=0) 
      ORDER BY UserData.[tp_ID]  ASC 
) AS t7 
LEFT OUTER JOIN UserDataJunctions AS t8 WITH(NOLOCK) 
  ON (t7.[tp_SiteId] = t8.[tp_SiteId] AND t7.[tp_DeleteTransactionId] = t8.[tp_DeleteTransactionId] AND t7.[tp_IsCurrentVersion] = t8.[tp_IsCurrentVersion] AND t7.[tp_ParentId] = t8.[tp_ParentId] AND t7.[tp_DocId] = t8.[tp_DocId] AND t7.[tp_CalculatedVersion] = t8.[tp_CalculatedVersion] AND t7.[tp_Level] = t8.[tp_Level]) 
LEFT OUTER JOIN UserDataJunctions AS t2 WITH(NOLOCK) 
  ON (t7.[tp_SiteId] = t2.[tp_SiteId] AND t7.[tp_DeleteTransactionId] = t2.[tp_DeleteTransactionId] AND t7.[tp_IsCurrentVersion] = t2.[tp_IsCurrentVersion] AND t7.[tp_ParentId] = t2.[tp_ParentId] AND t7.[tp_DocId] = t2.[tp_DocId] AND t7.[tp_CalculatedVersion] = t2.[tp_CalculatedVersion] AND t7.[tp_Level] = t2.[tp_Level]) AND (t8.[tp_Ordinal] = t2.[tp_Ordinal]) AND (t2.[tp_FieldId] = 'FF231F57-83A0-463D-8E66-A91F8A726C8B') 
LEFT OUTER JOIN UserDataJunctions AS t5 WITH(NOLOCK) 
  ON (t7.[tp_SiteId] = t5.[tp_SiteId] AND t7.[tp_DeleteTransactionId] = t5.[tp_DeleteTransactionId] AND t7.[tp_IsCurrentVersion] = t5.[tp_IsCurrentVersion] AND t7.[tp_ParentId] = t5.[tp_ParentId] AND t7.[tp_DocId] = t5.[tp_DocId] AND t7.[tp_CalculatedVersion] = t5.[tp_CalculatedVersion] AND t7.[tp_Level] = t5.[tp_Level]) AND (t8.[tp_Ordinal] = t5.[tp_Ordinal]) AND (t5.[tp_FieldId] = '716262A0-6759-4C3A-A876-4A24C9CFF48E') 
LEFT OUTER LOOP JOIN AllUserData AS t9 WITH(NOLOCK,INDEX=AllUserData_PK) 
  ON (t9.[tp_ListId] = 'ED47F84E-4309-4157-AA17-C8889BB45B03') AND (t9.[tp_Id] = t2.[tp_ID]) AND (t9.[tp_RowOrdinal] = 0) AND (t9.[tp_IsCurrentVersion] = CONVERT(bit,1) ) AND (t9.[tp_CalculatedVersion] = 0 ) AND (t9.[tp_DeleteTransactionId] = 0x ) AND ( (t9.tp_Level = 1) ) 
LEFT OUTER LOOP JOIN AllUserData AS t10 WITH(NOLOCK,INDEX=AllUserData_PK) 
  ON (t10.[tp_ListId] = 'ED47F84E-4309-4157-AA17-C8889BB45B03') AND (t10.[tp_Id] = t5.[tp_ID]) AND (t10.[tp_RowOrdinal] = 0) AND (t10.[tp_IsCurrentVersion] = CONVERT(bit,1) ) AND (t10.[tp_CalculatedVersion] = 0 ) AND (t10.[tp_DeleteTransactionId] = 0x ) AND ( (t10.tp_Level = 1) ) 

ORDER BY t7.tp_ID  ASC ,t8.[tp_Ordinal]  ASC  OPTION (FORCE ORDER, MAXDOP 1)