insert into #original_crystal (
    CallId
    ,CallOrigin 
    ,ReceivedDatetime 
(and some more fields)
)

SELECT
    Call_Fact.CallId
    ,Call_Fact.CallOrigin
    ,Call_Fact.ReceivedDatetime
(rest of select)
FROM
    { oj ((((((((((NHSD_Datamart.dbo.Call_Fact Call_Fact 
		INNER JOIN NHSD_Datamart.dbo.CallEvent_Fact CallEvent_Fact 
			ON Call_Fact.CallId = CallEvent_Fact.CallId)
		 LEFT OUTER JOIN NHSD_Datamart.dbo.DispositionFlag_Dim DispositionFlag_Dim 
			ON Call_Fact.FinalDispositionId = DispositionFlag_Dim.DispositionID)
		 LEFT OUTER JOIN NHSD_Datamart.dbo.Patient_Fact Patient_Fact 
			ON Call_Fact.PatientId = Patient_Fact.PatientId)
		 LEFT OUTER JOIN NHSD_Datamart.dbo.Protocol_Fact Protocol_Fact 
			ON Call_Fact.CallId = Protocol_Fact.CallId)
		 LEFT OUTER JOIN NHSD_Datamart.dbo.CallEventPppEnd_Fact CallEventPppEnd_Fact 
			ON Call_Fact.CallId = CallEventPppEnd_Fact.CallId)
		 LEFT OUTER JOIN NHSD_Datamart.dbo.v_EATHandlingTimesByCall v_EATHandlingTimesByCall 
			ON Call_Fact.CallId = v_EATHandlingTimesByCall.CallId)
		 LEFT OUTER JOIN NHSD_Datamart.dbo.v_TimeToStart v_TimeToStart 
			ON Call_Fact.CallId = v_TimeToStart.CallId)
		 LEFT OUTER JOIN NHSD_Datamart.dbo.Disposition_Dim Disposition_Dim 
			ON Call_Fact.FinalDispositionId = Disposition_Dim.DispositionID)
		 LEFT OUTER JOIN NHSD_Datamart.dbo.CallPriority_Dim CallPriority_Dim 
			ON Call_Fact.CallPriorityId = CallPriority_Dim.CallPriorityId)
		 LEFT OUTER JOIN NHSD_Datamart.dbo.CallEventType_Dim CallEventType_Dim 
			ON CallEvent_Fact.CallEventTypeId = CallEventType_Dim.CallEventTypeId)
		 LEFT OUTER JOIN NHSD_Datamart.dbo.CasUser_Dim CasUser_Dim 
			ON CallEvent_Fact.UserId = CasUser_Dim.UserId}    
WHERE
    CasUser_Dim.RemodifiedAt >= '3000-01-01 00:00:00.00'
    AND Call_Fact.SiteId not in (401,19) 
    AND CallEvent_Fact.CallEventTypeId IN (8,36,27,26,24,23,14,11) 
    AND CallEventType_Dim.CallTypeId = 1 
    AND CallPriority_Dim.RemodifiedAt >= '3000-01-01 00:00:00.00'
    AND Call_Fact.RemodifiedAt >= '3000-01-01 00:00:00.00'
    and ((COALESCE(Patient_Fact.GivenName, 'no link')) NOT LIKE '%test%' 
	AND (COALESCE(Patient_Fact.GivenName, 'no link')) NOT LIKE '%protocol%') 
	AND CallEventType_Dim.RemodifiedAt >= '3000-01-01 00:00:00.00'
	AND (COALESCE(Disposition_Dim.RemodifiedAt, '01-01-3000')) >= '3000-01-01 00:00:00.00'
	AND (COALESCE(Patient_Fact.RemodifiedAt, '01-01-3000')) >= '3000-01-01 00:00:00.00'
	AND Call_Fact.ReceivedDatetime between CAST(getdate()-3 as DATE) and CAST(getdate() as DATE)
--	AND Call_Fact.ReceivedDatetime between @start and @end