Re: [SlimDevices: Plugins] Random songs with random artists from TrackStats Most Played Artists

2011-11-16 Thread mykee
Yes, I was actually having that broad view on this, and got a bit frustrated when I couldn't get it right. Now I done some more work and currently at a point where I got a query that does random songs (any) from my 20 most played artists. select url from tracks, contributor_track where contribu

Re: [SlimDevices: Plugins] Random songs with random artists from TrackStats Most Played Artists

2011-11-15 Thread lrossouw
Very broadly speaking, first select the top 20 artists. Then select randome songs from those artists. This is done using a sub-query. This will select 10 random songs from all the top 20 artists. Broadly this might look like the following though of course the queries will be more complex: s

[SlimDevices: Plugins] Random songs with random artists from TrackStats Most Played Artists

2011-11-14 Thread mykee
Hi, I have been trying to achieve this in various ways. I have also tried to search the forum as I assume someone else have struggled with the same, but no success so far. What I want to do is to have a sql playlist that with use of TrackStat can play random songs from the say 20 most played art