diff options
| author |  Vitaly Takmazov | 2019-04-29 16:25:25 +0300 |
|---|---|---|
| committer | Vitaly Takmazov | 2019-04-29 16:25:25 +0300 |
| commit | 465e5571f8af340a3611290eba01c2b1d9fd22cd (patch) | |
| tree | f412b57c55a1fabd422fc3b090bef64f3a814a3d /src/main/java | |
| parent | c3a9365645ec94d5b7c9778ab32c93e5eb4be5f6 (diff) | |
Fit netneladno.ru queries
Diffstat (limited to 'src/main/java')
| -rw-r--r-- | src/main/java/com/juick/service/MessagesServiceImpl.java | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/main/java/com/juick/service/MessagesServiceImpl.java b/src/main/java/com/juick/service/MessagesServiceImpl.java index b1cb03d9..a1ba26ac 100644 --- a/src/main/java/com/juick/service/MessagesServiceImpl.java +++ b/src/main/java/com/juick/service/MessagesServiceImpl.java @@ -803,7 +803,7 @@ public class MessagesServiceImpl extends BaseJdbcService implements MessagesServ "SELECT message_id FROM " + "(SELECT message_id FROM favorites " + " INNER JOIN users" + - " ON messages.user_id = users.id" + + " ON favorites.user_id = users.id" + " WHERE user_id = :uid AND users.banned = 0" + (before > 0 ? " AND message_id < :before " : StringUtils.EMPTY) + |