From 3daf98ea8ee13a75fa5819fa90f24a7e095ed769 Mon Sep 17 00:00:00 2001
From: Vitaly Takmazov
Date: Mon, 11 Jul 2016 10:35:33 +0300
Subject: fix groups_pms query, part 2

---
 juick-core/src/main/java/com/juick/server/PMQueries.java | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'juick-core')

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 5f912028..875cbbd6 100644
--- a/juick-core/src/main/java/com/juick/server/PMQueries.java
+++ b/juick-core/src/main/java/com/juick/server/PMQueries.java
@@ -71,7 +71,7 @@ public class PMQueries {
         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 "
                 + "WHERE pm_streams.user_id_to=? "
-                + "ORDER BY unread DESC, lastmessage DESC LIMIT " + cnt, (rs, rowNum) -> {
+                + "ORDER BY pm_streams.unread DESC, pm_streams.lastmessage DESC LIMIT " + cnt, (rs, rowNum) -> {
             com.juick.User u = new com.juick.User();
             u.setUID(rs.getInt(1));
             u.setUName(rs.getString(2));
-- 
cgit v1.2.3