diff options
author | Yorhel <git@yorhel.nl> | 2022-05-12 16:32:34 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2022-05-12 16:32:34 +0200 |
commit | 225e58b6226c33b4e3742230335c7033a78a2828 (patch) | |
tree | cf70ec9289882dc6ddd398e8f8107b7fe2ca4d1a | |
parent | 4723115c4071dde1f29a61e2772d54e74723b9e7 (diff) |
Chars::Page: Do not fetch seiyuu from deleted VNs
-rw-r--r-- | lib/VNWeb/Chars/Page.pm | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/lib/VNWeb/Chars/Page.pm b/lib/VNWeb/Chars/Page.pm index b6ded0f0..4829fe54 100644 --- a/lib/VNWeb/Chars/Page.pm +++ b/lib/VNWeb/Chars/Page.pm @@ -9,8 +9,9 @@ sub enrich_seiyuu { enrich seiyuu => id => cid => sub { sql ' SELECT DISTINCT vs.cid, sa.id, sa.name, sa.original, vs.note FROM vn_seiyuu vs + ', $vid ? () : ('JOIN vn v ON v.id = vs.id'), ' JOIN staff_alias sa ON sa.aid = vs.aid - WHERE vs.cid IN', $_, $vid ? ('AND vs.id =', \$vid) : (), ' + WHERE ', $vid ? ('vs.id =', \$vid) : ('NOT v.hidden'), 'AND vs.cid IN', $_, ' ORDER BY sa.name' }, @chars; } |