>still, my solution would work, "Circus (Take
>That)" and "Circus (Spears)" may not be pretty, but effective.
>
Yes, the kludge would kind of work, except unless you always add it to all
albums, you could be caught out with two albums that have the same name.
The following SQL query run against the SC database finds albums in your
library that have the same name:
select CONVERT(albums.title USING UTF8) AS 'album name', count(*) as
'album count' from albums
group by CONVERT(albums.title USING UTF8)
having count(*) > 1
I have:
'Atmosphere', 2
'BBC Radio 1 Live In Concert', 2
'Blue Room', 2
'Genesis', 2
'Greatest Hits', 5
'Lost In Space', 2
'Maya', 2
'MTV Unplugged', 3
'Not Too Late', 2
'Pink Floyd Live 1974-11-16', 2
'Remixed', 3
'Sarah McLachlan Live 2003-11-04', 2
'The Planets', 2
'Third', 2
'Unplugged', 2
'White Stripes Live 2007-06-13', 2
'X', 2
Some of those you would not expect to be duplicate album names when ripping.
Unless you always add the artist name in the album title (yuck), you may have
two albums merged into one. That is, if SC didn't take the file path into
consideration and worked purely by tags.
_______________________________________________
beta mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/beta