Good tip about the SQLite browser!

I had a look at my db using the a query that was mentioned in another
thread:

"select distinct a.title, c.name
from albums a, contributor_album ca, contributors c
where a.id = ca.album
and ca.contributor = c.id
and a.compilation = 1
order by a.title"

This brings back all albums that are designated as compilations, which
is fine, however the following two albums are incorrectly marked as
compilation:

Athlete - Tourist
St. Germain - Tourist

I've checked the tags and neither have multiple or various artist tags.
Is this some kind of derived compilation based on the fact that the
album title is the same? 

What's the best way to fix it? Makes you wonder what else is wrong...


-- 
dSw
------------------------------------------------------------------------
dSw's Profile: http://forums.slimdevices.com/member.php?userid=362
View this thread: http://forums.slimdevices.com/showthread.php?t=14496

_______________________________________________
Discuss mailing list
Discuss@lists.slimdevices.com
http://lists.slimdevices.com/lists/listinfo/discuss

Reply via email to