summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--util/dump.sql2
-rw-r--r--util/updates/update_2.9.sql2
2 files changed, 2 insertions, 2 deletions
diff --git a/util/dump.sql b/util/dump.sql
index a5451395..e0af79e8 100644
--- a/util/dump.sql
+++ b/util/dump.sql
@@ -481,7 +481,7 @@ BEGIN
SELECT v.uid, v.vid, sqrt(count(*))::real
FROM votes v
JOIN votes v2 ON v.uid = v2.uid AND v2.vote < v.vote
- WHERE v.uid NOT IN(SELECT id FROM users WHERE ign_votes)
+ JOIN users u ON u.id = v.uid AND NOT ign_votes
GROUP BY v.vid, v.uid;
CREATE OR REPLACE TEMP VIEW tmp_pop2 (vid, win) AS
SELECT vid, sum(rank) FROM tmp_pop1 GROUP BY vid;
diff --git a/util/updates/update_2.9.sql b/util/updates/update_2.9.sql
index d11a5eed..3b3e147d 100644
--- a/util/updates/update_2.9.sql
+++ b/util/updates/update_2.9.sql
@@ -64,7 +64,7 @@ BEGIN
SELECT v.uid, v.vid, sqrt(count(*))::real
FROM votes v
JOIN votes v2 ON v.uid = v2.uid AND v2.vote < v.vote
- WHERE v.uid NOT IN(SELECT id FROM users WHERE ign_votes)
+ JOIN users u ON u.id = v.uid AND NOT ign_votes
GROUP BY v.vid, v.uid;
CREATE OR REPLACE TEMP VIEW tmp_pop2 (vid, win) AS
SELECT vid, sum(rank) FROM tmp_pop1 GROUP BY vid;