SELECT
	CASE
		WHEN
			EventType.Name NOT IN ('Fault', 'RecloseIntoFault', 'Test') AND
			Event.StartTime > DATEADD(HOUR, -24, GETDATE())
		THEN 1
		ELSE 0
	END
FROM
	Event JOIN
	EventType ON Event.EventTypeID = EventType.ID
WHERE Event.ID = {0}