server: case-insensitive subscriptions command

1 files changed, 1 insertions, 1 deletions

diff --git a/juick-server-jdbc/src/main/java/com/juick/service/MessagesServiceImpl.java b/juick-server-jdbc/src/main/java/com/juick/service/MessagesServiceImpl.java
index b64d7fd9..b6a37883 100644
--- a/juick-server-jdbc/src/main/java/com/juick/service/MessagesServiceImpl.java
+++ b/juick-server-jdbc/src/main/java/com/juick/service/MessagesServiceImpl.java
@@ -217,7 +217,7 @@ public class MessagesServiceImpl extends BaseJdbcService implements MessagesServ
 
     @Transactional
     void updateRepliesBy(int mid) {
-        List<String> users = getJdbcTemplate().queryForList("SELECT DISTINCT users.nick FROM replies " +
+        List<String> users = getJdbcTemplate().queryForList("SELECT users.nick FROM replies " +
                 "INNER JOIN users ON replies.user_id=users.id WHERE replies.message_id=? " +
                 "GROUP BY replies.user_id ORDER BY COUNT(replies.reply_id) DESC LIMIT 5", String.class, mid);
         String result = users.stream().map(u -> "@" + u).collect(Collectors.joining(","));