query Rotation

A Query line standard contents:

My list

SELECT = What to select.
FROM = From which table (in this case often from the songs table).
WHERE = Where to start for equals.

AS (See AND on next check)

$ForceRepeatRules$ = A pre divined rule made by Marius (there are more in the screen).
AND = Also look at.
ORDER BY = Order by rand() This is used for random selecting
GROUP BY = (Not in the list ) (Make groups to select).
ACS= Sort from A to Z (Not in the list but usefully).
DECS = Sort from Z to A (Not in the list but usefully).
LIMIT = Limit it to max lines for selections in the query.
-- = A comment line for explanation see examples.
song_type = 0 Important if it's a song track.
enabled = 1 (important if the song track can play (if not is set as disabled or not is set as not found on the special set drive in the database (error is like not the correct path in your songs table). )

What is capitalized red in the list must also be used in the query line with capital letters!

example #1

-- ADD 3 TRACKS WITH SWEEPER FROM 1970 TO 1989

SELECT ID, year, path FROM songs WHERE $ForceRepeatRules$ AND year >='1970' AND year < '1990' ORDER BY rand() LIMIT 3;
$SweeperOnStart$

example #2

-- PLAY TWO TRACKS FROM THE SAME ARTIST AND EXCLUDE ARTISTS THAT ARE ALREADY IN THE PLAYLIST.

SELECT ID, artist, title FROM songs WHERE artist=( SELECT songs.artist FROM songs WHERE songs.enabled=1 AND songs.song_type=0 GROUP BY `songs`.`artist` HAVING COUNT(*) > 1 ORDER BY `songs`.`date_played` ASC LIMIT 1) AND `enabled`=1 AND `song_type`=0 ORDER BY `date_played` ASC LIMIT 2;
$SweeperOnStart$

example #3

-- ADD 10 MOST PLAYED TRACKS TO THE PLAYLIST

SELECT `ID` FROM `songs` WHERE `song_type`=0 AND `enabled`= '1' ORDER BY `count_played` DESC LIMIT 10;

example #4

-- ADD 10 TRACKS OF AN ARTIST TO THE PLAYLIST

SELECT `ID` FROM `songs` WHERE `artist`='term' LIMIT 10;

example #5

-- ADD 10 MOST PLAYED TRACKS FROM SAME GENRE TO THE PLAYLIST -- id_genre = Genre number

SELECT `ID` FROM `songs` WHERE `song_type`=0 AND `enabled`= '1' AND `id_genre` = '8' ORDER BY `count_played` DESC LIMIT 10;

In c:\RadioDJv2\SQL Rotation Examples\ Are some query's to use.
TIP: Store/Save your query's in it to!

Query rotations

Rotation from a query.

A query line looks like:

example #1

example #2

example #3

example #4

example #5