diff options
author | Yorhel <git@yorhel.nl> | 2022-04-19 10:08:56 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2022-04-19 10:08:58 +0200 |
commit | 347504949bb8c776d78757719ddc202881b4b199 (patch) | |
tree | 7de6437d9292925af1b4c42544c1bb361788df18 | |
parent | 6a1ec1d672dce59ba658ea90626cee95b39299de (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.pm | 4 |
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, }, |