summaryrefslogtreecommitdiff
path: root/lib/VNDB/DB/VN.pm
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2015-11-02 20:36:40 +0100
committerYorhel <git@yorhel.nl>2015-11-02 20:36:40 +0100
commit052b78e84b4c7379f107cfaa5f9cede09b8b1b7b (patch)
tree7ec5333479ff8166ab28178501ff18ffa64a2712 /lib/VNDB/DB/VN.pm
parent333c6e35103584cb244f035ec217a82e77549b44 (diff)
DB::VN: Fix dbVNHasStaff() query when VN has only seiyuu and no staff
Diffstat (limited to 'lib/VNDB/DB/VN.pm')
-rw-r--r--lib/VNDB/DB/VN.pm2
1 files changed, 1 insertions, 1 deletions
diff --git a/lib/VNDB/DB/VN.pm b/lib/VNDB/DB/VN.pm
index dba48e23..8f3bf913 100644
--- a/lib/VNDB/DB/VN.pm
+++ b/lib/VNDB/DB/VN.pm
@@ -347,7 +347,7 @@ sub dbVNHasChar {
sub dbVNHasStaff {
my($self, $vid) = @_;
return $self->dbRow(
- 'SELECT 1 AS exists FROM vn_staff vs FULL OUTER JOIN vn_seiyuu vsy ON vs.id = vsy.id WHERE vs.id = ?', $vid
+ 'SELECT 1 AS exists FROM vn_staff WHERE id = ? UNION ALL SELECT 1 FROM vn_seiyuu WHERE id = ? LIMIT 1', $vid, $vid
)->{exists};
}