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
Next revision
Previous revision
playlists_sql_examples [2021/06/06 11:30]
pinupadmin
playlists_sql_examples [2021/11/11 14:48]
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:
  
 <code> <code>
-SELECT * FROM Games JOIN Emulators on Games.EmuID = emulators.EmuID WHERE (GameType= "DMDc" or GameType= "DMD") ORDER BY GameDisplay+SELECT * FROM Games WHERE (GameType= "DMDc" or GameType= "DMD") ORDER BY GameDisplay
  
 </code> </code>
Line 77: Line 84:
  
 <code> <code>
-SELECT * FROM Games JOIN Emulators on Games.EmuID = emulators.EmuID WHERE (GameType= "DMDc" or GameType= "DMD") and tags not like "%ignore%" ORDER BY GameDisplay+SELECT * FROM Games WHERE (GameType= "DMDc" or GameType= "DMD") and tags not like "%ignore%" ORDER BY GameDisplay
  
 </code> </code>
Line 84: Line 91:
  
 <code> <code>
-SELECT * FROM Games JOIN Emulators on Games.EmuID = emulators.EmuID WHERE ( LaunchCustomVar LIKE "%pinsound%" or LaunchCustomVar LIKE "%altsound%") and TAGS NOT LIKE "%ignore%" ORDER BY "GameDisplay"+SELECT * FROM Games WHERE ( LaunchCustomVar LIKE "%pinsound%" or LaunchCustomVar LIKE "%altsound%") and TAGS NOT LIKE "%ignore%" ORDER BY "GameDisplay"
  
 </code> </code>
playlists_sql_examples.txt ยท Last modified: 2021/11/11 14:48 by pinupadmin