I am trying to get a list of my top rated tracks to export to a file.
Using Database query I have this... > > <?xml version="1.0" encoding="utf-8"?> > <databasequery> > <template> > <id>sqlquery.xml</id> > <parameter type="text" > id="queryname"><value>PDA_4</value></parameter> > <parameter type="text" > id="querydescription"><value>Favourites</value></parameter> > <parameter type="text" id="querysql" rawvalue="1"><value> > select tracks.url from tracks > join track_statistics on > tracks.url = track_statistics.url > where > audio=1 > and (track_statistics.rating>=70) > group by tracks.id > </value></parameter> > </template> > </databasequery> > 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!) ------------------------------------------------------------------------ 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
