diff options
author | Yorhel <git@yorhel.nl> | 2015-11-14 01:27:40 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2015-11-14 01:27:40 +0100 |
commit | d5213564860202fb19ab475caf40be988cdac9c3 (patch) | |
tree | 84c92c1e80ff9ecdff741a1834ea0905385bc63f /lib/VNDB/DB/VN.pm | |
parent | 1e97c0405a0cacb05d9d70429d7e7969e231b786 (diff) |
DB::VN: Fix undeterministic ordering on tag score in VN listings
Diffstat (limited to 'lib/VNDB/DB/VN.pm')
-rw-r--r-- | lib/VNDB/DB/VN.pm | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/lib/VNDB/DB/VN.pm b/lib/VNDB/DB/VN.pm index 8f3bf913..f7c2dc94 100644 --- a/lib/VNDB/DB/VN.pm +++ b/lib/VNDB/DB/VN.pm @@ -110,7 +110,7 @@ sub dbVNGet { pop => 'v.c_popularity %s NULLS LAST', rating => 'v.c_rating %s NULLS LAST', title => 'v.title %s', - tagscore => 'tagscore %s', + tagscore => 'tagscore %s, v.title ASC', rand => 'RANDOM()', }->{$o{sort}}, $o{reverse} ? 'DESC' : 'ASC'; |