aboutsummaryrefslogtreecommitdiff
path: root/juick-core/src/main/java
diff options
context:
space:
mode:
authorGravatar Vitaly Takmazov2016-07-11 10:34:10 +0300
committerGravatar Vitaly Takmazov2016-07-11 10:34:10 +0300
commit74794a8fdab5be56b5e24372dfef46ef875b2986 (patch)
treef853fcf63ef92bab9c921ded58d188295188970f /juick-core/src/main/java
parent567e9a870645d527da95d07103dd0fce31f14585 (diff)
fix typo
Diffstat (limited to 'juick-core/src/main/java')
-rw-r--r--juick-core/src/main/java/com/juick/server/PMQueries.java2
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();