MillmoorRon wrote: > I am trying to get a list of my top rated tracks to export to a file. > > Using Database query I have this... > > > > which returns the URLs (with lots of %20) but I'd like a more human > readable list showing "Artist - Album - Title" > > Anyone know how to achieve this? (my SQL skills are not great!)
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 Erland Isaksson ('My homepage' (http://erland.isaksson.info)) Developer of 'many plugins/applets' (https://wiki.slimdevices.com/index.php/User_Erland.html) *Starting with LMS 8.0 I no longer support my plugins/applets* ('see here for more information' (https://forums.slimdevices.com/showthread.php?49483-Announce-New-versions-of-erlands-plugins&p=998836&viewfull=1#post998836) ) ------------------------------------------------------------------------ erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 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
