summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2022-05-12 16:32:34 +0200
committerYorhel <git@yorhel.nl>2022-05-12 16:32:34 +0200
commit225e58b6226c33b4e3742230335c7033a78a2828 (patch)
treecf70ec9289882dc6ddd398e8f8107b7fe2ca4d1a
parent4723115c4071dde1f29a61e2772d54e74723b9e7 (diff)
Chars::Page: Do not fetch seiyuu from deleted VNs
-rw-r--r--lib/VNWeb/Chars/Page.pm3
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;
}