Playlist SQL Befehle Beispiele

Hier gibt es eine Liste von SQL Befehlen, die ich so selber in meinen Playlisten einsetze. Keine Gewähr auf gar nichts, Einsatz auf eigenes Risiko :-)

select * from Games where GameYear >=1900 and GameYear < 1960 order by GameName
select * from Games where GameYear >=1960 and GameYear < 1970 order by GameName
select * from Games where GameYear >=1970 and GameYear < 1980 order by GameName
select * from Games where GameYear >=1980 and GameYear < 1990 order by GameName
select * from Games where GameYear >=1990 and GameYear < 2000 order by GameName
select * from Games where GameYear >=2000 and GameYear < 2010 order by GameName
select * from Games where GameYear >=2020 order by GameName
select * from Games where GameYear >=2010 order by GameName

SELECT * FROM Games WHERE GameTheme = '*****' and Category = '#####' and GameRating >= 7 ORDER BY GameDisplay;
SELECT * FROM Games WHERE (GameTheme = '*****' or Category = '#####') and Category NOT LIKE '+++++' ORDER BY GameDisplay;

SELECT * FROM Games WHERE Manufact = 'Atari' and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE Manufact = 'Allied Leisure' and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE Manufact = 'Alvin G.' and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE Manufact = 'Bally' and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE Manufact = 'Bell' and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE Manufact = 'Brunswick' and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE Manufact = 'Capcom' and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE Manufact = 'Chicago Coin' and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE Manufact = 'Data East' and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE Manufact = 'EMAGAR' and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE Manufact = 'Fipermatic' and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE Manufact = 'Game Plan' and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE Manufact = 'Geiger' and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE Manufact = 'Gottlieb' and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE Manufact = 'Hankin' and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE Manufact = 'Inder' and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE Manufact = 'Juegos Populares' and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE Manufact = 'Maresa' and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE Manufact = 'Midway' and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE Manufact = 'Nuova Bell' and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE Manufact = 'Original' and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE Manufact = 'Playmatic' and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE Manufact = 'Pinstar' and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE Manufact = 'Premier' and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE Manufact = 'Recel' and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE Manufact = 'Rowamet' and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE Manufact = 'Royal' and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE Manufact = 'Sega' and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE Manufact = 'Sonic' and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE Manufact = 'Stern' and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE Manufact = 'Stoner' and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE Manufact = 'Taito' and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE Manufact = 'Video Dens' and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE Manufact = 'Wico' and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE Manufact = 'Williams' and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE Manufact = 'Zaccaria' and GameRating >= 1 ORDER BY GameDisplay;

SELECT * FROM Games WHERE (GameDisplay like '%Batman%' ) ORDER BY GameYear;
SELECT * FROM Games WHERE (GameDisplay like '%Star%Trek%' ) ORDER BY GameYear;
SELECT * FROM Games WHERE (GameDisplay like '%Star Wars%' ) ORDER BY GameYear;
SELECT * FROM Games WHERE (GameDisplay like '%Spider%' ) ORDER BY GameYear;

SELECT * FROM Games ORDER BY GameDisplay;
SELECT * FROM Games WHERE EMUID= 3 ORDER BY GameDisplay;
SELECT * FROM Games WHERE EMUID= 1 ORDER BY GameDisplay
select * from Games order by DateAdded DESC LIMIT (20);
select * from Games order by DateUpdated DESC LIMIT (40);
SELECT * FROM Games t1 LEFT JOIN Playlistdetails t2 ON t2.GameID = t1.GameID WHERE t2.isFav = 2 ORDER BY GameDisplay
SELECT * FROM GAMES JOIN GamesStats ON Games.GameID = GamesStats.GameID WHERE EMUID =1 ORDER BY LastPlayed DESC LIMIT 10

SELECT * FROM Games WHERE GameRating = 6 ORDER BY GameDisplay;
SELECT * FROM Games WHERE GameRating = 7 ORDER BY GameDisplay;
SELECT * FROM Games WHERE GameRating = 8 ORDER BY GameDisplay;
SELECT * FROM Games WHERE GameRating = 9 ORDER BY GameDisplay;
SELECT * FROM Games WHERE GameRating = 10 ORDER BY GameDisplay;

SELECT * FROM Games WHERE (GameName like '0%') or (GameName like '1%') or (GameName like '2%') or (GameName like  '3%') or (GameName like '4%') or (GameName like '5%') or (GameName like '6%') or (GameName like '7%') or (GameName like '8%') or (GameName like '9%') and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE (GameName like 'A%') and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE (GameName like 'B%') and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE (GameName like 'C%') and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE (GameName like 'D%') and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE (GameName like 'E%') and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE (GameName like 'F%') and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE (GameName like 'G%') and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE (GameName like 'H%') and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE (GameName like 'I%') and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE (GameName like 'J%') and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE (GameName like 'K%') and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE (GameName like 'L%') and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE (GameName like 'M%') and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE (GameName like 'N%') and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE (GameName like 'O%') and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE (GameName like 'P%') and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE (GameName like 'Q%') and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE (GameName like 'R%') and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE (GameName like 'S%') and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE (GameName like 'T%') and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE (GameName like 'U%') and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE (GameName like 'V%') and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE (GameName like 'W%') and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE (GameName like 'X%') and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE (GameName like 'Y%') and GameRating >= 1 ORDER BY GameDisplay;
SELECT * FROM Games WHERE (GameName like 'Z%') and GameRating >= 1 ORDER BY GameDisplay;