diff options
Diffstat (limited to 'util')
-rw-r--r-- | util/sql/func.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/util/sql/func.sql b/util/sql/func.sql index 6f51a6b2..3923ffb5 100644 --- a/util/sql/func.sql +++ b/util/sql/func.sql @@ -77,7 +77,7 @@ BEGIN -- the following queries only update rows with popularity > 0, so make sure to reset all rows first UPDATE vn SET c_popularity = NULL; CREATE OR REPLACE TEMP VIEW tmp_pop1 (uid, vid, rank) AS - SELECT v.uid, v.vid, sqrt(count(*))::real + SELECT v.uid, v.vid, count(*)::real ^ 0.36788 FROM votes v JOIN votes v2 ON v.uid = v2.uid AND v2.vote < v.vote JOIN users u ON u.id = v.uid AND NOT ign_votes |