summaryrefslogtreecommitdiff
path: root/lib/VNWeb
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2021-10-03 09:34:45 +0200
committerYorhel <git@yorhel.nl>2021-10-03 09:34:45 +0200
commit76805f1faa63a9b07e04bdb00f4c91a0953051b2 (patch)
treef7800c17eadf86d21472d9049a235511057242a1 /lib/VNWeb
parentb10dc978a01f07890e53322e04beffb525a9ac4a (diff)
Producers::Page: More consistent ordering of VNs
Diffstat (limited to 'lib/VNWeb')
-rw-r--r--lib/VNWeb/Producers/Page.pm4
1 files changed, 2 insertions, 2 deletions
diff --git a/lib/VNWeb/Producers/Page.pm b/lib/VNWeb/Producers/Page.pm
index 73b7f798..ad454fdf 100644
--- a/lib/VNWeb/Producers/Page.pm
+++ b/lib/VNWeb/Producers/Page.pm
@@ -72,7 +72,7 @@ sub rel_ {
FROM releases r
JOIN releases_producers rp ON rp.id = r.id
WHERE rp.pid =', \$p->{id}, ' AND NOT r.hidden
- ORDER BY r.released, r.id
+ ORDER BY r.released, r.title, r.id
');
enrich_extlinks r => $r;
enrich_release $r;
@@ -126,7 +126,7 @@ sub vns_ {
GROUP BY rv.vid
) rels(vid, developer, publisher, released) ON rels.vid = v.id
WHERE NOT v.hidden
- ORDER BY rels.released
+ ORDER BY rels.released, v.title
');
h1_ 'Visual Novels';