From: Ian Beckwith <ianb@erislabs.net>
Date: Thu, 23 Sep 2010 23:57:39 +0000 (+0100)
Subject: fix album_tracks
X-Git-Tag: debian/1.0-1~185
X-Git-Url: http://erislabs.net/gitweb/?p=id3fs.git;a=commitdiff_plain;h=23926a46e17e555219eb3901573ad0e8c0cf248a

fix album_tracks
---

diff --git a/lib/ID3FS/DB.pm b/lib/ID3FS/DB.pm
index f2151e4..5217484 100644
--- a/lib/ID3FS/DB.pm
+++ b/lib/ID3FS/DB.pm
@@ -267,7 +267,7 @@ sub album_tracks
 {
     my($self, $album_id)=@_;
     my $sql=("SELECT files.name FROM files\n\t" .
-	     "INNER JOIN files_x_albums ON albums.id=files_x_albums.albums_id\n\t" .
+	     "INNER JOIN files_x_albums ON files.id=files_x_albums.files_id\n\t" .
 	     "INNER JOIN albums ON albums.id=files_x_albums.albums_id\n\t" .
 	     "WHERE albums.id=?\n\t" .
 	     "GROUP BY files.name\n");