diff options
-rw-r--r-- | util/dump.sql | 2 | ||||
-rw-r--r-- | util/updates/update_2.9.sql | 2 |
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; |