diff options
Diffstat (limited to 'lib/VNDB/DB/Affiliates.pm')
-rw-r--r-- | lib/VNDB/DB/Affiliates.pm | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/lib/VNDB/DB/Affiliates.pm b/lib/VNDB/DB/Affiliates.pm index 51f8c2dc..94dfd198 100644 --- a/lib/VNDB/DB/Affiliates.pm +++ b/lib/VNDB/DB/Affiliates.pm @@ -23,12 +23,12 @@ sub dbAffiliateGet { defined($o{hidden}) ? ('!s af.hidden' => $o{hidden} ? '' : 'NOT') : (), ); - my $join = $o{what} ? 'JOIN releases r ON r.id = af.rid JOIN releases_rev rr ON rr.id = r.latest' : ''; - my $select = $o{what} ? ', rr.title' : ''; + my $join = $o{what} ? 'JOIN releases r ON r.id = af.rid' : ''; + my $select = $o{what} ? ', r.title' : ''; my $order = sprintf { id => 'af.id %s', - rel => 'rr.title %s', + rel => 'r.title %s', prio => 'af.priority %s', url => 'af.url %s', lastfetch => 'af.lastfetch %s', |