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 14 days, Not repeating Artist for 3 hours with a 5 hour rotation.

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

SELECT *
FROM songs
WHERE enabled = 1
  AND (date_played IS NULL OR date_played < NOW() - INTERVAL 14 DAY)
  AND artist NOT IN (
        SELECT artist
        FROM history
        WHERE date_played > NOW() - INTERVAL 3 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.