User Tools

Site Tools


playlists_sql_examples

This is an old revision of the document!


PlayLists Active SQL Examples

Active SQL Playlists are a very flexible way of managing your playlists. They are Playlists that will automatically execute/update each time you select them giving you ability to filter and grab tables dynamically.

Here are some sample of Playlists and the SQL you can set to use them:

- Based on GameType, list all DMD (and color DMD) games:

SELECT * FROM Games JOIN Emulators on Games.EmuID = emulators.EmuID WHERE (GameType= "DMDc" or GameType= "DMD") ORDER BY GameDisplay

- Using the TAG “ignore” remove certain games from any list:

SELECT * FROM Games JOIN Emulators on Games.EmuID = emulators.EmuID WHERE (GameType= "DMDc" or GameType= "DMD") and tags not like "%ignore%" ORDER BY GameDisplay

- Playlist for Pinsound tables (using field LaunchCustomVar)

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"

- Playlist for adult games:

select * from games JOIN Emulators on Games.EmuID = emulators.EmuID where TAGS LIKE "%adult%" and TAGS NOT LIKE "%ignore%" ORDER BY "GameDisplay"
playlists_sql_examples.1532748279.txt.gz · Last modified: 2018/07/27 23:24 by A User Not Logged in