--- copycover-offline.py.org 2008-12-29 21:50:41.000000000 -0500 +++ copycover-offline.py 2008-12-29 22:01:40.000000000 -0500 @@ -116,7 +116,7 @@ for artist_tuple in artists: inc = inc + 1 if inc >= len(progress): inc = 0 - dcop_albums = commands.getoutput('''dcop amarok collection query "SELECT DISTINCT album.name, CONCAT(devices.lastmountpoint,'/',tags.dir) FROM tags, album, devices ''' \ + dcop_albums = commands.getoutput('''dcop amarok collection query "SELECT DISTINCT album.name, devices.lastmountpoint || '/' || tags.dir FROM tags, album, devices ''' \ +'''WHERE tags.album = album.id AND tags.deviceid = devices.id AND album.name != '' AND tags.artist = %s"''' % artist_tuple[0]) if not dcop_albums: