diff options
author | Yorhel <git@yorhel.nl> | 2022-11-26 08:18:28 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2022-11-26 08:18:30 +0100 |
commit | be8302bd0f99f2052fb8d87a5b16dcb40a80a542 (patch) | |
tree | 1910539a0ab94113e46529461b35edb0e78d3d3f | |
parent | b197a1ed6b507348706eb133ba71949af3268df5 (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.pm | 2 |
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 ' |