用到的几个查询

ip_address like '%112.175%'

chatter_example like "%NICK%"

chatter_example like '%.bin%'

request_time>'2011-07-27 14:26:28' and loginfo like '%NICK%'

request_time>'2011-07-27 14:26:28' and loginfo like '%NICK%' and port<>3127 and port<>27374

request_time>'2011-05-16 11:21:10' and loginfo like '%NICK%' and request_time<'2011-05-16 11:51:33'

request_time>'2011-07-27 14:26:28' and chatter_example like '%.bin%'

request_time>'2011-07-27 14:26:28' and domain like '%co.cc'

request_time>'2011-05-31 17:48:02'

2011-6-13 10:23

2011-6-13 10:23

request_time>'2011-07-27 14:26:28' and request_time<'2011-6-13  10:24' and loginfo like '%NICK%' and port<>3127 and port<>27374

request_time>'2011-07-27 14:26:28' and loginfo like '%NICK%' and port<>3127 and port<>27374 and port=6667

request_time>'2011-07-27 14:26:28' and loginfo like '%NICK%' and port<>3127 and port<>27374 and port<>6667

request_time>'2011-07-27 14:26:28' and request_time<'2011-06-14' and loginfo like '%NICK%' and port<>3127 and port<>27374 and port<>6667