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
Last revision Both sides next revision
playlists_sql_examples [2021/06/06 11:30]
pinupadmin
playlists_sql_examples [2021/09/27 15:08]
pinupadmin
Line 70: Line 70:
  
 <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 77:
  
 <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 84:
  
 <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