RadioDJ: Program Year-Based Jingles & Songs in Rotations (SQL Magic!)
ฝัง
- เผยแพร่เมื่อ 15 ต.ค. 2024
- 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 TH-camr 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” = TH-cam doesn’t allow angled brackets in descriptions. Replace this with the greater than symbol.
🎙️ My Radio Set-Up
Electrovoice RE-20 Mic ~ amzn.to/3WT23bK
Soundcraft 8Ch Mixer ~ amzn.to/4dqdLSg
Focusrite Audio Interface ~ amzn.to/3WQQQsf
Mic Arm ~ amzn.to/3ywZl3C
🎤 More Affordable Options
Audio-Technica AT2020 Mic ~ amzn.to/3WSy03F
Soundcraft 5Ch Mixer ~ 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, www.XXX80s.com
#radiodj #radiostation #broadcaster
This is why we need FM progressive-rock radio.
Wow! That’s cool so much.
Happy you dug it! Thanks!
Thanks so much for posting these videos. They sound great and are very informative. You do some awesome work. Who is the male voice on your radio station? He's got such a nice voice and I've heard him before but I can't remember his name
Todd, thanks SO much for the super kind words. I really appreciate it! Honestly, I don't know his name. I ordered some VO from a guy on Fiverr and he contracts with the talent. I wish I knew, he's great and has a real major market sound.
@@RadioDJDude @RadioDJDude He does have a major market sound. I agree. If you load any more AI drive voice stuff, let me know because I love hearing it and I really can hear how real it sounds when it's dry. I really enjoyed your videos so let me know if you post anything else with the AI voice(s)
@@toddgrant6182 I'm definitely cookin' up some more AI-themed vids! One is a cool automated workflow to generate an AI-powered weather report. Stay tuned!
@@RadioDJDude great. I'll definitely look for them
Love your programs and Jingles
Wow, really appreciate that. Thank YOU!
It's wonderful. Thank you fom Sardegna.
A big "Grazie" for tuning in! :)
You're the man!
Thank you! YOU rock for watching!
Yes this was a "Super Cool" feature to add to the station, as we added a blend of TV shows to the feature. Now there's a mix of Movie & TV. On to the next feature. Rock On brother!
Awesome! Happy you dig it. Since that was my early foray into coding, I have a more streamlined way to pull it off. I'll post in the Description soon.
@@RadioDJDude Decade Dble play next on the agenda. Looking forward to the streamlined version.
Great find ! Question: For solution #1: Why do you use the language for defining the year? My music tracks have all the "year" field (under details), and in the subcat I use 60/70/80/90/00/10/20. The subcat is for my track rotation. But for sure you could use "year" in stead of "language"? Or am I missing something?
Other than that I would like to give this a spin. I guess I'll have to start making some "year" sweepers. Any suggestion on where I can buy those great singing "1984" sweepers. I've been googling, no luck so far...
Started to question my own question 😅. So I checked my mp3 files in RadioDJ. The answer is : the year tag is when the actual album or single was released. (automatically assigned by MusicBrainz). In other words, a re-release of an album would have a higher year then the original release. (like with a digital remastered album). So the year tag can not be used in this case.
It is the mp3 tag called "Original Release Date" or "Original Year" that I needed to refer to. But RadioDJ doesn't use this tag. In a query RDJ only gives access to "Year". So I am planning a workaround that will give full access to ALL mp3 tags, and thus can be used in RDJ with a query.
Edit: RDJ gives access to the copywrite tag. That could be an easy way to store the "original year" in the file... and thus run a RDJ query using "copywrite" in stead of "year".
Great question! I enter year info in the year field, but within a rotation, there isn't a way to select a song based on year. However, a great hack is to use the language section for a more practical use. Within rotations, you can select songs based on language...or years, in my case. BUT, the SQL option uses the year info. As for prefab jingles, check out JingleSamplers.com
Can I ask where you get your movie flashbacks from? Also where do you get your music and sweepers and jingles from? This is a great tutorial I have got radio dj downloaded but I am very new to this. I used to be on radio in the 90’s where where we had a guy who produced our sponsors and jingles and would be played off mini disc but everything is now computer based. And also I see on your Adobe audition sono then the year
One tip is to search "movie name" + "soundboard". Some go-to sites are: soundboard.com, wavsource.com & movie-sounds.org. I download all the individual drops and create the flashback jingles from scratch. Love hearing from former radio pros! Hard to shake it from your bones. :)
Would love to know more how you create the flashback jingles.
@@RadioDJDudehow do you create the flashback jingles?
@@seebrad34 Hi Brad! If you watch my Movie Sweepers video, you'll get an idea of how I build basic production elements. For the flashback jingles, you need some kind of flashback stager or VO and a year element (like the jingles I use). OR you could use AI voices for both.
Can I ask where you get all
Your 80’s music from?
Pity I can’t hear your link of the station in Australia
Try using a free VPN
How dare they deny you access to the 80s! :) That sucks. Like someone else suggested, you can try using a VPN. OR try listening through Live365. They host my station and you probably can find it there. Thanks!
Hi RadioDJ Dude, I have past the code into the sql query and changed the genre and subcategory numbers. I only get error messages. I've tried everything but I can't get it to work. Can you help me with this please.This is the error code says:
#Year Based Jingle_Song
SET @pick_year := (SELECT `songs`.`year` FROM `songs` WHERE `songs`.`id_subcat` = 30 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` = 30 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` = 1 AND `songs`.`id_subcat` = 42 AND `songs`.`year` = @pick_year
AND ((TIMESTAMPDIFF(MINUTE, `songs`.`date_played`, NOW()) “greater than sign” 60) AND (TIMESTAMPDIFF(MINUTE, `songs`.`artist_played`, NOW()) “greater than sign” 60))
AND `queuelist`.`artist` IS NULL
ORDER BY `songs`.`date_played` ASC
LIMIT 1
) AS song;
Hi! One thing you forgot to do is replace "greater than sign" with >. Try that first. Also, what version of RDJ are you using?
Just saw this video & it was extremely helpful. Hope to gain additional support.
Happy you enjoyed! What other topics are you interested in?
After I review your other videos, I will be able to gather my thoughts and get back to you. thank you again.. Rock On Brother, rock On! @@RadioDJDude
I'll be here...just Rockin' On!! :)@@theel.us-americasrockstati8864
@@RadioDJDude Looking at "This day in Rock" where we identify Album Release on that day or B-day of artists, etc.. As we run a rotation based station, I was thinking about this type of feature. Any thoughts???
@@theel.us-americasrockstati8864 Overall, I like it! Couple things: 1) Do you have every album release date in your database? 2) Do you have every artist birthdate in database? 3) Would it be odd to have a generic VO, "And, now this day in rock", without any additional VO explaining the featured album or artist? Perhaps you're planning to record custom VO...much better. 4) Instead of focusing on specific album release dates (because you may not have one for every day), consider sorting by month. "This month back in '75, this album hit turntables..." It's a more flexible/versatile bit. Keep me posted!