diff options
| -rw-r--r-- | juick-core/src/main/java/com/juick/server/PMQueries.java | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/juick-core/src/main/java/com/juick/server/PMQueries.java b/juick-core/src/main/java/com/juick/server/PMQueries.java index fa1dd05f..5f912028 100644 --- a/juick-core/src/main/java/com/juick/server/PMQueries.java +++ b/juick-core/src/main/java/com/juick/server/PMQueries.java @@ -69,7 +69,7 @@ public class PMQueries { public static List<User> getPMLastConversationsUsers(JdbcTemplate sql, int uid, int cnt) { return sql.query("SELECT pm_streams.user_id, users.nick, pm_streams.unread FROM pm_streams " - + "INNER JOIN users ON users.id = pm_streams.user_id" + + "INNER JOIN users ON users.id = pm_streams.user_id " + "WHERE pm_streams.user_id_to=? " + "ORDER BY unread DESC, lastmessage DESC LIMIT " + cnt, (rs, rowNum) -> { com.juick.User u = new com.juick.User(); |