select * from other_table where
event = 123 and(((begin_time1 < _time) and (_time <end_time1))
or ((begin_time2 < _time) and (_time <end_time2))
or ((begin_time3 < _time) and (_time <end_time3))
or …………)


不过这个SQL建议你不要执行了，效率不高，对于你来说，基本属于无法忍受的程度