summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2022-11-26 08:18:28 +0100
committerYorhel <git@yorhel.nl>2022-11-26 08:18:30 +0100
commitbe8302bd0f99f2052fb8d87a5b16dcb40a80a542 (patch)
tree1910539a0ab94113e46529461b35edb0e78d3d3f
parentb197a1ed6b507348706eb133ba71949af3268df5 (diff)
Char::Page: Fix ordering of VNs/releases on instances as well
Fixes https://vndb.org/t2520.712
-rw-r--r--lib/VNWeb/Chars/Page.pm2
1 files changed, 1 insertions, 1 deletions
diff --git a/lib/VNWeb/Chars/Page.pm b/lib/VNWeb/Chars/Page.pm
index 075eab2f..e612ecce 100644
--- a/lib/VNWeb/Chars/Page.pm
+++ b/lib/VNWeb/Chars/Page.pm
@@ -69,7 +69,7 @@ sub fetch_chars {
JOIN vnt v ON v.id = cv.vid
LEFT JOIN releasest r ON r.id = cv.rid
WHERE cv.id IN', $_, $vid ? ('AND cv.vid =', \$vid) : (), '
- ORDER BY v.title, cv.vid, cv.rid NULLS LAST'
+ ORDER BY v.c_released, r.released, v.title, cv.vid, cv.rid NULLS LAST'
}, $l;
enrich traits => id => id => sub { sql '