aboutsummaryrefslogtreecommitdiff
path: root/src/main/java/com/juick/service/ChatServiceImpl.java
diff options
context:
space:
mode:
authorGravatar Vitaly Takmazov2024-02-09 16:02:43 +0300
committerGravatar Vitaly Takmazov2024-02-09 16:02:43 +0300
commit8289a0b1097f02a99d62f4f7750e6b46a54a54fc (patch)
treebe0e04b409757be58d5a39fbde93ce3d96b02142 /src/main/java/com/juick/service/ChatServiceImpl.java
parentb11525961a8bf68355f3e4728375b209a91f6787 (diff)
Append IDEA code suggestions
Diffstat (limited to 'src/main/java/com/juick/service/ChatServiceImpl.java')
-rw-r--r--src/main/java/com/juick/service/ChatServiceImpl.java1
1 files changed, 0 insertions, 1 deletions
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=? "