SELECT [PC].[S] FROM (SELECT [S].[BaseManagedEntityId] AS [S],0 AS CS,[R0].[TargetEntityId] AS [T0],1 AS CRT0,[R1].[TargetEntityId] AS [T1],2 AS CRT1,[R2].[TargetEntityId] AS [T2],3 AS CRT2,[R3].[TargetEntityId] AS [T3],4 AS CRT3,[R4].[TargetEntityId] AS [T4],5 AS CRT4,[R5].[TargetEntityId] AS [T5],6 AS CRT5,[R6].[TargetEntityId] AS [T6],7 AS CRT6,[R7].[TargetEntityId] AS [T7],8 AS CRT7,[R8].[TargetEntityId] AS [T8],9 AS CRT8,[R9].[TargetEntityId] AS [T9],10 AS CRT9,[R10].[TargetEntityId] AS [T10],11 AS CRT10,[R11].[TargetEntityId] AS [T11],12 AS CRT11,[R12].[SourceEntityId] AS [T12],13 AS CRT12,[R13].[TargetEntityId] AS [T13],14 AS CRT13,[R14].[TargetEntityId] AS [T14],15 AS CRT14,[R15].[TargetEntityId] AS [T15],16 AS CRT15,[R16].[TargetEntityId] AS [T16],17 AS CRT16,[R17].[TargetEntityId] AS [T17],18 AS CRT17,[R18].[SourceEntityId] AS [T18],19 AS CRT18,[R19].[TargetEntityId] AS [T19],20 AS CRT19,[R20].[TargetEntityId] AS [T20],21 AS CRT20,[R21].[TargetEntityId] AS [T21],22 AS CRT21,[R22].[TargetEntityId] AS [T22],23 AS CRT22,[R23].[TargetEntityId] AS [T23],24 AS CRT23,[R24].[TargetEntityId] AS [T24],25 AS CRT24,[R25].[TargetEntityId] AS [T25],26 AS CRT25,[R26].[TargetEntityId] AS [T26],27 AS CRT26 FROM dbo.TypedManagedEntity AS S   INNER JOIN dbo.BaseManagedEntity AS BMES       ON S.[BaseManagedEntityId] = BMES.BaseManagedEntityId  LEFT OUTER JOIN dbo.Relationship AS R0 /*SOURCE_HINT_PATTERN*/-- System.WorkItem.IncidentPrimaryOwner      ON (R0.[SourceEntityId] = S.[BaseManagedEntityId]      AND R0.[RelationshipTypeId] = '42179172-3d24-cfc8-3944-b0a18f550214')  LEFT OUTER JOIN dbo.BaseManagedEntity AS BME0       ON R0.[TargetEntityId] = BME0.BaseManagedEntityId  LEFT OUTER JOIN dbo.Relationship AS R1 /*SOURCE_HINT_PATTERN*/-- System.WorkItemAffectedUser      ON (R1.[SourceEntityId] = S.[BaseManagedEntityId]      AND R1.[RelationshipTypeId] = 'dff9be66-38b0-b6d6-6144-a412a3ebd4ce')  LEFT OUTER JOIN dbo.BaseManagedEntity AS BME1       ON R1.[TargetEntityId] = BME1.BaseManagedEntityId  LEFT OUTER JOIN dbo.Relationship AS R2 /*SOURCE_HINT_PATTERN*/-- System.WorkItemAssignedToUser      ON (R2.[SourceEntityId] = S.[BaseManagedEntityId]      AND R2.[RelationshipTypeId] = '15e577a3-6bf9-6713-4eac-ba5a5b7c4722')  LEFT OUTER JOIN dbo.BaseManagedEntity AS BME2       ON R2.[TargetEntityId] = BME2.BaseManagedEntityId  LEFT OUTER JOIN dbo.Relationship AS R3 /*SOURCE_HINT_PATTERN*/-- System.WorkItemCreatedByUser      ON (R3.[SourceEntityId] = S.[BaseManagedEntityId]      AND R3.[RelationshipTypeId] = 'df738111-c7a2-b450-5872-c5f3b927481a')  LEFT OUTER JOIN dbo.BaseManagedEntity AS BME3       ON R3.[TargetEntityId] = BME3.BaseManagedEntityId  LEFT OUTER JOIN dbo.Relationship AS R4 /*SOURCE_HINT_PATTERN*/-- System.WorkItem.TroubleTicketClosedByUser      ON (R4.[SourceEntityId] = S.[BaseManagedEntityId]      AND R4.[RelationshipTypeId] = '76bc6c3b-a77b-2468-0a63-169d23dfcdf0')  LEFT OUTER JOIN dbo.BaseManagedEntity AS BME4       ON R4.[TargetEntityId] = BME4.BaseManagedEntityId  LEFT OUTER JOIN dbo.Relationship AS R5 /*SOURCE_HINT_PATTERN*/-- System.WorkItem.TroubleTicketResolvedByUser      ON (R5.[SourceEntityId] = S.[BaseManagedEntityId]      AND R5.[RelationshipTypeId] = 'f7d9b385-a84d-3884-7cde-e2c926d931a5')  LEFT OUTER JOIN dbo.BaseManagedEntity AS BME5       ON R5.[TargetEntityId] = BME5.BaseManagedEntityId  LEFT OUTER JOIN dbo.Relationship AS R6 /*SOURCE_HINT_PATTERN*/-- System.WorkItem.TroubleTicketHasActionLog      ON (R6.[SourceEntityId] = S.[BaseManagedEntityId]      AND R6.[RelationshipTypeId] = 'a860c62e-e675-b121-f614-e52fcbd9ef2c')  LEFT OUTER JOIN dbo.BaseManagedEntity AS BME6       ON R6.[TargetEntityId] = BME6.BaseManagedEntityId  LEFT OUTER JOIN dbo.Relationship AS R7 /*SOURCE_HINT_PATTERN*/-- System.WorkItem.TroubleTicketHasUserComment      ON (R7.[SourceEntityId] = S.[BaseManagedEntityId]      AND R7.[RelationshipTypeId] = 'ce423786-16dd-da9c-fb7b-21ab5189e12b')  LEFT OUTER JOIN dbo.BaseManagedEntity AS BME7       ON R7.[TargetEntityId] = BME7.BaseManagedEntityId  LEFT OUTER JOIN dbo.Relationship AS R8 /*SOURCE_HINT_PATTERN*/-- System.WorkItem.TroubleTicketHasAnalystComment      ON (R8.[SourceEntityId] = S.[BaseManagedEntityId]      AND R8.[RelationshipTypeId] = '835a64cd-7d41-10eb-e5e4-365ea2efc2ea')  LEFT OUTER JOIN dbo.BaseManagedEntity AS BME8       ON R8.[TargetEntityId] = BME8.BaseManagedEntityId  LEFT OUTER JOIN dbo.Relationship AS R9 /*SOURCE_HINT_PATTERN*/-- System.WorkItem.TroubleTicketHasNotificationLog      ON (R9.[SourceEntityId] = S.[BaseManagedEntityId]      AND R9.[RelationshipTypeId] = '106285b2-0200-8ecb-324e-342976b16151'      AND EXISTS ( -- Restricted to System.WorkItem.TroubleTicket.SmtpNotificationLog         SELECT 1 FROM dbo.[TypedManagedEntity]         WHERE R9.[TargetEntityId] = [BaseManagedEntityId]         AND [ManagedTypeId] = 'b4e0d3c5-b138-5f1a-a5cd-2249c3829646' ))  LEFT OUTER JOIN dbo.BaseManagedEntity AS BME9       ON R9.[TargetEntityId] = BME9.BaseManagedEntityId  LEFT OUTER JOIN dbo.Relationship AS R10 /*SOURCE_HINT_PATTERN*/-- System.WorkItemContainsActivity      ON (R10.[SourceEntityId] = S.[BaseManagedEntityId]      AND R10.[RelationshipTypeId] = '2da498be-0485-b2b2-d520-6ebd1698e61b')  LEFT OUTER JOIN dbo.BaseManagedEntity AS BME10       ON R10.[TargetEntityId] = BME10.BaseManagedEntityId  LEFT OUTER JOIN dbo.Relationship AS R11 /*SOURCE_HINT_PATTERN*/-- System.WorkItemRelatesToWorkItem      ON (R11.[SourceEntityId] = S.[BaseManagedEntityId]      AND R11.[RelationshipTypeId] = 'cb6ce813-ea8d-094d-ee5a-b755701f4547')  LEFT OUTER JOIN dbo.BaseManagedEntity AS BME11       ON R11.[TargetEntityId] = BME11.BaseManagedEntityId  LEFT OUTER JOIN dbo.Relationship AS R12 /*TARGET_HINT_PATTERN*/-- System.WorkItemRelatesToWorkItem      ON (R12.[TargetEntityId] = S.[BaseManagedEntityId]      AND R12.[RelationshipTypeId] = 'cb6ce813-ea8d-094d-ee5a-b755701f4547')  LEFT OUTER JOIN dbo.BaseManagedEntity AS BME12       ON R12.[SourceEntityId] = BME12.BaseManagedEntityId  LEFT OUTER JOIN dbo.Relationship AS R13 /*SOURCE_HINT_PATTERN*/-- System.WorkItemAboutConfigItem      ON (R13.[SourceEntityId] = S.[BaseManagedEntityId]      AND R13.[RelationshipTypeId] = 'b73a6094-c64c-b0ff-9706-1822df5c2e82')  LEFT OUTER JOIN dbo.BaseManagedEntity AS BME13       ON R13.[TargetEntityId] = BME13.BaseManagedEntityId  LEFT OUTER JOIN dbo.Relationship AS R14 /*SOURCE_HINT_PATTERN*/-- System.WorkItemRelatesToConfigItem      ON (R14.[SourceEntityId] = S.[BaseManagedEntityId]      AND R14.[RelationshipTypeId] = 'd96c8b59-8554-6e77-0aa7-f51448868b43')  LEFT OUTER JOIN dbo.BaseManagedEntity AS BME14       ON R14.[TargetEntityId] = BME14.BaseManagedEntityId  LEFT OUTER JOIN dbo.Relationship AS R15 /*SOURCE_HINT_PATTERN*/-- System.WorkItemAboutConfigItem      ON (R15.[SourceEntityId] = S.[BaseManagedEntityId]      AND R15.[RelationshipTypeId] = 'b73a6094-c64c-b0ff-9706-1822df5c2e82')  LEFT OUTER JOIN dbo.BaseManagedEntity AS BME15       ON R15.[TargetEntityId] = BME15.BaseManagedEntityId  LEFT OUTER JOIN dbo.Relationship AS R16 /*SOURCE_HINT_PATTERN*/-- System.EntityLinksToKnowledgeDocument      ON (R16.[SourceEntityId] = S.[BaseManagedEntityId]      AND R16.[RelationshipTypeId] = 'ec8a256b-cc89-6f18-af6a-e9cdc38cc573')  LEFT OUTER JOIN dbo.BaseManagedEntity AS BME16       ON R16.[TargetEntityId] = BME16.BaseManagedEntityId  LEFT OUTER JOIN dbo.Relationship AS R17 /*SOURCE_HINT_PATTERN*/-- System.WorkItemHasFileAttachment      ON (R17.[SourceEntityId] = S.[BaseManagedEntityId]      AND R17.[RelationshipTypeId] = 'aa8c26dc-3a12-5f88-d9c7-753e5a8a55b4')  LEFT OUTER JOIN dbo.BaseManagedEntity AS BME17       ON R17.[TargetEntityId] = BME17.BaseManagedEntityId  LEFT OUTER JOIN dbo.Relationship AS R18 /*TARGET_HINT_PATTERN*/-- System.WorkItemContainsActivity      ON (R18.[TargetEntityId] = R10.[TargetEntityId]      AND R18.[RelationshipTypeId] = '2da498be-0485-b2b2-d520-6ebd1698e61b')  LEFT OUTER JOIN dbo.BaseManagedEntity AS BME18       ON R18.[SourceEntityId] = BME18.BaseManagedEntityId  LEFT OUTER JOIN dbo.Relationship AS R19 /*SOURCE_HINT_PATTERN*/-- System.WorkItemCreatedByUser      ON (R19.[SourceEntityId] = R10.[TargetEntityId]      AND R19.[RelationshipTypeId] = 'df738111-c7a2-b450-5872-c5f3b927481a')  LEFT OUTER JOIN dbo.BaseManagedEntity AS BME19       ON R19.[TargetEntityId] = BME19.BaseManagedEntityId  LEFT OUTER JOIN dbo.Relationship AS R20 /*SOURCE_HINT_PATTERN*/-- System.WorkItemAssignedToUser      ON (R20.[SourceEntityId] = R10.[TargetEntityId]      AND R20.[RelationshipTypeId] = '15e577a3-6bf9-6713-4eac-ba5a5b7c4722')  LEFT OUTER JOIN dbo.BaseManagedEntity AS BME20       ON R20.[TargetEntityId] = BME20.BaseManagedEntityId  LEFT OUTER JOIN dbo.Relationship AS R21 /*SOURCE_HINT_PATTERN*/-- System.WorkItemAboutConfigItem      ON (R21.[SourceEntityId] = R10.[TargetEntityId]      AND R21.[RelationshipTypeId] = 'b73a6094-c64c-b0ff-9706-1822df5c2e82')  LEFT OUTER JOIN dbo.BaseManagedEntity AS BME21       ON R21.[TargetEntityId] = BME21.BaseManagedEntityId  LEFT OUTER JOIN dbo.Relationship AS R22 /*SOURCE_HINT_PATTERN*/-- System.WorkItemAffectedUser      ON (R22.[SourceEntityId] = R11.[TargetEntityId]      AND R22.[RelationshipTypeId] = 'dff9be66-38b0-b6d6-6144-a412a3ebd4ce')  LEFT OUTER JOIN dbo.BaseManagedEntity AS BME22       ON R22.[TargetEntityId] = BME22.BaseManagedEntityId  LEFT OUTER JOIN dbo.Relationship AS R23 /*SOURCE_HINT_PATTERN*/-- System.WorkItemAssignedToUser      ON (R23.[SourceEntityId] = R11.[TargetEntityId]      AND R23.[RelationshipTypeId] = '15e577a3-6bf9-6713-4eac-ba5a5b7c4722')  LEFT OUTER JOIN dbo.BaseManagedEntity AS BME23       ON R23.[TargetEntityId] = BME23.BaseManagedEntityId  LEFT OUTER JOIN dbo.Relationship AS R24 /*SOURCE_HINT_PATTERN*/-- System.WorkItemAffectedUser      ON (R24.[SourceEntityId] = R12.[SourceEntityId]      AND R24.[RelationshipTypeId] = 'dff9be66-38b0-b6d6-6144-a412a3ebd4ce')  LEFT OUTER JOIN dbo.BaseManagedEntity AS BME24       ON R24.[TargetEntityId] = BME24.BaseManagedEntityId  LEFT OUTER JOIN dbo.Relationship AS R25 /*SOURCE_HINT_PATTERN*/-- System.WorkItemAssignedToUser      ON (R25.[SourceEntityId] = R12.[SourceEntityId]      AND R25.[RelationshipTypeId] = '15e577a3-6bf9-6713-4eac-ba5a5b7c4722')  LEFT OUTER JOIN dbo.BaseManagedEntity AS BME25       ON R25.[TargetEntityId] = BME25.BaseManagedEntityId  LEFT OUTER JOIN dbo.Relationship AS R26 /*SOURCE_HINT_PATTERN*/-- System.FileAttachmentAddedByUser      ON (R26.[SourceEntityId] = R17.[TargetEntityId]      AND R26.[RelationshipTypeId] = 'ffd71f9e-7346-d12b-85d6-7c39f507b7bb')  LEFT OUTER JOIN dbo.BaseManagedEntity AS BME26       ON R26.[TargetEntityId] = BME26.BaseManagedEntityId WHERE (S.[ManagedTypeId] = 'a604b942-4c7b-2fb2-28dc-61dc6f465c68'      AND S.[IsDeleted] = 0 AND (BMES.LastModified > @Watermark      OR BME0.LastModified > @Watermark      OR BME1.LastModified > @Watermark      OR BME2.LastModified > @Watermark      OR BME3.LastModified > @Watermark      OR BME4.LastModified > @Watermark      OR BME5.LastModified > @Watermark      OR BME6.LastModified > @Watermark      OR BME7.LastModified > @Watermark      OR BME8.LastModified > @Watermark      OR BME9.LastModified > @Watermark      OR BME10.LastModified > @Watermark      OR BME11.LastModified > @Watermark      OR BME12.LastModified > @Watermark      OR BME13.LastModified > @Watermark      OR BME14.LastModified > @Watermark      OR BME15.LastModified > @Watermark      OR BME16.LastModified > @Watermark      OR BME17.LastModified > @Watermark      OR BME18.LastModified > @Watermark      OR BME19.LastModified > @Watermark      OR BME20.LastModified > @Watermark      OR BME21.LastModified > @Watermark      OR BME22.LastModified > @Watermark      OR BME23.LastModified > @Watermark      OR BME24.LastModified > @Watermark      OR BME25.LastModified > @Watermark      OR BME26.LastModified > @Watermark))) AS PC LEFT OUTER JOIN ( -- MTV_Select_943d298f-d79a-7a29-a335-8833e582d252    SELECT [SourceView].[Id] AS [Id], [MTV_System$User].[BaseManagedEntityId] FROM ( SELECT  [BaseManagedEntityId], [DisplayName], [AssetStatus_B6E7674B_684A_040D_30B8_D1B42CCB3BC6], [BusinessPhone_DF56B912_F9E0_3565_4228_086CEABE35C2], [BusinessPhone2_0612ADE9_6913_10D9_4B12_82B2110BCBFB], [City_363F9AB4_DE91_69F0_854F_5F577324A353], [Company_8CD345AC_E9BC_E5FE_88BA_D281FC29637D], [Country_CE01FBF1_27FB_DD1E_7EE4_7E9EE3F635C8], [Department_312201FE_C1B3_E95A_01DF_E132E9BD3EC9], [Domain_E36D56F2_AD60_E76E_CD5D_9F7AB51AD395], [EmployeeId_0743124F_168A_95A0_1F99_7B26AF587F50], [Fax_60125C1D_A052_B038_3428_880837885320], [FirstName_4424C8D5_9E30_E87D_9124_1816663FAFFC], [HomePhone_FDDA48C4_C220_725E_3F2E_32658EFD53E9], [HomePhone2_F9BE9B12_1F88_D35A_2AC6_A6B1049FB80A], [Initials_5777D276_95A6_4949_1775_A2D548D9B474], [LastName_651E2AAF_6AA9_9423_9D90_4F150DB24C0D], [Mobile_3A783612_39EC_94B5_E71D_2D4C71B3C883], [Notes_5CFC0E2A_AB82_5830_D4BB_0596CBED1984], [ObjectStatus_4AE3E5FE_BC03_1336_0A45_80BF58DEE57B], [Office_E56FF064_8BE8_C0DF_B41D_BB567F74AD7F], [Pager_E79D9580_9319_B275_9825_FD202D9C38E3], [State_07DB7E81_22E2_F883_E029_CBEF1B921EA6], [StreetAddress_C1935911_F3AB_8FF6_3DF5_76D73894C682], [Title_9FC4484D_A0D6_886A_9FB4_5C29E0172EC9], [UserName_6AF77E23_669B_123F_B392_323C17097BBD], [Zip_659D90A7_FAB7_6AF4_1B08_1D78B2A32598], [DistinguishedName_CDBAEFE6_2197_3685_EA23_CAEB31D4DDFC], [FQDN_3F0E386D_5F63_F206_46AB_DA9DBE372942], [ObjectGuid_8F760528_A519_ED48_891C_329F5CE7C62B], [OrganizationalUnit_13D8EA29_A659_92AE_C78F_8047469D8C96], [SID_2B788C53_3ACE_8BAE_3AFE_0941D0147BA4], [UPN_7641DFF7_7A20_DC04_FC1C_B6FA8715DA02] FROM [dbo].[MTV_System$Domain$User]) AS MTV_System$User  INNER JOIN dbo.EnterpriseManagementObjectView AS SourceView       ON [MTV_System$User].[BaseManagedEntityId] = [SourceView].[Id]   ) AS SubqueryJoin0_0 ON SubqueryJoin0_0.[BaseManagedEntityId] = [PC].[T2]  LEFT OUTER JOIN ( -- MTV_Select_943d298f-d79a-7a29-a335-8833e582d252    SELECT [SourceView].[Id] AS [Id], [MTV_System$User].[BaseManagedEntityId] FROM ( SELECT  [BaseManagedEntityId], [DisplayName], [AssetStatus_B6E7674B_684A_040D_30B8_D1B42CCB3BC6], [BusinessPhone_DF56B912_F9E0_3565_4228_086CEABE35C2], [BusinessPhone2_0612ADE9_6913_10D9_4B12_82B2110BCBFB], [City_363F9AB4_DE91_69F0_854F_5F577324A353], [Company_8CD345AC_E9BC_E5FE_88BA_D281FC29637D], [Country_CE01FBF1_27FB_DD1E_7EE4_7E9EE3F635C8], [Department_312201FE_C1B3_E95A_01DF_E132E9BD3EC9], [Domain_E36D56F2_AD60_E76E_CD5D_9F7AB51AD395], [EmployeeId_0743124F_168A_95A0_1F99_7B26AF587F50], [Fax_60125C1D_A052_B038_3428_880837885320], [FirstName_4424C8D5_9E30_E87D_9124_1816663FAFFC], [HomePhone_FDDA48C4_C220_725E_3F2E_32658EFD53E9], [HomePhone2_F9BE9B12_1F88_D35A_2AC6_A6B1049FB80A], [Initials_5777D276_95A6_4949_1775_A2D548D9B474], [LastName_651E2AAF_6AA9_9423_9D90_4F150DB24C0D], [Mobile_3A783612_39EC_94B5_E71D_2D4C71B3C883], [Notes_5CFC0E2A_AB82_5830_D4BB_0596CBED1984], [ObjectStatus_4AE3E5FE_BC03_1336_0A45_80BF58DEE57B], [Office_E56FF064_8BE8_C0DF_B41D_BB567F74AD7F], [Pager_E79D9580_9319_B275_9825_FD202D9C38E3], [State_07DB7E81_22E2_F883_E029_CBEF1B921EA6], [StreetAddress_C1935911_F3AB_8FF6_3DF5_76D73894C682], [Title_9FC4484D_A0D6_886A_9FB4_5C29E0172EC9], [UserName_6AF77E23_669B_123F_B392_323C17097BBD], [Zip_659D90A7_FAB7_6AF4_1B08_1D78B2A32598], [DistinguishedName_CDBAEFE6_2197_3685_EA23_CAEB31D4DDFC], [FQDN_3F0E386D_5F63_F206_46AB_DA9DBE372942], [ObjectGuid_8F760528_A519_ED48_891C_329F5CE7C62B], [OrganizationalUnit_13D8EA29_A659_92AE_C78F_8047469D8C96], [SID_2B788C53_3ACE_8BAE_3AFE_0941D0147BA4], [UPN_7641DFF7_7A20_DC04_FC1C_B6FA8715DA02] FROM [dbo].[MTV_System$Domain$User]) AS MTV_System$User  INNER JOIN dbo.EnterpriseManagementObjectView AS SourceView       ON [MTV_System$User].[BaseManagedEntityId] = [SourceView].[Id]   ) AS SubqueryJoin1_0 ON SubqueryJoin1_0.[BaseManagedEntityId] = [PC].[T0]  LEFT OUTER JOIN ( -- MTV_Select_a604b942-4c7b-2fb2-28dc-61dc6f465c68    SELECT DISTINCT [MTV_System$WorkItem$Incident].[Title_9691DD10_7211_C835_E3E7_6B38AF8B8104], [MTV_System$WorkItem$Incident].[Status_785407A9_729D_3A74_A383_575DB0CD50ED], [MTV_System$WorkItem$Incident].[BaseManagedEntityId] FROM dbo.MTV_System$WorkItem$Incident AS MTV_System$WorkItem$Incident    ) AS SubqueryJoin2_0 ON SubqueryJoin2_0.[BaseManagedEntityId] = [PC].[S]   WHERE ( ( SubqueryJoin0_0.[Id] =  @Id0 OR SubqueryJoin1_0.[Id] =  @Id1 )  AND ( SubqueryJoin2_0.[Status_785407A9_729D_3A74_A383_575DB0CD50ED] =  @Status_785407A9_729D_3A74_A383_575DB0CD50ED0 OR SubqueryJoin2_0.[Status_785407A9_729D_3A74_A383_575DB0CD50ED] =  @Status_785407A9_729D_3A74_A383_575DB0CD50ED1 )  )   ORDER BY [SubqueryJoin2_0].[Title_9691DD10_7211_C835_E3E7_6B38AF8B8104] ASC OPTION (KEEP PLAN)