ON n.TimeDate BETWEEN l.TimeDate - INTERVAL 1 HOUR AND l.TimeDate + INTERVAL 1 HOUR