summaryrefslogtreecommitdiff
path: root/lib/VNDB/DB
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2015-11-14 01:27:40 +0100
committerYorhel <git@yorhel.nl>2015-11-14 01:27:40 +0100
commitd5213564860202fb19ab475caf40be988cdac9c3 (patch)
tree84c92c1e80ff9ecdff741a1834ea0905385bc63f /lib/VNDB/DB
parent1e97c0405a0cacb05d9d70429d7e7969e231b786 (diff)
DB::VN: Fix undeterministic ordering on tag score in VN listings
Diffstat (limited to 'lib/VNDB/DB')
-rw-r--r--lib/VNDB/DB/VN.pm2
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';