Reply To: Smart playlist help!

#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.