summaryrefslogtreecommitdiff
path: root/lib
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2015-01-02 11:04:50 +0100
committerYorhel <git@yorhel.nl>2015-01-02 11:04:50 +0100
commitdf8e9f2354f6f321975020728f5b664b92b2142b (patch)
tree030dac1091274bd0bfde588bde68ae51e6268451 /lib
parent228cb96969a33a60c40dd4991a394460652010af (diff)
staff: Fix duplicate listing of seiyuu for chars with multiple releases
This unfortunately means I had to remove the order-by-character-role feature. It's possible to get that back, but it's not quite as trivial.
Diffstat (limited to 'lib')
-rw-r--r--lib/VNDB/DB/VN.pm6
1 files changed, 3 insertions, 3 deletions
diff --git a/lib/VNDB/DB/VN.pm b/lib/VNDB/DB/VN.pm
index 9ba27bbd..e08b85e3 100644
--- a/lib/VNDB/DB/VN.pm
+++ b/lib/VNDB/DB/VN.pm
@@ -169,12 +169,12 @@ sub dbVNGet {
JOIN vn_rev vr ON vr.id = vs.vid
JOIN staff_alias sa ON vs.aid = sa.id
JOIN staff_rev sr ON sr.id = sa.rid
- JOIN staff s ON sr.id = s.latest
+ JOIN staff s ON s.id = sr.sid AND sr.id = s.latest
JOIN chars c ON c.id = vs.cid
JOIN chars_rev cr ON cr.id = c.latest
- JOIN chars_vns cv ON cv.cid = cr.id AND cv.vid = vr.vid
WHERE s.hidden = FALSE AND vs.vid IN(!l)
- ORDER BY cv.role, cr.name|,
+ AND cr.id IN(SELECT cv.cid FROM chars_vns cv WHERE cv.vid = vr.vid AND cv.cid = cr.id)
+ ORDER BY cr.name|,
[ keys %r ]
)});
}