diff options
-rw-r--r-- | sql/func.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/sql/func.sql b/sql/func.sql index 59623f3b..f3bb9add 100644 --- a/sql/func.sql +++ b/sql/func.sql @@ -190,7 +190,7 @@ BEGIN , COALESCE( SUM((CASE WHEN rv.vote THEN 1 ELSE -1 END)*(CASE WHEN rv.overrule THEN 10000 ELSE 1 END)) FILTER(WHERE NOT u.ign_votes AND (r2.id IS NULL OR rv.overrule)), - 0) < -10 + 0) < -1000 FROM reviews r LEFT JOIN reviews_votes rv ON rv.id = r.id LEFT JOIN users u ON u.id = rv.uid |