RadioDJ: Program Year-Based Jingles & Songs in Rotations (SQL Magic!)
Are your rotations lacking ZIP, PEP and PIZZAZZ? Oh, you’re in the right spot, beloved broadcaster o’ the internets. There’s no better way to create a dynamic, custom sound than by infusing variety into your radio station’s rotations. This feature does the trick!
I’ll show you two ways to program year-based production elements (jingles, sweepers, liners) and songs into your RadioDJ rotations. What? Let’s say you have a jingle that features 1985 and you’d love RadioDJ to play a song from 1985 after it. Done!
Awesome for decade-based radio stations OR great for anyone running a flashback feature. The two methods on offer will kick your on-air sound to the next level. (If you run an 80s station, that would be Level 42!) 🤣
Because I’m the YouTuber who cares, here’s the SQL Magic! Code referenced in the video:
#Year Based Jingle_Song
SET @pick_year := (SELECT `songs`.`year` FROM `songs` WHERE `songs`.`id_subcat` = 44 AND `songs`.`year` BETWEEN 1980 AND 1989 ORDER BY `songs`.`date_played` ASC LIMIT 1);
SELECT id, title, artist FROM (
SELECT `songs`.`id`,`songs`.`title`, `songs`.`artist` FROM `songs`
WHERE `songs`.`id_subcat` = 44 AND `songs`.`year` = @pick_year
ORDER BY `songs`.`date_played` ASC
LIMIT 1
) AS jingle
UNION ALL
SELECT id, title, artist FROM (
SELECT `songs`.`id`,`songs`.`title`, `songs`.`artist` FROM `songs`
LEFT JOIN `queuelist` ON `songs`.`artist` = `queuelist`.`artist`
WHERE`songs`.`enabled` = 1
AND `songs`.`song_type` = 0 AND `songs`.`id_genre` = 143 AND `songs`.`id_subcat` = 2 AND `songs`.`year` = @pick_year
AND ((TIMESTAMPDIFF(MINUTE, `songs`.`date_played`, NOW()) “greater than sign” $TrackRepeatInterval$) AND (TIMESTAMPDIFF(MINUTE, `songs`.`artist_played`, NOW()) “greater than sign” $ArtistRepeatInterval$))
AND `queuelist`.`artist` IS NULL
ORDER BY `songs`.`date_played` ASC
LIMIT 1
) AS song;
*Variables to change:
id_subcat = (this is the number of your specific jingle & song subcategory)
id_genre = (this is the number of your music genre)
BETWEEN year AND year = Set to your liking
“greater than sign” = YouTube doesn’t allow angled brackets in descriptions. Replace this with the greater than symbol.
🎙️ My Radio Set-Up
Electrovoice RE-20 Mic ~ https://amzn.to/3WT23bK
Soundcraft 8Ch Mixer ~ https://amzn.to/4dqdLSg
Focusrite Audio Interface ~ https://amzn.to/3WQQQsf
Mic Arm ~ https://amzn.to/3ywZl3C
🎤 More Affordable Options
Audio-Technica AT2020 Mic ~ https://amzn.to/3WSy03F
Soundcraft 5Ch Mixer ~ https://amzn.to/3YQH77U
--I receive a small commission if you purchase through my links, at no extra cost to you. Think of all the value you get from these vids. I’d greatly appreciate the click! Thank you.
📻 For XXXtreme commercial-free 80s FUN…and to hear totally rad year-based flashbacks…check out the #4263rd popular 80s online station, https://www.XXX80s.com
#radiodj #radiostation #broadcaster