Re: [SlimDevices: Plugins] Announce: New versions of erlands plugins

[MillmoorRon]

erland wrote: 
> I’m not behind a computer right now so I can’t 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 doesn’t help and I’ll take a look at it the next
> time I’m beside a computer and have some time.
> If you want to show track artists it gets a bit more complicated and
> you’ll 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
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins