Subsonic Forum

It would be awesome to have a playlists generated from whatever was listened to on the server the most last week/month etc

is this possible in any fashion at this point?

Thanks!

Hi, in the db.view of subsonic, you can retrieve the most played songs of all-time with this query

Code: Select all

SELECT TOP 101 title, album, artist, PLAY_COUNT FROM media_file WHERE TYPE = 'MUSIC' ORDER BY PLAY_COUNT desc

*Replace 101 with the number you want
*Replace TYPE = 'MUSIC' by TYPE = 'ALBUM' to get the album list

Though you can't do the same for weeks, month, year, etc.

But I definitely support this request +1

mitrailer wrote:Hi, in the db.view of subsonic, you can retrieve the most played songs of all-time with this query

Code: Select all

SELECT TOP 101 title, album, artist, PLAY_COUNT FROM media_file WHERE TYPE = 'MUSIC' ORDER BY PLAY_COUNT desc

*Replace 101 with the number you want
*Replace TYPE = 'MUSIC' by TYPE = 'ALBUM' to get the album list

Though you can't do the same for weeks, month, year, etc.

But I definitely support this request +1

Thanks for the tip! The weekly/monthly is definitely what I am looking for but this will make a pretty cool playlists as well