From 665d678e6df40d703f523acfe8c89a832fcd53d9 Mon Sep 17 00:00:00 2001 From: Someone Date: Sun, 21 Mar 2021 02:27:57 +0100 Subject: [PATCH] mattermost_awards/main.py --- mattermost_awards/main.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/mattermost_awards/main.py b/mattermost_awards/main.py index 30abee2..1884822 100755 --- 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 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 * """) -- 2.43.0