SELECT CR.Id_9A505725_E2F2_447F_271B_9B9F4F0D190C as Ticket, CR.Description_59B77FD5_FE0E_D2B5_D541_0EBBD1EC9A2B as Description, DSStatus.DisplayString as Status, DSUser.DisplayName as AssignedTo, DATEADD(Hour,-5,CR.CreatedDate_6258638D_B885_AB3C_E316_D00782B8F688) as CreatedDate, DATEADD(Hour,-5,CR.ScheduledStartDate_89429D01_365C_366D_FCDA_3198102B180C) as ScheduledStartDate, DATEADD(Hour,-5,CR.ScheduledEndDate_6FC72C26_565D_CB2A_BBAF_6A699C15FE99) as ScheduledEndDate, DATEADD(Hour,-5,CR.ScheduledDowntimeStartDate_9790A015_BFC5_DBC9_C159_2DAD93797C6C) as DowntimeStartDate, DATEADD(Hour,-5,CR.ScheduledDowntimeEndDate_9D6CD243_6F1E_AF87_92B2_3C95B91E69C5) as DowntimeEndDate, CR.IsDowntime_E06BAE83_23B7_E8DD_9056_D5A654C7D646 as Downtime, CR.Reason_C04D1AE8_9B61_DE9D_BA41_586D46AF4453 as Reason, CR.TestPlan_C41D99E7_65F5_E002_A474_9FE9B9816D33 as TestPlan, CR.BackoutPlan_AB639625_6D51_485F_C1C2_2FEBAF589DD8 as BackOutPlan, DSCategory.DisplayName as Category FROM Servicemanager.dbo.MT_System$WorkItem$ChangeRequest as CR --Join Category JOIN [Servicemanager].[dbo].[DisplayStringView] as DSCategory ON DSCategory.LTStringId = cr.Category_7B1892FE_108A_EC85_064D_7815C2DFC442 AND DSCategory.LanguageCode = 'enu' --Join Status LEFT OUTER JOIN ServiceManagement.dbo.DisplayString as DSStatus on CR.Status_72C1BC70_443C_C96F_A624_A94F1C857138 = DSStatus.ElementID --Join Assignee JOIN ServiceManager.dbo.Relationship as DSRelate on DSRelate.SourceEntityId = CR.BaseManagedEntityId and DSRelate.RelationshipTypeId = '15E577A3-6BF9-6713-4EAC-BA5A5B7C4722' JOIN ServiceManagement.dbo.CI$User as DSUser on DSUser.Id = DSRelate.TargetEntityId Where DSStatus.DisplayString NOT IN ('Closed','Cancelled','Failed','Completed') and CR.Id_9A505725_E2F2_447F_271B_9B9F4F0D190C Like 'CR%' and CR.Id_9A505725_E2F2_447F_271B_9B9F4F0D190C IN (Select ParentWorkItemId From ServiceManagement.dbo.Workitem --Join Status LEFT OUTER JOIN ServiceManagement.dbo.DisplayString as DSStatus2 on StatusId = DSStatus2.ElementID Where WorkItemId LIKE 'RA%' and DSStatus2.DisplayString = 'In Progress' and Title = 'Cab Review');