diff options
| author | sostler <sbostler@gmail.com> | 2010-05-08 16:55:57 -0400 |
|---|---|---|
| committer | sostler <sbostler@gmail.com> | 2010-05-08 16:55:57 -0400 |
| commit | c8d3c0eef6d4fa397c2ffb9a124c6408cfdc8131 (patch) | |
| tree | e46b6abe882387d7cbc85a69d14ab1688c637030 | |
| parent | bbeeeaf191049ec1734846f782f89a3b5027c427 (diff) | |
Updated zoeee query
| -rw-r--r-- | src/site.clj | 3 |
1 files changed, 2 insertions, 1 deletions
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 |