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