All pastes #797081 Raw Edit

Anonymous

public text v1 · immutable
#797081 ·published 2007-11-25 19:13 UTC
rendered paste body
Search results:
AND ( nick REGEXP 'DRJ' )You searched for messages that match the regular expression pie10170 10192 starting on 11/04/2007 and ending on tomorrow in channel #defocus.
SELECT * FROM searchy WHERE message REGEXP 'pie' AND channel REGEXP '#defocus$' AND ( nick REGEXP 'DRJ' ) AND mdate BETWEEN 10170 AND 10192 ORDER BY mdate
[11/18/2007 14:40:33] 	#defocus	<DrJ> 	ACTION walks by
[11/18/2007 14:40:33] 	#defocus	<DrJ> 	with pie
[11/18/2007 16:20:47] 	#defocus	<DrJ> 	WHO WANTS PIE!
[11/18/2007 16:23:05] 	#defocus	<DrJ> 	ACTION hands l1s a slice of pie
[11/23/2007 18:41:11] 	#defocus	<DrJ> 	I
[11/23/2007 18:41:11] 	#defocus	<DrJ> 	LIKE
[11/23/2007 18:41:11] 	#defocus	<DrJ> 	PIE
[11/24/2007 00:54:17] 	#defocus	<DrJ> 	I
[11/24/2007 00:54:25] 	#defocus	<DrJ> 	LIKE
[11/24/2007 00:54:25] 	#defocus	<DrJ> 	PIE
[11/24/2007 18:00:34] 	#defocus	<DrJ> 	I like pie
[11/24/2007 18:00:43] 	#defocus	<DrJ> 	I think you should have some pie
[11/24/2007 18:00:43] 	#defocus	<DrJ> 	ACTION goes to get some pie
[11/24/2007 19:34:19] 	#defocus	<DrJ> 	ty
[11/24/2007 19:34:27] 	#defocus	<DrJ> 	ACTION had a little too much pie
[11/25/2007 11:03:15] 	#defocus	<DrJ> 	ACTION goes to get some pie
[11/25/2007 11:11:02] 	#defocus	<DrJ> 	no
[11/25/2007 11:11:02] 	#defocus	<DrJ> 	no
[11/25/2007 11:11:02] 	#defocus	<DrJ> 	no
[11/25/2007 11:11:02] 	#defocus	<DrJ> 	no
[11/25/2007 11:11:02] 	#defocus	<DrJ> 	we are out of pie
[11/25/2007 11:11:19] 	#defocus	<DrJ> 	ACTION grabs a rock
[11/26/2007 03:03:36] 	#defocus	<DrJ> 	---------------------------PIE---------------------------PIE---------------------------PIE---------------------------PIE---------------------------PIE---------------------------PIE---------------------------PIE---------------------------PIE---------------------------PIE---------------------------PIE---------------------------PIE---------------------------PIE---------------------------PIE---------------------------PIE---------------------------
[11/26/2007 03:16:33] 	#defocus	<DrJ> 	I just had a slice of pie
[11/26/2007 03:16:33] 	#defocus	<DrJ> 	so I know a lot
[11/26/2007 18:46:47] 	#defocus	<DrJ> 	---------------------------PIE---------------------------PIE---------------------------PIE---------------------------PIE---------------------------PIE---------------------------PIE---------------------------PIE---------------------------PIE---------------------------PIE---------------------------PIE---------------------------PIE---------------------------PIE---------------------------PIE---------------------------PIE---------------------------