From fefadd9fb388e04c2ecc4b9757138c097572e2d1 Mon Sep 17 00:00:00 2001 From: sostler Date: Tue, 9 Mar 2010 08:35:21 -0500 Subject: Tweak db --- src/site.clj | 1 + 1 file changed, 1 insertion(+) (limited to 'src/site.clj') 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) -- cgit v1.2.3-70-g09d2