erland wrote:
> Im not behind a computer right now so I cant give you the exact query
> but the SQL at the bottom of the following page shows how to join in
> album and album artist:
> https://wiki.slimdevices.com/index.php/SlimServerDatabaseStructure.html
> You want to show contributors.name, albums.title and tracks.title I
> think.
> Let me know if this doesnt help and Ill take a look at it the next
> time Im beside a computer and have some time.
> If you want to show track artists it gets a bit more complicated and
> youll need to join in contributors via contributor_track
Thanks for the link.
I couldn't get contributor_track to work to show the track artist but
did this:
Code:
--------------------
select contributors.name,albums.title,tracks.title from tracks
join albums on
tracks.album = albums.id
left join contributors on
tracks.primary_artist = contributors.id
join track_statistics on
tracks.url = track_statistics.url
where
tracks.audio = 1
and (track_statistics.rating>=70)
order by contributors.name, albums.title, tracks.title
--------------------
Does this do the same thing? It seems to work OK!
------------------------------------------------------------------------
MillmoorRon's Profile: http://forums.slimdevices.com/member.php?userid=6413
View this thread: http://forums.slimdevices.com/showthread.php?t=49483
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
