summaryrefslogtreecommitdiff
path: root/lib/VNDB/DB/Releases.pm
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2009-01-15 13:20:54 +0100
committerYorhel <git@yorhel.nl>2009-01-15 13:20:54 +0100
commitef276eff8d84a6e3076b75ca6830a87a6b62909a (patch)
tree18089a099923ca9f00ff6c6a3ce674035c4e2c1e /lib/VNDB/DB/Releases.pm
parent7fa831a278c6e0f8d42d44969b562c82ae717400 (diff)
Keep VN relations on r+ pages ordered by title
Diffstat (limited to 'lib/VNDB/DB/Releases.pm')
-rw-r--r--lib/VNDB/DB/Releases.pm3
1 files changed, 2 insertions, 1 deletions
diff --git a/lib/VNDB/DB/Releases.pm b/lib/VNDB/DB/Releases.pm
index cf077d0e..52fea2b0 100644
--- a/lib/VNDB/DB/Releases.pm
+++ b/lib/VNDB/DB/Releases.pm
@@ -69,7 +69,8 @@ sub dbReleaseGet {
FROM releases_vn rv
JOIN vn v ON v.id = rv.vid
JOIN vn_rev vr ON vr.id = v.latest
- WHERE rv.rid IN(!l)|,
+ WHERE rv.rid IN(!l)
+ ORDER BY vr.title|,
[ keys %r ]
)});
}