diff options
author | Yorhel <git@yorhel.nl> | 2015-11-02 20:36:40 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2015-11-02 20:36:40 +0100 |
commit | 052b78e84b4c7379f107cfaa5f9cede09b8b1b7b (patch) | |
tree | 7ec5333479ff8166ab28178501ff18ffa64a2712 /lib/VNDB/DB/VN.pm | |
parent | 333c6e35103584cb244f035ec217a82e77549b44 (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.pm | 2 |
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}; } |