Bronze Member

This rotation was automatically generated using the StreamCode Studio Rotation Builder.

Below is a detailed summary of the settings that were applied during the build process.
These values are for an artist not played for a minimum of 30 days, Not repeating Artist for 10 hours with a 5 hour rotation.

Rotation Settings Used:
Output type: SQL Query
- Days since last play: 30
- Artist separation: 10 hours
- Target duration: 5 hours

SELECT *
FROM songs
WHERE enabled = 1
  AND (date_played IS NULL OR date_played < NOW() - INTERVAL 30 DAY)
  AND artist NOT IN (
        SELECT artist
        FROM history
        WHERE date_played > NOW() - INTERVAL 10 HOUR
  )
ORDER BY (weight + 1) * RAND() DESC
LIMIT 1;

If you have any suggestions, improvements, or want to share your own version, feel free to comment below.
You can also regenerate or tweak this rotation any time using the StreamCode Studio Rotation Helper Tool.