and now the message:

SELECT * FROM ( #Christmas
(SELECT `songs`.`ID`, `songs`.`artist`, `songs`.`title`, `songs`.`date_played`, `songs`.`
artist_played`,`songs`.`id_subcat`, `songs`.`weight`, 1 AS `preference` FROM `songs`
LEFT JOIN `queuelist` ON ( `songs`.`artist` = `queuelist`.`artist`)
WHERE `songs`.`enabled` = 1
AND `songs`.`song_type` = 0
AND `songs`.`id_subcat` = 59
AND `songs`.`id_genre` = 99
AND (TIMESTAMPDIFF(MINUTE, `songs`.`date_played`, NOW()) > $TrackRepeatInterval$)
AND (TIMESTAMPDIFF(MINUTE, `songs`.`artist_played`, NOW()) > $ArtistRepeatInterval$)
AND (MONTH(CURDATE()) = 12)
AND (DAY(CURDATE()) >= 6)
AND (DAY(CURDATE()) <= 31)
AND `queuelist`.`artist` IS NULL
AND `weight`=75
ORDER BY RAND ()
LIMIT 20)
UNION
#Summer
(SELECT `songs`.`ID`, `songs`.`artist`, `songs`.`title`, `songs`.`date_played`, `songs`.`
artist_played`,`songs`.`id_subcat`, `songs`.`weight`, 2 AS `preference` FROM `songs`
LEFT JOIN `queuelist` ON ( `songs`.`artist` = `queuelist`.`artist`)
WHERE `songs`.`enabled` = 1
AND `songs`.`song_type` = 0
AND `songs`.`id_subcat` = 68
AND `songs`.`id_genre` = 151
AND (TIMESTAMPDIFF(MINUTE, `songs`.`date_played`, NOW()) > $TrackRepeatInterval$)
AND (TIMESTAMPDIFF(MINUTE, `songs`.`artist_played`, NOW()) > $ArtistRepeatInterval$)
AND (MONTH(CURDATE()) >= 6)
AND (MONTH(CURDATE()) <= 8)
AND (DAY(CURDATE()) >= 1)
AND (DAY(CURDATE()) <= 31)
AND `queuelist`.`artist` IS NULL
AND `weight`=75
ORDER BY RAND ()
LIMIT 20)

UNION
#90 POP
(SELECT `songs`.`ID`, `songs`.`artist`, `songs`.`title`, `songs`.`date_played`, `songs`.`
artist_played`,`songs`.`id_subcat`, `songs`.`weight`, 3 AS `preference` FROM `songs`
LEFT JOIN `queuelist` ON ( `songs`.`artist` = `queuelist`.`artist`)
WHERE `songs`.`enabled` = 1
AND `songs`.`song_type` = 0
AND `songs`.`id_subcat` = 68
AND `songs`.`id_genre` = 99
AND (TIMESTAMPDIFF(MINUTE, `songs`.`date_played`, NOW()) > $TrackRepeatInterval$)
AND (TIMESTAMPDIFF(MINUTE, `songs`.`artist_played`, NOW()) > $ArtistRepeatInterval$)
AND `queuelist`.`artist` IS NULL
AND `weight`=75
ORDER BY RAND ()
LIMIT 20)
ORDER BY `date_played` asc
LIMIT 60
) temp
ORDER BY `preference`, `date_played` asc
LIMIT 1;
It looks pretty difficult but I can explain in an easy way! Like you can see the word UNION is passing by several times.. Every text between 2 'Unions' is searching for a specific songtype. If you look well you see 3 blocks:

#Christmas
#Summer
#90 POP

(SELECT `songs`.`ID`, `songs`.`artist`, `songs`.`title`, `songs`.`date_played`, `songs`.`
artist_played`,`songs`.`id_subcat`, `songs`.`weight`, 1 AS `preference` FROM `songs`
LEFT JOIN `queuelist` ON ( `songs`.`artist` = `queuelist`.`artist`)
WHERE `songs`.`enabled` = 1
AND `songs`.`song_type` = 0
AND `songs`.`id_subcat` = 59
AND `songs`.`id_genre` = 99
AND (TIMESTAMPDIFF(MINUTE, `songs`.`date_played`, NOW()) > $TrackRepeatInterval$)
AND (TIMESTAMPDIFF(MINUTE, `songs`.`artist_played`, NOW()) > $ArtistRepeatInterval$)
AND (MONTH(CURDATE()) = 12)
AND (DAY(CURDATE()) >= 6)
AND (DAY(CURDATE()) <= 31)
AND `queuelist`.`artist` IS NULL
AND `weight`=75
ORDER BY RAND ()
LIMIT 20)
That was the block. Now I will explain it line by line:

THIS IS JUST A NAME TO KNOW WHAT SONG WILL BE SELECTED (SELECT `songs`.`ID`, `songs`.`artist`, `songs`.`title`, `songs`.`date_played`, `songs`.`artist_played`,`songs`.`id_subcat`, `songs`.`weight`, 1 AS `preference` FROM `songs` LEFT JOIN `queuelist` ON ( `songs`.`artist` = `queuelist`.`artist`) THESE ARE ALL THE FIELDS RADIODJ HAS TO SEARCH FOR IN THE DATABASE IT IS COMPLICATED TO EXPLAIN BUT THE MOST IMPORTANT IS "1 AS `preference`" BECAUSE IT WILL MAKE A SPECIFIC ORDER TO LOAD THE SONGS (AS YOU SEE EVERY SEARCH OF SONG HAS A DIFFERENT PRFERENCE NUMBER) WHERE `songs`.`enabled` = 1 AND `songs`.`song_type` = 0 AND `songs`.`id_subcat` = 59 AND `songs`.`id_genre` = 99 NOW THE REAL SEARCH STARTS. IT LOOKS FOR ENABLED SONGS song_type 0 = MUSIC (1 FOR JINGLES AND SO ON id_subcat = THE ID FOR SUBCATEGORIES (IN MY CASE 59 = CHRISTMAS) id_genre = THE ID FOR GENRE (IN MY CASE 99 = POP) (IF YOU DON'T KNOW YOUR ID'S, LOOK IN YOU DATABASE. YOU CAN FIND ALL ID'S AND NAMES THERE. MY TIP IS TO MAKE A LIST AND SAVE IT ON YOUR COMPUTER SOMEWHERE) AND (TIMESTAMPDIFF(MINUTE, `songs`.`date_played`, NOW()) > $TrackRepeatInterval$) AND (TIMESTAMPDIFF(MINUTE, `songs`.`artist_played`, NOW()) > $ArtistRepeatInterval$) THIS IS ARTIST SEPERATION. IT IS USED LIKE YOU SET IN THE OPTIONS SCREEN OF RADIODJ AND (MONTH(CURDATE()) = 12) AND (DAY(CURDATE()) >= 6) AND (DAY(CURDATE()) <= 31) WELL THIS IS THE BEST PART, IT ONLY LOADS THE SONGS IF THE CURRENT DATE IS BETWEEN 6-12 AND 31-12 AND `queuelist`.`artist` IS NULL IT LOOKS IF THE SONGS IS ALREADY LOADED WITHOUT BEING PLAYED (SO YOU WON'T GET THE SONG TWICE IN THE ROTATION THAT IS LOADING) AND `weight`=75 NOW THE WEIGHT THING IS SOMTHING PERSONAL.. I USE 75 FOR HIGH ROTATION, 50 FOR MIDDLE ROTATION AND 25 FOR LOW ROTATION. YOU ARE ABLE TO PLAN THE SONGS EVEN BETTER (DURING DAY I ONLY USE 75, IN EVENING 50 AND IN NIGHT ALSO 25) IF YOU WILL USE THIS. MAKE SURE THAT IN SETTING YOU HAVE "ON PLAY, REDUCE BY PRIORITY" IS SET TO 0,0 ORDER BY RAND () LIMIT 20) SELECT 20 RANDOM SONGS.

ORDER BY `date_played` asc LIMIT 60 ) temp ORDER BY `preference`, `date_played` asc LIMIT 1; Again I will cut this text in parts to explain: ORDER BY `date_played` asc LIMIT 60 I USED LIMIT 20 IN THE PREVIOUS PART. AS YOU SEE IN THE FULL QUERIE I SEARCH FOR 3 SONGTYPES (CHRISTMAS, SUMMER, 90 POP). FOR EACH DONGTYPE I LET THE DATABASE SEARCH FOR 20 SONGS. IN THE TEXT ABOVE, THE DATABASE PLACES ALL 60 SONGS IN ORDER DATE OF PLAYED ) temp ORDER BY `preference`, `date_played` asc LIMIT 1;

Hope it was usefull.

Ruud

From radiodj.site Many thanks Ruud