You can do it with the SQLPlayList plugin.
The following SQL query would result in a random playlist with all
songs in "Pop" or "Rock" genre that is less than 6 minutes long.
Code:
--------------------
select url from tracks,genre_track,genres
where tracks.id=genre_track.track and
genre_track.genre=genres.id and
tracks.audio=1 and
genres.name in ('Pop','Rock') and
tracks.secs<360
order by random() limit 10;
--------------------
The following SQL query would result in a random playlist with all
songs in your whole collection that is less than 10 minutes long.
Code:
--------------------
select url from tracks
where tracks.audio=1 and
tracks.secs<600
order by random() limit 10;
--------------------
--
erland
Erland Isaksson
'My homepage' (http://erland.homeip.net) 'My download page'
(http://erland.homeip.net/download)
(Developer of 'TrackStat'
(http://erland.homeip.net/download/do/viewapplication?name=slimserver-trackstat)
, 'SQLPlayList' (http://tinyurl.com/pptqy) and 'DynamicPlayList'
(http://tinyurl.com/kfrgs) plugins)
------------------------------------------------------------------------
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=23737
_______________________________________________
discuss mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/discuss
