aboutsummaryrefslogtreecommitdiff
path: root/juick-server/src/main/java/com
diff options
context:
space:
mode:
authorGravatar Vitaly Takmazov2016-12-19 14:14:30 +0300
committerGravatar Vitaly Takmazov2016-12-19 14:14:30 +0300
commit37235eb6f392005b91fcd005c9f645f4e36b82d1 (patch)
treee94c392a06a44590cb3f5f40ba87e091f08e239a /juick-server/src/main/java/com
parent1ad9b27b731dc42a53bf5e42c094f1b89dc5ccb6 (diff)
juick-server: fix getRecommendedUsers query
Diffstat (limited to 'juick-server/src/main/java/com')
-rw-r--r--juick-server/src/main/java/com/juick/service/ShowQueriesServiceImpl.java2
1 files changed, 1 insertions, 1 deletions
diff --git a/juick-server/src/main/java/com/juick/service/ShowQueriesServiceImpl.java b/juick-server/src/main/java/com/juick/service/ShowQueriesServiceImpl.java
index 50e0d243..2362e948 100644
--- a/juick-server/src/main/java/com/juick/service/ShowQueriesServiceImpl.java
+++ b/juick-server/src/main/java/com/juick/service/ShowQueriesServiceImpl.java
@@ -28,7 +28,7 @@ public class ShowQueriesServiceImpl extends BaseJdbcService implements ShowQueri
return Collections.emptyList();
return getNamedParameterJdbcTemplate().queryForList(
- "SELECT users.nick FROM subscr_users su1 INNER JOIN users u " +
+ "SELECT u.nick FROM subscr_users su1 INNER JOIN users u " +
"ON su1.user_id = u.id " +
"WHERE NOT EXISTS (SELECT 1 FROM subscr_users su2 WHERE su2.suser_id = :uid and su1.user_id = su2.user_id) " +
"AND EXISTS (SELECT 1 FROM subscr_users su3 WHERE su3.suser_id = :uid and su3.user_id = su1.suser_id ) " +