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: select top 10 tracks from tracks inner join (select top 20 artist.* from artists order by playcount desc) as top20 on track.artist=top20.artist order by rand -- lrossouw Louis 'Last.fm' (http://www.last.fm/user/lrossouw) ------------------------------------------------------------------------ lrossouw's Profile: http://forums.slimdevices.com/member.php?userid=3416 View this thread: http://forums.slimdevices.com/showthread.php?t=91625 _______________________________________________ plugins mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/plugins
