From 2e563514d4d3bd5f6ae325376d6c47671e9a474b Mon Sep 17 00:00:00 2001
From: Vitaly Takmazov
Date: Wed, 4 Jul 2018 15:39:01 +0300
Subject: do not show join all replies in CTEs

---
 juick-server/src/main/java/com/juick/service/MessagesServiceImpl.java | 3 ++-
 juick-server/src/main/java/com/juick/service/UserServiceImpl.java     | 3 ++-
 2 files changed, 4 insertions(+), 2 deletions(-)

(limited to 'juick-server/src/main/java/com/juick')

diff --git a/juick-server/src/main/java/com/juick/service/MessagesServiceImpl.java b/juick-server/src/main/java/com/juick/service/MessagesServiceImpl.java
index d68ef8dd..6c13190f 100644
--- a/juick-server/src/main/java/com/juick/service/MessagesServiceImpl.java
+++ b/juick-server/src/main/java/com/juick/service/MessagesServiceImpl.java
@@ -842,7 +842,8 @@ public class MessagesServiceImpl extends BaseJdbcService implements MessagesServ
                         "WHERE replies.message_id = :mid " +
                         "AND EXISTS (SELECT 1 FROM bl_users b WHERE b.user_id = :uid AND b.bl_user_id = replies.user_id) " +
                         "UNION ALL SELECT replies.reply_id, replies.user_id FROM replies " +
-                        "INNER JOIN banned ON banned.reply_id = replies.replyto ) " +
+                        "INNER JOIN banned ON banned.reply_id = replies.replyto " +
+                        "WHERE replies.message_id = :mid) " +
                         "SELECT replies.message_id as mid, replies.reply_id, replies.replyto, " +
                         "replies.user_id, users.nick, users.banned, " +
                         "replies.ts, " +
diff --git a/juick-server/src/main/java/com/juick/service/UserServiceImpl.java b/juick-server/src/main/java/com/juick/service/UserServiceImpl.java
index eca0c264..bc448151 100644
--- a/juick-server/src/main/java/com/juick/service/UserServiceImpl.java
+++ b/juick-server/src/main/java/com/juick/service/UserServiceImpl.java
@@ -458,7 +458,8 @@ public class UserServiceImpl extends BaseJdbcService implements UserService {
                         "WHERE replies.message_id = :mid " +
                         "AND EXISTS (SELECT 1 FROM bl_users b WHERE b.user_id = :uid AND b.bl_user_id = replies.user_id) " +
                         "UNION ALL SELECT replies.reply_id, replies.user_id FROM replies " +
-                        "INNER JOIN banned ON banned.reply_id = replies.replyto ) " +
+                        "INNER JOIN banned ON banned.reply_id = replies.replyto " +
+                        "WHERE replies.message_id = :mid) " +
                         "SELECT COUNT(reply_id) from replies " +
                         "WHERE replies.message_id = :mid " +
                         "AND replies.reply_id = :rid " +
-- 
cgit v1.2.3