musiccaps_details (view)
11 rows where musiccaps_aspects contains "electronic music", musiccaps_aspects contains "enthusiastic" and musiccaps_aspects contains "youthful"
This data as json, CSV (advanced)
musiccaps_aspects (array) 142 ✖
- electronic music · 11 ✖
- enthusiastic · 11 ✖
- youthful · 11 ✖
- dance music 8
- fast tempo 8
- energetic 7
- club music 6
- dj 6
- edm 5
- instrumental 5
- psychedelic 5
- dance groove 4
- dj mixer 4
- trippy 4
- female singer 3
- insistent 3
- punchy drumming 3
- repetitive 3
- synth pop 3
- synthesiser arrangements 3
- trance 3
- turn table 3
- animated 2
- atmospheric synthesiser 2
- drum machine 2
- electro pop 2
- enigmatic 2
- hard hitting drums 2
- hard rock 2
- heavy metal 2
- hypnotic 2
- intense 2
- male singer 2
- medium fast tempo 2
- metal 2
- passionate 2
- pop 2
- psychedelic music 2
- punchy 2
- recurring vocal riff 2
- synthesiser articulation 2
- trance music 2
- upbeat 2
- vigorous 2
- vinyl records 2
- vital 2
- vocal backup 2
- alternative 1
- ambient 1
- amplified 1
- amplified instruments 1
- animated electric guitar accompaniment 1
- animated vocals 1
- atmospheric keyboard 1
- auto tune 1
- bass drum 1
- boisterous 1
- boomy 1
- boomy bass lines 1
- buoyant 1
- bustling 1
- busy 1
- captivating keyboard harmony 1
- catchy vocal riff 1
- club 1
- contemporary pop 1
- dance clubs 1
- dance floor 1
- dance hits 1
- digital drumming 1
- digital music 1
- disco pop 1
- disco rap 1
- dj mis 1
- dj mix 1
- dj music 1
- droning melody 1
- elctronic arangement 1
- elctronic beats 1
- electro rap 1
- electronic arrangement 1
- electronic instrumental 1
- electronic pop 1
- electronica 1
- emphatic 1
- enthusiastic vocals 1
- female rapper 1
- female vocalisation 1
- feminist 1
- funky bass lines 1
- girl band 1
- girl metal band 1
- groovy bass line 1
- hard hitting 1
- high energy 1
- high torque 1
- hip-hop 1
- incoherent lyrics 1
- indie 1
- infectious drumming 1
- intense electric guitar feedback 1
- keyboard harmony 1
- lively 1
- loud 1
- loud feedback 1
- male vocalist 1
- melodious 1
- melodipiano accompaniment 1
- muffled audio 1
- muted audio 1
- party hits 1
- percussive electronic music 1
- phono output 1
- phonograph record 1
- pleasant vocals 1
- pop rap 1
- powerful 1
- psychedelic background 1
- pulsating 1
- punchy beats 1
- rap 1
- rapid tempo 1
- rapper 1
- recurring 1
- recurring beat 1
- rhythmic acoustic guitar 1
- rock 1
- scratching sounds 1
- song climax 1
- spirited 1
- strong 1
- surround sound 1
- syncopated 1
- syncopated harmony 1
- synthesised vocal riff 1
- synthesiser arrangement 1
- thumpy bass 1
- trap 1
- vibrant 1
- vigorous drumming 1
- vocal riff 1
- vocalisation 1
musiccaps_names (array) 23 ✖
- Music 11
- Disco 2
- Zing 2
- Afrobeat 1
- Drum and bass 1
- Dubstep 1
- Electronic dance music 1
- Electronica 1
- Exciting music 1
- Folk music 1
- Funk 1
- Groan 1
- Harmonic 1
- Hip hop music 1
- Independent music 1
- Pop music 1
- Sampler 1
- Scratch 1
- Scratching (performance technique) 1
- Singing 1
- Soul music 1
- Synthesizer 1
- Techno 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
I Prevail - Stuck In Your Head (Official Music Video) | A male vocalist sings this enthusiastic Rock song. The tempo is fast with bright drumming, enthusiastic electric guitar harmony, keyboard accompaniment , groovy bass line. The song is youthful, enthusiastic, energetic, vital, vigorous and passionate rock. | 2016-10-22T16:00:46Z | IPrevailBand | Stream ‘TRUE POWER’ - https://found.ee/iptruepower Get Official I Prevail merch - https://found.ee/tp_merch "Stuck In Your Head" taken from the album 'Lifelines' available now. ITUNES: http://smarturl.it/IPlifelines Video by Drew Russ. http://drewruss.com/ Follow I Prevail: Website: https://found.ee/ip_web Facebook: https://found.ee/ip_facebook Twitter: https://found.ee/ip_twitter Instagram: https://found.ee/ip_instagram TikTok: https://found.ee/ip_tiktok Spotify: https://found.ee/ip_spotify Apple Music: https://found.ee/ip_applemusic Stay Connected with Fearless Records: Website: http://www.fearlessrecords.com/ Facebook: https://found.ee/FearlessFB Instagram: https://found.ee/FearlessIG Twitter:https://found.ee/FearlessTW Subscribe to Fearless Records on Youtube: http://found.ee/fr_youtube LYRICS: You’re not the one I want in my bed But I’m gonna be the song stuck in your head Stuck in your head Stuck in your head Guess what? For the record you’re the broken one Tried to sing along but we got stuck So we turn it over and over again But now, a thousand scratches on the song we held A million cuts finally wore it down Couldn’t turn it over and over again Turn it over and over again This’ll be the last time that I spin our life Never gonna play again You’re not the one I want in my bed I’m not the song you want in your head This’ll be the last time that I spin our life Never gonna play again You’re not the one I want in my bed But I’m gonna be the song stuck in your head Stuck in your head Guess what? Didn’t wanna have to write these words Now you’re on the other side reversed Never turning over and over again So now, I’ll turn it off cuz it’s so damn loud All your lies finally wore me down You can skip our track, cuz I’m not coming back This’ll be the last time that I spin our life Never gonna play again You’re not the one I want in my bed I’m not the song you want in your head This’ll be the last time that I spin our life Never gonna play again You’re not the one I want in my bed But I’m gonna be the… | ["Music", "Exciting music"] | ["male singer", "fast tempo", "rock", "hard rock", "metal", "heavy metal", "hard hitting drums", "animated electric guitar accompaniment", "groovy bass line", "captivating keyboard harmony", "enthusiastic vocals", "youthful", "electronic music", "dance music", "energetic", "enthusiastic", "spirited", "animated", "vigorous", "vital", "dance groove"] | 7 | 5keRbrVx-G4 | 690 | |
Ameen doing the shuffle | This song is a loud, energetic electronic instrumental. The audio quality is substandard making it hard to hear the song. One can tell that the song is vibrant , vivacious, bright, youthful and buoyant from the beat of punchy drumming and rapid incoherent vocals. Thesong sounds like EDM. | 2010-09-19T19:49:32Z | MeganJDBx | hayleys little brother doing the shuffle | ["Disco", "Music"] | ["instrumental", "fast tempo", "muffled audio", "edm", "electronic music", "dance music", "dance groove", "youthful", "punchy beats", "recurring vocal riff", "energetic", "enthusiastic", "electronic music", "muted audio", "incoherent lyrics"] | 7 | 8zDbEfC6Uf0 | 965 | |
Thud Rumble | Battle Ave. | 2014 Cut 2 Cut LA Finals | This music is instrumental. The tempo is fast with a rapid electronic harmony and vigorous digital drum rhythm in the background with turntable arrangement. The harmony is syncopated, repetitive, insistent, psychedelic, trance, trippy and groovy. It is energetic, youthful, contemporary, groovy, vigorous and animated. | 2014-06-23T19:49:43Z | Battle Ave | www.thebattleave.com www.thudrumble.com www.beatswapmeet.com Track: Who Dat Produced By: Jawa Album: Unreleased In Order: DJ Don Paco DJ Rayted R DJ Cues DJ Bombai Champion: DJ Rayted R - Battlestar Runner Up: DJ Don Paco Filmed at the Battle Ave. / Thud Rumble booth at Beat Swap Meet LA Part of the "At The Ave Breaks Tour" At The Ave Breaks now available via www.thebattleave.com | ["Scratching (performance technique)", "Sampler", "Music", "Scratch", "Synthesizer"] | ["instrumental", "fast tempo", "electronic music", "syncopated harmony", "repetitive", "insistent", "emphatic", "youthful", "energetic", "enthusiastic", "vibrant", "phonograph record", "high torque", "phono output", "loud", "turn table", "dj", "dj mixer", "club music", "trance", "psychedelic music", "trippy", "youthful", "vinyl records", "digital music", "dance clubs"] | 7 | E4a3s8NRqUM | 1531 | |
Indie/Pop/Folk Compilation - Christmas Playlist | A female singer sings this spirited song. The tempo is fast with a lively piano accompaniment, punchy drumming, funky bass line, rhythmic acoustic guitar, and a droning synthesiser harmony. The music is loud, busy, chaotic and bustling and the vocals are subdued. This clip sounds like the song climax as the instrumentation is strong and powerful. The song is spirited, melodic,energetic, enthusiastic, youthful and engaging. This song is an Indie Pop song. | 2014-11-24T09:53:53Z | alexrainbirdMusic | Listen to a collection of indie songs perfect for the festive season! Tracklist below... Subscribe to be the first to hear the finest independent music! http://bit.ly/145fFnx Please contact alexrainbirdmusic@gmail.com if you’d like your band to be featured on my channel. Tracklist: 0:00 LAYLA -- 'Winter, You Tease' https://www.facebook.com/listentolayla 3:39 Sugarcult -- 'Freezing' https://www.facebook.com/pages/Sugarcult/122472207779743 5:29 Sleeping At Last -- 'Silver Bells’ https://www.facebook.com/sleepingatlast 8:29 Brighten -- ‘Merry Christmas Baby’ https://www.facebook.com/pages/Brighten/108211255873665 11:39 Golden Youth -- ‘Have Yourself A Merry Little Christmas’ https://www.facebook.com/ourgoldenyouth Find alexrainbirdMusic on: Facebook: https://www.facebook.com/alexrainbirdMusic Twitter: https://twitter.com/alxrnbdMusic Spotify: https://play.spotify.com/user/alxrnbrdmusic Soundcloud: https://soundcloud.com/alexrainbirdmusic Instagram: https://instagram.com/alexrainbirdmusic/ Grab an official t-shirt: UK Store: http://shop.spreadshirt.co.uk/alexrainbirdmusic US Store: http://shop.spreadshirt.com/alexrainbirdmusic About alexrainbirdMusic: Since 2011, Alex Rainbird has been hunting down and showcasing the very best in independent music. Featuring over 45 new artists a month, Alex hopes to provide a platform for underrated musicians to be heard and for viewers to find their new favourite band. Join Alex's +44,000 subscribers today to be the first to hear the finest independent music. | ["Folk music", "Music", "Independent music", "Pop music"] | ["female singer", "fast tempo", "electronic music", "melodious", "youthful", "energetic", "enthusiastic", "song climax", "busy", "bustling", "melodipiano accompaniment", "punchy drumming", "synthesiser arrangements", "funky bass lines", "rhythmic acoustic guitar", "psychedelic background", "droning melody", "synth pop", "electronica", "amplified instruments", "pleasant vocals", "indie", "pop", "alternative"] | 7 | FGZ0sLt4dXA | 1631 | |
Voice Hands Machine - Take Your Hand | A male vocalist sings this spirited song. The tempo is fast with electronic instrumentation, synthesiser articulation and turn table. The song is spirited,youthful , enthusiastic, energetic, vigorous and vital. This song is an EDM/ Synth Pop song. | 2011-06-26T23:35:39Z | VoiceHandsMachine | Voice Hands Machine - Take Your Hand GET IT on ITUNES: http://bit.ly/tyhitu Website: http://bit.ly/vhm_www Facebook: http://on.fb.me/vhm_fb TAKE YOUR HAND is the new single from the fresh Paris talent, Voice Hands Machine. | ["Music", "Zing"] | ["male singer", "fast tempo", "edm", "electro pop", "dj mix", "youthful", "animated", "vigorous", "vital", "enthusiastic", "dance groove", "electronic music", "turn table", "dj", "animated vocals", "synthesiser articulation", "scratching sounds", "vinyl records", "dj mis", "dj mixer", "dance music", "dance floor", "club music", "ambient"] | 7 | X7qFgrAl3OU | 3163 | |
Scotty Dynamo - On A Roll | A male vocalist sings this spirited song. The tempo is fast with a bright keyboard harmony, boomy bass drops, infectious drumming and atmospheric synthesiser and a vocal riff. The electronic arrangements and synthesised sounds give it a psychedelic, trippy, hypnotic vibe. It is perky, buoyant, thumping, youthful, vivacious with a dance groove. This song is an EDM/Synth Pop song. | 2009-06-27T17:02:38Z | ScottyDynamo | Myspace: http://www.myspace.com/scottydynamo Twitter: http://www.twitter.com/scottydynamo Blog: http://scottydynamo.com Recorded at King West Studio, Toronto, Canada. http://kingweststudio.com/ Verse 1: Don't even trip I got you covered like a placemat/ Shorty keep on starin' I'm like can I have my face back/ I can imagine you've won your share of pageants/ Lay down like a carpet shorty I can play Alladin/ My penmanship is baller, got the wordplay of a scholar/ And I've got men insecure because their bank accounts are smaller/ See her dancing in the spotlight steady throwing out her back and/ All I see is cleavage I should call her Janet Jackson/ Chorus: She's on a roll/ The way she drop it makin' profit down the poll/ She make the people at the party lose control/ The way she drop it makin' profit down the poll/ Oh you can tell that primma donna's on a roll/ Verse 2: She's so primma donna in her Dolce & Gabanna/ Shorty I just wanna see you back it up like a Honda/ Oh she chat it up and I appreciate the banter/ Shorty's Puerto Rican so I couldn't understand her/ I'm wildin' out you know my crew is straight orangutanin'/ Never see me talkin' to a hoochie with her fusions hangin'/ I'm fit to be the kind of lover you deserve/ Met your boyfriend at the party he was serving out or d'oeuvres/ Chorus x2 | ["Music", "Zing"] | ["male vocalist", "electronic music", "fast tempo", "vocal riff", "repetitive", "atmospheric synthesiser", "boomy bass lines", "surround sound", "punchy", "buoyant", "upbeat", "vocal backup", "psychedelic", "trippy", "youthful", "enthusiastic", "lively", "keyboard harmony", "synthesiser arrangement", "infectious drumming", "electronic arrangement", "edm", "dance music", "club music"] | 7 | esIzFH7vYLY | 3902 | |
Glory Official Music Video - Christian / Gospel Music | A female vocalist sings this spirited rap. The tempo is medium with punchy drumming and synthesiser arrangements. The song is youthful,energetic,spirited with a catchy recurring vocal riff. The song is an Electro Rap/Hip-Hop song. | 2012-08-09T04:53:39Z | hillinamusic | Buy "Into the Light" now on iTunes http://itunes.apple.com/us/album/into-the-light-ep/id543561227 To find out more about Hillina or for booking / contact information go to:- http://www.hillinamusic.com "Glory" Everyone suffers in this world, in one form or another. But, for what purpose do we suffer?! The believer is called to share in the sufferings of Christ, so that we may also share in His glory. Paul explains that the sufferings we endure for baring His name are "not worthy to be compared" to the glory that He will reveal in us! Thus, we are to keep our focus on Jesus; the rock of our salvation, as we pass through this earth as pilgrims. Knowing that 'He makes all things work together for the good of those who love Him and are called according to His purpose' (Romans 8:28). Nothing we do qualifies us for His work because He chose 'the foolish to shame the wise'. The work was completed on the cross! Our objective is to give Him what we have (our brokenness, weakness...) so that He may exalt Himself through the most unlikely people and situations and receive ALL the glory and honor through our lives! For Only He is worthy! "... if indeed we suffer with Him, that we may also be glorified together. For I consider that the sufferings of this present time are not worthy to be compared with the glory which shall be revealed in us." -- Romans 8:17-18 "And He said to me, "My grace is sufficient for you, for My strength is made perfect in weakness." Therefore most gladly I will rather boast in my infirmities, that the power of Christ may rest upon me." -- 2nd Corinthians 12:9 "To them God willed to make known what are the riches of the glory of this mystery among the Gentiles: which is Christ in you, the hope of glory." -- Colossians 1:27 "Therefore let those who suffer according to the will of Yahweh commit their souls to Him in doing good, as to a faithful Creator" -- 1st Peter 4:19 "The LORD is my rock, my fortress and my deliverer; my God is my rock, in whom I take refuge. He is my shield and the horn of… | ["Afrobeat", "Music", "Hip hop music"] | ["female singer", "medium fast tempo", "rap", "hip-hop", "female rapper", "passionate", "intense", "rapper", "synthesiser arrangements", "electronic music", "electro rap", "punchy drumming", "drum machine", "bass drum", "psychedelic music", "syncopated", "youthful", "energetic", "enthusiastic", "pop rap", "disco rap", "insistent", "catchy vocal riff", "recurring beat", "dance music", "club", "dj"] | 7 | f8nysknTFUo | 3926 | |
Da Blitz - Moving On (mickey o'hare & dj harmonic remix) | This song is an electronic instrumental. The song is fast tempo with vigorous drumming and electronic instrumentation and synthesiser articulation with catchy synthesised vocal riff which. The song is upbeat, vibrant, vivacious, vigorous, psychedelic, enigmatic and youthful with a trance like dance vibe. This song is an EDM/Synth pop. | 2012-04-17T14:06:31Z | MakinaMuzika | www.facebook.com/makinamuzika | ["Music", "Techno", "Dubstep", "Electronic dance music", "Harmonic"] | ["edm", "instrumental", "fast tempo", "synth pop", "edm", "electronic pop", "electronic instrumental", "synth pop", "dance hits", "rapid tempo", "dance music", "trance", "trap", "psychedelic", "pop", "electronic music", "vigorous drumming", "synthesiser arrangements", "synthesised vocal riff", "recurring vocal riff", "club music", "dance hits", "party hits", "youthful", "energetic", "enigmatic", "enthusiastic", "dj"] | 7 | lGaA1dJQ0AQ | 4387 | |
Roland MV-8800- Moonlight (French House) | This instrumental is an EDM. The tempo is fast with drum machine beats and electronically produced music and sounds.The audio quality is inferior, however the beat melody can be heard. The music is youthful, pulsating, enthusiastic, electric, repetitive, insistent,recurring,trippy , hypnotic, and psychedelic. The thumpy bass and punchy drum beats give it a high energy Dance vibe. | 2013-05-16T16:42:41Z | DJ Galactic | Roland MV-8800- Moonlight (French House) live beat making jam DJ Galactic - Roland MV-8800- Moonlight (French House) "Moonlight" (French House) with Roland MV-8800. Kaoss Pad 3 by DJ Galactic.This music has been created with a live session where I trigger pre recorded sequence on the MV 88000. https://linktr.ee/djgalactic 👌Like / Comment / Sub to Support the Music Lab ✅ http://bit.ly/3tykguW Spotify http://www.djgalactic.com / Official Blog http://dj-galactic.com "Moonlight" © DJ Galactic 2013 all Rights Reserved #electro #frenchhouse #housemusic #Frenchhouse #producer #MV8800 #electronicmusic | ["Drum and bass", "Funk", "Music", "Electronica"] | ["instrumental", "electronic music", "drum machine", "thumpy bass", "punchy drumming", "high energy", "hypnotic", "psychedelic", "trippy", "trance music", "repetitive", "recurring", "insistent", "dj", "dj music", "punchy drumming", "atmospheric keyboard", "percussive electronic music", "dj mixer", "dj", "club music", "dance music", "elctronic arangement", "youthful", "enthusiastic", "energetic", "passionate", "pulsating"] | 7 | mixc4NV5IBE | 4488 | |
BABYMETAL - いいね!- Iine! (OFFICIAL) | A female vocalist sings this powerful Hard rock song. The tempo is medium fast with a vigorous electric guitar feedback, synthesiser articulation and electronic arrangement. The song is youthful, powerful, intense, boisterous, compelling, psychedelic, boomy , punchy and impactful. This song is a Hard Rock/heavy Metal song. | 2012-11-08T08:29:27Z | BABYMETAL | BABYMETAL 1st full album "BABYMETAL" available now!! Available on iTunes Store worldwide & CD web store. Don't miss it!! [iTunes Store] https://itunes.apple.com/us/artist/babymetal/id477101776 [CD web store ASMART] ●BABYMETAL - Limited edition(CD+DVD) http://www.asmart.jp/Form/Product/ProductDetail.aspx?shop=0&cat=100131&swrd&pid=10006479&vid http://www.youtube.com/watch?v=U9oRytBGwYM ●BABYMETAL - Regular edition(CD only) http://www.asmart.jp/Form/Product/ProductDetail.aspx?shop=0&cat=100131&swrd&pid=10006480&vid [CD web store CDJAPAN] http://www.cdjapan.co.jp/search3.html?q=babymetal&media&r=any&step=20&order=score ★ Official Site : http://www.babymetal.jp/ ★ Facebook : http://www.facebook.com/BABYMETAL.jp ★ Twitter : https://twitter.com/BABYMETAL_JAPAN 【Profile】 BABYMETAL【SU-METAL (Vocal,Dance) / MOAMETAL (Scream,Dance) / YUIMETAL (Scream,Dance) 】 Formed in 2010. Their major debut single “ Ijme, dame, zettai" along with 2nd single “Megistune" both ranked in the Top 10 Oricon chart in Japan. In March 2014, they took to the stage of Nippon Budokan for a 2-Days gig making them the youngest female act to ever perform there. Their 1st studio album BAYBMETAL made it into the US Billboard chart. In summer of the same year, they embarked on their first World Tour, performing on the Main Stage at UK’s prodigious festival Sonisphere Festival 2014 in front of 65,000 festival goers, and supporting Lady Gaga on her “ArtRave: The Artpop Ball” 2014 Tour. In fall they were back for additional headline shows in Hammerstein Ballroom, New York City and O2 Academy Brixton, London. In January 2015, they headlined a show at the 20,000 capacities Saitama Super Arena, and in June 2015, they headlined a show at the 25,000 capacities Makuhari Messe. In summer of 2015, BABYMETAL received awards from prominent UK music magazines “Kerrang!” and “METAL HAMMER”. They then performed in front of a staggering 90,000 people at the prestigious Reading and Leeds Festival in August. This December, BABYMETAL are to take the stage again fo… | ["Singing", "Music", "Groan"] | ["female singer", "medium fast tempo", "vocal backup", "loud feedback", "amplified", "boomy", "boisterous", "punchy", "hard hitting", "psychedelic", "synthesiser articulation", "hard rock", "metal", "vocalisation", "auto tune", "turn table", "intense electric guitar feedback", "hard hitting drums", "girl band", "heavy metal", "girl metal band", "enthusiastic", "intense", "powerful", "feminist", "strong", "electronic music", "youthful"] | 7 | qVdBBOpSoN4 | 4790 | |
Elisa - Love Vibration | This music is an electronic instrumental. The tempo is fast with atmospheric synthesiser, digital drum arrangements and an insistent, recurring female vocalisation. The music is upbeat, youthful, trance, trippy, hypnotic, psychedelic, incessant, and enthusiastic EDM/Synth Pop. | 2009-01-22T22:47:43Z | outy1978 | HQ version: http://uk.youtube.com/watch?v=u9n4R78UBtA&fmt=18 Label: FFRR Catalog#: FXDJ 200 Country: UK Released: 1992 | ["Disco", "Music", "Soul music"] | ["instrumental", "fast tempo", "female vocalisation", "electronic music", "digital drumming", "atmospheric synthesiser", "edm", "club music", "dance music", "dj", "dj mixer", "elctronic beats", "youthful", "enthusiastic", "trippy", "trance", "hypnotic", "enigmatic", "trance music", "psychedelic", "disco pop", "contemporary pop", "electro pop", "synth pop", "upbeat", "dance groove"] | 7 | u9n4R78UBtA | 5092 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW musiccaps_details AS select musiccaps.url as video, json_object( 'label', coalesce(videos.title, 'Missing from YouTube'), 'href', musiccaps.url ) as youtube_link, musiccaps.caption as musiccaps_caption, videos.publishedAt as youtube_published, videos.channelTitle as youtube_channel, videos.description as youtube_description, musiccaps.audioset_names as musiccaps_names, musiccaps.aspect_list as musiccaps_aspects, musiccaps.author_id as musiccaps_author, videos.id as youtube_id, musiccaps.rowid as musiccaps_rowid from musiccaps left join videos on musiccaps.ytid = videos.id;