diff options
Diffstat (limited to 'src')
| -rw-r--r-- | src/main/java/com/juick/service/MessagesServiceImpl.java | 34 |
1 files changed, 7 insertions, 27 deletions
diff --git a/src/main/java/com/juick/service/MessagesServiceImpl.java b/src/main/java/com/juick/service/MessagesServiceImpl.java index 8a0f9ecf..b0e365f8 100644 --- a/src/main/java/com/juick/service/MessagesServiceImpl.java +++ b/src/main/java/com/juick/service/MessagesServiceImpl.java @@ -790,35 +790,15 @@ public class MessagesServiceImpl extends BaseJdbcService implements MessagesServ OR EXISTS (SELECT 1 from users u WHERE u.banned = 1 and u.id = replies.user_id and u.id <> :uid)) UNION ALL SELECT replies.message_id, replies.reply_id FROM replies INNER JOIN banned ON banned.reply_id = replies.replyto AND replies.reply_id != replies.replyto AND banned.message_id=replies.message_id - WHERE replies.message_id IN (:ids)) - SELECT messages.message_id, - 0 as rid, - 0 as replyto, - messages.user_id, - users.nick, - users.banned as usr_banned, - messages.ts, - messages.readonly, - messages.privacy, - 1.*messages.replies-COUNT(DISTINCT banned.reply_id) as replies, - messages.attach, - COUNT(DISTINCT favorites.user_id) AS likes, - messages.hidden, - '' as tags, - messages.repliesby, - COALESCE(messages.txt, '') txt, '' as q, - messages.updated, - 0 as to_uid, - NULL as to_name, - messages.updated_at, - '' as m_user_uri, - '' as to_uri, - '' as msg_reply_uri, - 0 as html, + WHERE replies.message_id IN (:ids)) SELECT messages.message_id, 0 as rid, 0 as replyto, messages.user_id, + users.nick, users.banned as usr_banned, messages.ts, messages.readonly, messages.privacy, + 1.*messages.replies-COUNT(DISTINCT banned.reply_id) as replies, messages.attach, + COUNT(DISTINCT favorites.user_id) AS likes, messages.hidden, '' as tags, messages.repliesby, + COALESCE(messages.txt, '') txt, '' as q, messages.updated, 0 as to_uid, NULL as to_name, + messages.updated_at, '' as m_user_uri, '' as to_uri, '' as msg_reply_uri, 0 as html, (1.*messages.replies - subscr_messages.last_read_rid) as unread, (SELECT CASE WHEN EXISTS(SELECT * from subscr_messages where message_id=messages.message_id and suser_id=:uid) THEN 1 ELSE 0 END) subscribed - FROM messages - INNER JOIN users ON messages.user_id=users.id LEFT JOIN subscr_messages + FROM messages INNER JOIN users ON messages.user_id=users.id LEFT JOIN subscr_messages ON messages.message_id=subscr_messages.message_id AND subscr_messages.suser_id=:uid LEFT JOIN favorites ON messages.message_id = favorites.message_id AND favorites.like_id=1 LEFT JOIN banned ON messages.message_id = banned.message_id |