From c8d3c0eef6d4fa397c2ffb9a124c6408cfdc8131 Mon Sep 17 00:00:00 2001 From: sostler Date: Sat, 8 May 2010 16:55:57 -0400 Subject: Updated zoeee query --- src/site.clj | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/src/site.clj b/src/site.clj index a7327c8..baec484 100644 --- a/src/site.clj +++ b/src/site.clj @@ -381,7 +381,8 @@ SELECT m.content, m.message_id, m.created_on, FROM messages m, users u,rooms r WHERE u.nick = 'zoeee' AND m.user_id = u.user_id -AND m.created_on::date = '20100430' +AND m.message_id <= 519399 +AND m.message_id >= 517713 AND m.is_image = true AND m.room_id = r.room_id AND r.room_id = 1 -- cgit v1.2.3-70-g09d2