mattermost_awards/main.py

diff --git a/mattermost_awards/main.py b/mattermost_awards/main.py
index 30abee2fbe4831e034981d2b5f9d07a238826dfd..1884822d0ff021afd921a44900a52dd39e0e7501 100755 (executable)
--- a/mattermost_awards/main.py
+++ b/mattermost_awards/main.py
@@ -49,7 +49,7 @@ def main():
         WHERE (props='' OR props='{}' OR props='{"disable_group_highlight":true}') AND posts.id in (SELECT postid FROM (
             SELECT count(*) AS cnt, postid, channels.id, posts.userid FROM reactions
             JOIN posts ON (postid=posts.id) JOIN channels ON (posts.channelid=channels.id) left JOIN teams ON (teams.id=channels.teamid)
         WHERE (props='' OR props='{}' OR props='{"disable_group_highlight":true}') AND posts.id in (SELECT postid FROM (
             SELECT count(*) AS cnt, postid, channels.id, posts.userid FROM reactions
             JOIN posts ON (postid=posts.id) JOIN channels ON (posts.channelid=channels.id) left JOIN teams ON (teams.id=channels.teamid)

-            WHERE posts.deleteat = '0' AND channels.type='O' AND channels.id NOT IN ('4rxjday69jbj8pe5pdcx4ezesr') AND channels.id IN ('9twh9scp47g57dgjat61skni5w','6ry6x1jg73nsfpggpcudiw65hh') AND posts.createat > extract(epoch FROM (NOW() - INTERVAL '1 day'))*1000
+            WHERE posts.deleteat = '0' AND channels.type='O' AND channels.id NOT IN ('4rxjday69jbj8pe5pdcx4ezesr') AND posts.createat > extract(epoch FROM (NOW() - INTERVAL '1 day'))*1000

             GROUP BY postid, channels.id, posts.userid
           ) AS a WHERE cnt >10) RETURNING *
         """)
             GROUP BY postid, channels.id, posts.userid
           ) AS a WHERE cnt >10) RETURNING *
         """)