summaryrefslogtreecommitdiff
path: root/lib/VNDB/DB/Staff.pm
diff options
context:
space:
mode:
Diffstat (limited to 'lib/VNDB/DB/Staff.pm')
-rw-r--r--lib/VNDB/DB/Staff.pm1
1 files changed, 1 insertions, 0 deletions
diff --git a/lib/VNDB/DB/Staff.pm b/lib/VNDB/DB/Staff.pm
index 1c9438a0..798200f6 100644
--- a/lib/VNDB/DB/Staff.pm
+++ b/lib/VNDB/DB/Staff.pm
@@ -76,6 +76,7 @@ sub dbStaffGet {
JOIN vn_rev vr ON vr.id = vs.vid
JOIN vn v ON v.latest = vr.id
JOIN chars_rev cr ON cr.cid = vs.cid
+ JOIN chars c ON c.latest = cr.id
JOIN staff_alias sa ON vs.aid = sa.id
WHERE sa.rid IN(!l)
ORDER BY v.c_released ASC, vr.title ASC|, [ keys %r ]