Author Topic: Has anybody done this with SQL already? 5 songs from 2 categories  (Read 939 times)

Lotus

  • New User

  • Offline
  • *
  • 24
Has anybody done this with SQL already? 5 songs from 2 categories
« on: September 13, 2021, 04:41:15 PM »
I am looking for SQL that would grab 5 songs from two categories.

I want to play 5 songs from the two 80s categories at 8pm and 5 songs from the two 90s categories at 9pm.
I will handle the time insert with an event.
(bonus if it ignores songs in the queue and uses the last played rules)

I am going to start putting some SQL based off other examples located here
https://www.radiodj.ro/community/index.php?topic=6658.0
But thought I would ask if someone already has done this work?