| Action | Name | Query | Sort | Rnd Rep |
|---|
|
007 - Filmmusik |
album like "%Dr. No%" or album like "%Never Say Never Again%" or album like "%Casino Royale%" |
|
 |
|
2015 and newer |
datum>=2015 and genre not like "%text%" |
|
|
|
80s |
genre like "%80s%" |
|
|
|
90s |
genre like "%90s%" |
|
|
|
All 2007-today |
datum>=2007 and genre not like "%text%" and genre not like "%0s%" |
|
 |
|
Blues |
genre like "%blues%" |
|
|
|
Bravo Hits |
album like "bravo %" |
|
|
|
Chill-Out |
genre like "%chill_out%" |
|
|
|
Chinese |
artist like "%Chinese%" or title like "%Chinese%" or album like "%Chinese%" or genre like "%Chinese%" or usertext like "%Chinese%" or filename like "%Chinese%" or lyrics like "%Chinese%" |
|
|
|
Classic |
genre like "%classic%" and genre not like "%rock%" |
|
|
|
Classic by Artist |
artist like "%vivaldi%" or artist like "%mozart%" or artist like "%bach%" or artist like "%beethoven%" |
|
|
|
Club Sounds |
album like "Club%" or genre like "%club%" |
|
|
|
Dance |
genre like "%dance%" |
|
|
|
Easy Listening |
(genre like "%easy listenging%" or genre like "%jazz%" or genre like "%swing%" or genre like "%chill%out%" or genre like "%lounge%") and genre not like "%alternate%" |
|
|
|
Eurovision |
album like "%eurovision%" |
|
|
|
Evanescence |
artist like "Evanescence" |
artist |
|
|
French Songs |
genre like "%french%" or genre like "%chanson%" |
|
|
|
Gothic |
genre like "%gothic%" |
|
|
|
Halloween2015 |
genre like "%Halloween2015%" or album like "Cinema" or artist="Amy Winehouse" or artist="Janis Joplin" or title like "%Marily Monroe%" or album like "Monster Halloween Hits" |
|
|
|
Kylie Minogue |
artist like "Kylie Minogue" |
artist |
|
|
Less Random, no text |
genre not like "%text%" and genre not like "%alternate%" |
|
|
|
Lounge |
genre like "%lounge%" |
|
|
|
Moderner schnellerer Pop |
datum>="2008" and genre like "%pop%" and genre not like "%slow%" and genre not like "%alternate%" and genre not like "%text" |
|
|
|
Neue Lieder |
DATEDIFF(now(), t_changed)<30 and genre not like "%text%" |
|
|
|
Party |
genre like "%party%" and genre not like "%slow%" and genre not like "%schlager%" |
|
|
|
Pink Floyd |
artist like "pink floyd" |
|
|
|
Plüsch |
artist like "plüsch" |
|
|
|
Pop Maxis |
genre like "%pop%" and dauer>300 and dauer<900 |
|
|
|
Pop, less random |
(genre like "%pop%" or genre like "%soft rock%") and genre not like "%text%" and genre not like "%alternate%" |
|
|
|
Pop/Rock |
genre like "%pop%" and genre like "%rock%" and genre not like "%slow%" |
|
|
|
Random over all songs |
1=1 |
|
|
|
Random, no text |
genre not like "%text%" |
|
|
|
Rock, Punk, Metal |
genre NOT like "%pop%" and genre like "%rock%" or genre like "%punk%" or genre like "%metal%" and genre NOT like "%old%" |
|
|
|
Roft Rock |
genre like "%soft rock%" and genre not like "%text%" and genre not like "%alternate%" |
|
|
|
Schlager- / Hütten-Party |
genre like "%party%" and genre not like "%slow%" |
|
|
|
Singer-Songwriter |
genre like "%singer_songwriter%" |
|
|
|
Ski und Hütten Hits |
album like "Hütten Charts 2005%" or album like "Ski%Hits" or genre like '%pop%party%' |
artist |
|
|
Slow |
genre like "%slow%" |
|
|
|
Soul |
genre like "%soul%" |
|
|
|
Swiss Songs |
genre like "%CH %" and genre not like "%french%" |
|
|
|
The Dome |
album like "The Dome%" |
|
|
|
Trance |
genre like "%trance%" |
|
|
|
Whitney Houston |
artist LIKE "%Whitney Houston%" |
artist |
|
|
Xmas |
genre like "%xmas%" or genre like "%weihnacht%" or album like "%xmas%" or album like "%weihnacht%" or album like "%christmas%" |
datum desc |
|
|
Xmas >2015 |
(genre like "%xmas%" or genre like "%weihnacht%" or album like "%xmas%" or album like "%weihnacht%" or album like "%christmas%") and datum>=2015 |
|
|
Build a new Query