好望角：
第二条语句是正确的，可惜时间段有重复，加上distinct又严重影响性能………………
[阅读: 334] 2010-03-18 10:51:10
select distinct * from other_table
from other_table t1, (select (_time - 60 * 1000) b, (_time + 60 * 1000) e from one_table where event = 123) t2
where t1._time between t2.b and t2.e
| -ICP -IDC -ISP |