FireFly Media Server › Firefly Media Server Forums › Firefly Media Server › General Discussion › Smart playlist help! › Reply To: Smart playlist help!
13/04/2008 at 5:10 PM
#16818
sonichouse
Participant
@Dimi wrote:
Hi,
I want to create a playlist that contain my 30 most played songs. How do I do that? can’t figure that out with help from the wizard. Please help me…
Not sure if this is possible with the wizard, but you could create a static playlist using some script, and update regularly.
The SQL would look something like
select path,fname, play_count, datetime(time_played, 'unixepoch', 'localtime')
from songs
where play_count > 0 and artist''
group by 1,2,3,4
order by 3 desc,4 desc,1,2 asc
limit 30;
Then you could create a m3u file with the results.