summaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
authorsostler <sbostler@gmail.com>2010-03-09 08:35:21 -0500
committersostler <sbostler@gmail.com>2010-03-09 08:35:21 -0500
commitfefadd9fb388e04c2ecc4b9757138c097572e2d1 (patch)
treeded0fc867304ac197822860e59ac157821a3877a /src
parent1a137049666feff73748600738276f1e5f683d5b (diff)
Tweak db
Diffstat (limited to 'src')
-rwxr-xr-xsrc/site.clj1
1 files changed, 1 insertions, 0 deletions
diff --git a/src/site.clj b/src/site.clj
index 5d5788f..e86825b 100755
--- a/src/site.clj
+++ b/src/site.clj
@@ -391,6 +391,7 @@
qry (str "SELECT u.user_id, u.nick, u.avatar, m.content "
"FROM users u, messages m "
"WHERE u.user_id in (" user-ids ") "
+ "AND m.user_id = u.user_id "
"AND m.created_on = (select max(created_on) from messages "
" where user_id = u.user_id)")]
(when (> (count user-ids) 0)