summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/func.sql2
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