summaryrefslogtreecommitdiff
path: root/lib/VNDB
diff options
context:
space:
mode:
Diffstat (limited to 'lib/VNDB')
-rw-r--r--lib/VNDB/DB/Releases.pm3
1 files changed, 1 insertions, 2 deletions
diff --git a/lib/VNDB/DB/Releases.pm b/lib/VNDB/DB/Releases.pm
index 1a01f712..a2614ca8 100644
--- a/lib/VNDB/DB/Releases.pm
+++ b/lib/VNDB/DB/Releases.pm
@@ -59,8 +59,8 @@ sub dbReleaseGet {
!$o{id} && !$o{hidden_only} ? ( 'r.hidden = FALSE' => 0 ) : (),
$o{hidden_only} ? ('r.hidden = TRUE' => 1) : (),
$o{id} ? ( 'r.id = ?' => $o{id} ) : (),
- $o{vid} ? ( 'rv.vid IN(!l)' => [ ref $o{vid} ? $o{vid} : [$o{vid}] ] ) : (),
$o{pid} ? ( 'rp.pid = ?' => $o{pid} ) : (),
+ $o{vid} ? ( 'r.id IN(SELECT id FROM releases_vn WHERE vid IN(!l))' => [ ref $o{vid} ? $o{vid} : [$o{vid}] ] ) : (),
$self->dbReleaseFilters(%o),
);
@@ -78,7 +78,6 @@ sub dbReleaseGet {
}
my @join = (
- $o{vid} ? 'JOIN releases_vn rv ON rv.id = r.id' : (),
$o{pid} ? 'JOIN releases_producers rp ON rp.id = r.id' : (),
);