[banshee/stable] Change the count query to avoid an infinite loop (BGO #548131).

[Gabriel Burt <gburt src gnome org>]

commit 2b8359d96cddbc7e1fed54dba8adf2671c4424ac
Author: Gabriel Burt <gabriel burt gmail com>
Date:   Thu May 21 18:52:57 2009 -0500

    Change the count query to avoid an infinite loop (BGO #548131).
    
    2009-01-21  Bertrand Lorentz  <bertrand lorentz gmail com>
    
    	* src/Extensions/Banshee.CoverArt/Banshee.CoverArt/CoverArtJob.cs:
    	Change the count query to avoid an infinite loop (BGO #548131).
    
    svn path=/trunk/banshee/; revision=4935
---
 .../Banshee.CoverArt/CoverArtJob.cs                |    4 +++-
 1 files changed, 3 insertions(+), 1 deletions(-)

diff --git a/src/Extensions/Banshee.CoverArt/Banshee.CoverArt/CoverArtJob.cs b/src/Extensions/Banshee.CoverArt/Banshee.CoverArt/CoverArtJob.cs
index caa0db5..b154a18 100644
--- a/src/Extensions/Banshee.CoverArt/Banshee.CoverArt/CoverArtJob.cs
+++ b/src/Extensions/Banshee.CoverArt/Banshee.CoverArt/CoverArtJob.cs
@@ -58,10 +58,12 @@ namespace Banshee.CoverArt
 
         private static HyenaSqliteCommand count_query = new HyenaSqliteCommand (@"
             SELECT count(DISTINCT CoreTracks.AlbumID)
-            FROM CoreTracks
+            FROM CoreTracks, CoreArtists, CoreAlbums
             WHERE
                 CoreTracks.PrimarySourceID = ? AND
                 CoreTracks.DateUpdatedStamp > ? AND
+                CoreTracks.AlbumID = CoreAlbums.AlbumID AND 
+                CoreAlbums.ArtistID = CoreArtists.ArtistID AND
                 CoreTracks.AlbumID NOT IN (
                     SELECT AlbumID FROM CoverArtDownloads WHERE
                         LastAttempt > ? OR Downloaded = 1)");