HELP !!!

[danielzugaj]

Hi guys, can you explain to me the difference in selection modes for rotations? No matter how I set up RadioDJ, it still plays the newest songs, and it seems to forget about those added 4-5 months ago. My music library consists of over 10,000 songs, but RadioDJ only picks maybe the first 700 and that's it! It doesn't respond at all to the global settings in "Track Rotation Rules," and individual settings in rotations seem to be just a dream. Please help me solve this issue so that RadioDJ starts playing songs added, for example, 5-6 months ago. Thanks for any good advice.
Maybe the creator of the program himself will write how to solve this problem?

[stevewa]

yeah, the rotations seem broken.
you could try using SQL statements instead, to make sure you are selecting older songs too...

Code Select Expand

SELECT id, artist, title, date_played, enabled, date_modified
 from
 -- use subquery to get 20 songs in the subcat which have not been played recently
(
    SELECT id, artist, title, date_played, enabled, date_modified    
     FROM songs
     where id_subcat = 4
     AND enabled=1
     AND songs.ID NOT IN ( SELECT SongID FROM queuelist)
     -- sort by oldest played
     ORDER BY date_played asc
     -- offset first 10 oldest songs, to minimize repeats of songs that were just played, and return up to 40
     LIMIT 10, 40
)
AS oldest_songs
-- sort randomly
ORDER BY RAND()
-- return 3 songs
LIMIT 3;