summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2022-04-19 10:08:56 +0200
committerYorhel <git@yorhel.nl>2022-04-19 10:08:58 +0200
commit347504949bb8c776d78757719ddc202881b4b199 (patch)
tree7de6437d9292925af1b4c42544c1bb361788df18
parent6a1ec1d672dce59ba658ea90626cee95b39299de (diff)
VN::List: Order by popularity/rating by rank rather than cached value
Since the cached value is less precise. Fixes https://vndb.org/t950.1216
-rw-r--r--lib/VNWeb/VN/List.pm4
1 files changed, 2 insertions, 2 deletions
diff --git a/lib/VNWeb/VN/List.pm b/lib/VNWeb/VN/List.pm
index 5868731b..f1380cbf 100644
--- a/lib/VNWeb/VN/List.pm
+++ b/lib/VNWeb/VN/List.pm
@@ -44,7 +44,7 @@ sub TABLEOPTS {
name => 'Popularity score',
compat => 'pop',
sort_id => 3,
- sort_sql => 'v.c_popularity ?o, v.sorttitle',
+ sort_sql => 'v.c_pop_rank !o, v.sorttitle',
vis_id => 0,
vis_default => 1,
},
@@ -52,7 +52,7 @@ sub TABLEOPTS {
name => 'Bayesian rating',
compat => 'rating',
sort_id => 4,
- sort_sql => 'v.c_rating ?o NULLS LAST, v.sorttitle',
+ sort_sql => 'v.c_rat_rank !o NULLS LAST, v.sorttitle',
vis_id => 1,
vis_default => 1,
},