Re: [SlimDevices: Plugins] RandomMix with Least Recently Played Tracks

2009-11-02 Thread amatala
es.name in ('Mixable') and ifnull(tracks_persistent.playcount,0)=(select min(ifnull(playcount,0)) from tracks_persistent) group by tracks.id order by rand() limit 10; -- amatala http://www.

Re: [SlimDevices: Plugins] RandomMix with Least Recently Played Tracks

2009-11-02 Thread amatala
hose first. When everything will be played at least once, then I could select those with the lowest PlayCount first and then order them by LastPlayed - in this way I would have a better chance to listen to music I tend to overlook. -- amatala http://www.last.fm/us

Re: [SlimDevices: Plugins] RandomMix with Least Recently Played Tracks

2009-11-02 Thread amatala
to get the least recently played tracks with the smallest play count. -- amatala http://www.last.fm/user/amatala amatala's Profile: http://forums.slimdevices.com/member.php?userid=15972 View this thread: http://forums.

Re: [SlimDevices: Plugins] RandomMix with Least Recently Played Tracks

2009-11-01 Thread amatala
OK, I'll try with Trackstat and SQLPlaylist, see how it goes. Thanks! -- amatala http://www.last.fm/user/amatala amatala's Profile: http://forums.slimdevices.com/member.php?userid=15972 View this th

Re: [SlimDevices: Plugins] RandomMix with Least Recently Played Tracks

2009-10-31 Thread amatala
No one can help me with this? I thought that TrackStat was a very popular plugin - lots of users who know it well... Thanks! -- amatala http://www.last.fm/user/amatala amatala's Profile: http://forums.slimdevice

[SlimDevices: Plugins] RandomMix with Least Recently Played Tracks

2009-10-30 Thread amatala
not really a big fan of 3rd party plugins (I think that SC has enough problems already on its own) - the only 3rd party plugin I have installed is Server Power Control - because I absolutely need it. Thanks for the info! -- amatala http://www.last.fm/user/amatala