User Tools

Site Tools


playlists_sql_examples

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
playlists_sql_examples [2021/09/27 15:08]
pinupadmin
playlists_sql_examples [2021/11/11 14:48] (current)
pinupadmin
Line 66: Line 66:
  
 </code> </code>
 +
 +- Playlist that will show you the last 10 games you've updated in Popper (via drag/drop update method)
 +
 +<file>
 +Select * from games where visible=1 order by datefileupdated DESC LIMIT 10
 +
 +</file>
  
 - Based on GameType, list all DMD (and color DMD) games: - Based on GameType, list all DMD (and color DMD) games:
playlists_sql_examples.txt ยท Last modified: 2021/11/11 14:48 by pinupadmin