summaryrefslogtreecommitdiff
path: root/lib/VNDB/DB
diff options
context:
space:
mode:
authormorkt <>2015-02-04 12:43:02 +0100
committerYorhel <git@yorhel.nl>2015-02-04 12:43:02 +0100
commit9087dbb5c6fd238676347946918accc27a736201 (patch)
tree3bffb7568aefdac52a40c1639b91253183f62e0b /lib/VNDB/DB
parenta4873984865b95143a5b3c08d7ebc4b033a1787e (diff)
DB::Staff: Fix role filter bug
Diffstat (limited to 'lib/VNDB/DB')
-rw-r--r--lib/VNDB/DB/Staff.pm4
1 files changed, 2 insertions, 2 deletions
diff --git a/lib/VNDB/DB/Staff.pm b/lib/VNDB/DB/Staff.pm
index c8af54b3..b22b9538 100644
--- a/lib/VNDB/DB/Staff.pm
+++ b/lib/VNDB/DB/Staff.pm
@@ -38,8 +38,8 @@ sub dbStaffGet {
defined $o{gender} ? ( 'sr.gender IN(!l)' => [ ref $o{gender} ? $o{gender} : [$o{gender}] ]) : (),
defined $o{role} ? (
'('.join(' OR ',
- @roles ? ( 'EXISTS(SELECT 1 FROM vn_staff vs WHERE vs.aid = sa.id AND vs.role IN(!l))' ) : (),
- $seiyuu ? ( 'EXISTS(SELECT 1 FROM vn_seiyuu vsy WHERE vsy.aid = sa.id)' ) : ()
+ @roles ? ( 'EXISTS(SELECT 1 FROM vn_staff vs JOIN vn v ON v.latest = vs.vid WHERE vs.aid = sa.id AND vs.role IN(!l))' ) : (),
+ $seiyuu ? ( 'EXISTS(SELECT 1 FROM vn_seiyuu vsy JOIN vn v ON v.latest = vsy.vid WHERE vsy.aid = sa.id)' ) : ()
).')' => ( @roles ? [ \@roles ] : 1 ),
) : (),
$o{search} ?