Most played PlayLists with Active SQL

[dabri]

Hi,

I want to add a new playlist "Most played" in the playlist config, for example the most played 25 tables.

 

For that purpose I want to use Active SQL:

https://www.nailbuster.com/wikipinup/doku.php?id=playlists_sql_examples

 

But I don't know the variables for that data.

 

Do you have any tips for me?

 

Thank you and regards

Daniel

 

[GauGau]

Haven't tested, but should be something like

SELECT * FROM Games JOIN GamesStats ON Games.GameID=GamesStats.GameID AND Visible=1 ORDER BY GamesStats.TimePlayedSecs DESC LIMIT 25

or

SELECT * FROM Games JOIN GamesStats ON Games.GameID=GamesStats.GameID AND Visible=1 ORDER BY GamesStats.NumberPlays DESC LIMIT 25

 

[dabri]

Hi gaugau,

thank you, works perfect!

Regards