summaryrefslogtreecommitdiff
path: root/lib/VNDB/DB/VN.pm
diff options
context:
space:
mode:
Diffstat (limited to 'lib/VNDB/DB/VN.pm')
-rw-r--r--lib/VNDB/DB/VN.pm4
1 files changed, 2 insertions, 2 deletions
diff --git a/lib/VNDB/DB/VN.pm b/lib/VNDB/DB/VN.pm
index edb55377..9ba27bbd 100644
--- a/lib/VNDB/DB/VN.pm
+++ b/lib/VNDB/DB/VN.pm
@@ -159,7 +159,7 @@ sub dbVNGet {
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
- WHERE vs.vid IN(!l)
+ WHERE s.hidden = FALSE AND vs.vid IN(!l)
ORDER BY vs.role ASC, sa.name ASC|,
[ keys %r ]
)});
@@ -173,7 +173,7 @@ sub dbVNGet {
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 vs.vid IN(!l)
+ WHERE s.hidden = FALSE AND vs.vid IN(!l)
ORDER BY cv.role, cr.name|,
[ keys %r ]
)});