Greg Klanderman wrote: > > WHERE contributor_track.track = tracks.id AND contributors.id = > contributor_track.contributor AND albums.id = tracks.album AND ( albums.compilation = ? AND contributor_track.role IN ( ?, ? ) ) > > whereas for Browse Artwork it's doing: > > WHERE albums.id = tracks.album AND ( contributors.id = albums.contributor ) > > Maybe you can see what the relevant difference is?
Its a lot easier if you throw away all the field and table BS and just look at the query's WHERE clause. Throw away the Orders clause for clarity as well. What you can see is that both have "contributors.id = contributor_track.contributor AND albums.id = tracks.album " and the first has lots of other stuff. There is no reason to expect the two queries to yield the same rows. -- Pat http://www.pfarrell.com/music/slimserver/slimsoftware.html _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/beta
