SELECT 
	Examinations.ExaminationDate, 
	Examinations.ExaminationInstitution, 
	Examinations.ExaminationPatientId, 
	Examinations.ExaminationModality, 		
	Examinations.ExaminationBodyPart, 
	Examinations.ExaminationDescription,
	Patients.PatientBirthdate, 
	Patients.PatientSex,
	Reports.ReportText, 
	Reports.ReportDate, 
	Reports.ReportDoctor, 
	Reports.ReportDate, 
	Reports.ReportFinalSignatureDate, 
	Reports.ReportFinalSignatureName, 
	Reports.ReportId,
	Reports.ReportModifiedDateUTC, 
	Reports.ReportPreliminarySignatureName, 				
	Reports.ReportPreliminarySignatureDate, 
	Reports.ReportReviewerName
FROM 
	Examinations INNER JOIN Patients ON Patients.PatientId = Examinations.ExaminationPatientId
 	INNER JOIN ExaminationReports ON ExaminationReports.ExaminationReportExaminationId = Examinations.ExaminationId
 	INNER JOIN Reports ON Reports.ReportId = ExaminationReports.ExaminationReportReportId
WHERE 
	Examinations.ExaminationModality='MR'
	AND Examinations.ExaminationDescription NOT LIKE '%Spectroscopy%'
	AND Examinations.ExaminationBodyPart LIKE '%brain%' 
		OR Examinations.ExaminationBodyPart LIKE '%head%'
		OR Examinations.ExaminationBodyPart LIKE '%neck%' 
		OR Examinations.ExaminationBodyPart LIKE '%orbit%'