From 8289a0b1097f02a99d62f4f7750e6b46a54a54fc Mon Sep 17 00:00:00 2001 From: Vitaly Takmazov Date: Fri, 9 Feb 2024 16:02:43 +0300 Subject: Append IDEA code suggestions --- src/main/java/com/juick/service/ChatServiceImpl.java | 1 - 1 file changed, 1 deletion(-) (limited to 'src/main/java/com/juick/service/ChatServiceImpl.java') diff --git a/src/main/java/com/juick/service/ChatServiceImpl.java b/src/main/java/com/juick/service/ChatServiceImpl.java index c0d2f17b..4247e49a 100644 --- a/src/main/java/com/juick/service/ChatServiceImpl.java +++ b/src/main/java/com/juick/service/ChatServiceImpl.java @@ -47,7 +47,6 @@ public class ChatServiceImpl extends BaseJdbcService implements ChatService { return getJdbcTemplate().query( "SELECT l.user_id, users.nick, l.last, pm.txt FROM pm " + "INNER JOIN users ON users.id = pm.user_id " - + "" + "INNER JOIN (SELECT user_id, MAX(ts) AS last FROM pm " + "WHERE user_id_to=? GROUP BY user_id) l ON l.last = pm.ts " + "WHERE pm.user_id_to=? " -- cgit v1.2.3