From 9be74d0e4b5c62e54685483b132c0311bc8aed2a Mon Sep 17 00:00:00 2001
From: Vitaly Takmazov
Date: Thu, 19 May 2016 20:42:48 +0300
Subject: fix subscribers query

---
 src/main/java/com/juick/api/TelegramBotHook.java | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'src/main/java/com/juick')

diff --git a/src/main/java/com/juick/api/TelegramBotHook.java b/src/main/java/com/juick/api/TelegramBotHook.java
index 97418418..9a743bc1 100644
--- a/src/main/java/com/juick/api/TelegramBotHook.java
+++ b/src/main/java/com/juick/api/TelegramBotHook.java
@@ -186,7 +186,7 @@ public class TelegramBotHook {
     }
     private List<Long> getSubscribers(int uid) {
         return jdbc.queryForList("SELECT tg_id FROM telegram INNER JOIN subscr_users " +
-                "ON (subscr_users.user_id=? AND telegram.tg_id=subscr_users.suser_id)", Long.class, uid, uid);
+                "ON (subscr_users.user_id=? AND telegram.user_id=subscr_users.suser_id)", Long.class, uid, uid);
     }
     private List<Long> getSubscribersToComments(int mid, int ignore_uid) {
         return jdbc.queryForList("SELECT tg_id FROM telegram INNER JOIN subscr_messages " +
-- 
cgit v1.2.3