diff options
Diffstat (limited to 'src/main/java/com/juick/service/ChatServiceImpl.java')
| -rw-r--r-- | src/main/java/com/juick/service/ChatServiceImpl.java | 1 |
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=? " |