musiccaps_details (view)
13 rows where musiccaps_aspects contains "digital drums" and musiccaps_aspects contains "youthful"
This data as json, CSV (advanced)
musiccaps_aspects (array) 174 ✖
- digital drums · 13 ✖
- youthful · 13 ✖
- club music 9
- dance music 8
- synthesiser arrangements 8
- buoyant 7
- male vocalist 7
- electronic music 6
- fast tempo 6
- psychedelic 6
- dance pop 5
- edm 5
- trap 5
- electronica 4
- energetic 4
- enthusiastic 4
- punchy 4
- spirited 4
- animated 3
- drum machine 3
- groovy 3
- hip-hop 3
- hypnotic 3
- medium tempo 3
- pop 3
- rap 3
- synth pop 3
- techno music 3
- catchy 2
- dance groove 2
- dance hits 2
- deep house 2
- dj 2
- dj mixer 2
- duet 2
- electrifying 2
- foreign language 2
- funky 2
- groovy bass line 2
- instrumental 2
- lively 2
- male singer 2
- medium fast tempo 2
- passionate 2
- repetitive 2
- reverb 2
- rhythmic 2
- rhythmic patter 2
- slick drumming 2
- synthesiser arrangement 2
- trippy 2
- advanced chord structure 1
- ambient mixes 1
- animate 1
- animated instrumentation 1
- atmospheric 1
- atmospheric synthesiser 1
- auto tune 1
- auto tuned voice 1
- boomy bass drops 1
- boomy bass lines 1
- brass band 1
- brass instruments 1
- bright 1
- burgeoning music 1
- camera roll sound 1
- cello drone 1
- chanting 1
- charming 1
- club 1
- cymbals 1
- dance floor 1
- dancing 1
- digital music 1
- digital sound effects 1
- digital soundeffect 1
- dissonant 1
- drum machines 1
- drum rhythm 1
- edm trap 1
- electric guitar lead 1
- electrifying music 1
- electro hop 1
- electro house 1
- electro pop 1
- electro-hop 1
- electronic arrangements 1
- electronic articulation 1
- electronic effects 1
- electronic instrumentation 1
- electronic instruments 1
- electronic sounds 1
- emphatic 1
- engaging 1
- enigmatic 1
- female vocal backup 1
- female vocal riff 1
- female vocals 1
- french love song 1
- french pop 1
- french urbano 1
- funk pop 1
- groovy bass lines 1
- groovy saxophone 1
- happy 1
- heavily synthesised 1
- heavy bass 1
- high notes 1
- high pitched 1
- high spirited 1
- hip-hop pop 1
- house 1
- house music 1
- incessant 1
- incessant beats 1
- insistent 1
- intense 1
- intense drumming 1
- keyboard accompaniment 1
- keyboard harmony 1
- lively piano 1
- lively singing 1
- lively trumpet 1
- male vocalists 1
- medium fast 1
- mellow vocals 1
- melodious 1
- oud cymbals 1
- party music 1
- persuasive 1
- pop rap 1
- pop rock 1
- propulsive beats 1
- pulsating 1
- pulsating beats 1
- punchy beats 1
- punchy drum beats 1
- punchy music 1
- r&b 1
- raper 1
- rave music 1
- shakers 1
- simple 1
- slow beginning 1
- slow tempo 1
- soft paino 1
- song beginning 1
- soulful vocals 1
- southern hip hop 1
- steady rhythm 1
- stimulating 1
- syncopated background harmony 1
- synth rock 1
- synthesiser articulation 1
- tambourine beats 1
- techno hop 1
- throbbing 1
- trance 1
- trance trippy 1
- unobstructive 1
- upbeat 1
- urban pop 1
- vibrant 1
- video game music 1
- vigorous 1
- vigorous drumming 1
- vigorous vocals 1
- vital 1
- vivacious 1
- vocal backup 1
- vocal riff 1
- whirring sound 1
- wind instrument 1
- woodwind 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Slow Bouncin- Juicy J,Trey Songz ft. Wale X Chop Marley | A male vocalist sings this trippy Electronic song. The tempo is slow with synthesiser arrangement, digital drums and electronically articulated music. The song is catchy, youthful, enthusiastic, trippy, psychedelic , new age, and groovy. This song is an Electro -Hop/ Hip-Hop. | 2013-09-13T23:12:07Z | Dab Marley | The Chopstafarian Is back hope y'all like the new tracks......Bless up. | ["Music", "Hip hop music"] | ["male vocalist", "slow tempo", "electronic music", "electro-hop", "edm", "club music", "house music", "electronica", "hip-hop", "techno hop", "synthesiser arrangement", "electronic articulation", "digital drums", "southern hip hop", "punchy", "buoyant", "youthful", "psychedelic", "hypnotic", "trap", "rap"] | 7 | 0RDz0rLakwc | 165 | |
Novo Smartphone Alcatel POP 4 | A male vocalist sings this lively pop. The tempo is fast and peppy with animated trumpets, groovy saxophone, slick drumming, funky bass line, keyboard harmony, synthesiser arrangements and electronic sounds. The song is upbeat, energetic, enthusiastic, youthful, vibrant, effervescent; passionate and electrifying. This song is Synth Pop. | 2016-08-16T22:34:36Z | Alcatel Brasil | Conheça o novo Smartphone Alcatel POP 4. Com tela de de 5", Memória de 40GB, câmera de 13MP e Selfie de 8MP, 4G e ainda vem com 3 Capinhas diferentes. Para mais informações, acesse nosso site oficial: https://www.alcatelshop.com.br/detalhe-produto/smartphone-alcatel-pop4-5-premium-memoria-40gb8mais32-sd-3-capas-camera-13mp-selfie-8mp-flash4g/493310 | ["Music", "Burst, pop"] | ["male vocalist", "fast tempo", "lively trumpet", "synth pop", "funk pop", "electrifying music", "passionate", "vital", "catchy", "engaging", "buoyant", "groovy saxophone", "keyboard harmony", "slick drumming", "synthesiser arrangements", "digital drums", "brass instruments", "wind instrument", "woodwind", "brass band", "rhythmic", "animated", "youthful", "dance music", "club music", "dj", "dance floor", "dance pop", "enthusiastic", "vivacious", "bright"] | 7 | 1pR0SgbqP3M | 313 | |
Per Andersson ''Pump up the Jam'' (Så ska det låta 2012) | This song is a lively duet by two male voices. The tempo is fast with amplified piano, infectious drumming; tambourine beats and synthesiser arrangements. The song is youthful,fun, happy, groovy, energetic, buoyant, and high spirited. This song is called Deep House. | 2012-12-31T17:35:29Z | Theboxen21 | Per Andersson ''Pump up the Jam'' (Så ska det låta 2012) | ["Music", "Ska"] | ["male vocalists", "duet", "fast tempo", "electronic music", "spirited", "buoyant", "club music", "dance music", "dance pop", "techno music", "digital music", "synthesiser arrangements", "deep house", "lively", "youthful", "shakers", "digital drums", "lively singing"] | 7 | 6-MdbipzKS0 | 712 | |
2014 Corolla: AZIATIX - "Baby Let's Go" [OFFICIAL MUSIC VIDEO] | Toyota | A male vocalist sings this enthusiastic Electro Hop. The tempo is fast with synthesiser articulation, Dj mixer and digital drum beats. The song has emphatic, insistent vocals, punchy, youthful, buoyant, funky,strong,psychedelic, persuasive, groovy and untiring. This song is a contemporary Electronic HIp-Hop. | 2013-10-25T05:43:31Z | Toyota USA | AZIATIX partners with Toyota on a brand new single for the all-new 2014 Corolla. It's the highly anticipated track where you're going to get a workout. So baby, let's go! Learn more about the Toyota Corolla or download the free "Baby Let's Go" MP3 at http://www.toyota.com/corollaready (LYRICS) [INTRO NICKY AND EDDIE] Baby let's go-oh-oh Go-oh-oh Don't be afraid to live your life So baby let's go-oh-oh Go-oh-oh Go make your dreams come alive So baby let's go [RAP VERSE FLOWSIK] Follow the leader? I rather follow my heart I look in the mirror see myself yeah look at that star I'm so ready for the bright future Destiny I'm headed right to ya Gather my strength I loads it up them I blows it up like booyah booyah Hand me the mic and I'll never let go, hit the jackpot then it's time to get more In a moment presto, it'll be upward so baby let's go... [VERSE NICKY] Baby let's go-oh-oh Go-oh-oh Don't be afraid to live your life [VERSE EDDIE] So baby let's go-oh-oh Go-oh-oh Go make your dreams come alive [VERSE AZIATIX] Let's Go, go, go, go [CHORUS NICKY AND EDDIE] So baby let's go-oh-oh Go-oh-oh Don't be afraid to live your life So baby let's go-oh-oh Go-oh-oh Go make your dreams come alive So baby let's go [RAP VERSE FLOWSIK] Yeah It's me myself and I, spread my wings I'm feeling so fly I'm ringing on heaven's bell up in the sky, I live for the best 'cuz dreams will never die Turn that key lets get it started // you know I'm gon' ride hard 'til I'm on it From daytime to early morning, I'm going all in, no one can call it I must hang tight whenever destiny calls must get back up whenever I fall Hear me loud let it echo go with the flow, out the door so let's go [CHORUS REPEAT] [VERSE EDDIE] Wherever you go just follow your heart Wherever you go just follow your heart [SYNTH] Let's get it started, started Baby let's go Baby let's go, go Baby let's go Ba-baby let's go places, places [CHORUS NICKY AND EDDIE] So baby let's go-oh-oh Go-oh-oh Don't be afraid to live your life So baby let's go-oh-oh Go-oh-oh Go… | ["Blues", "Music", "Pop music"] | ["male vocalist", "fast tempo", "rap", "hip-hop", "edm", "funky", "drum machines", "electronica", "trap", "dance music", "club music", "electro hop", "heavy bass", "electro house", "edm trap", "rave music", "psychedelic", "hypnotic", "dj mixer", "electronic arrangements", "digital drums", "synthesiser articulation", "rhythmic patter", "vigorous vocals", "youthful", "incessant", "persuasive", "emphatic", "energetic", "enthusiastic"] | 7 | 7avMUhHOCR8 | 865 | |
David ramen - Amour en or | A male vocalist sings this spirited French Pop song. The tempo is medium with electronic music, synth arrangements and slick digital drumming. The song is youthful, peppy, buoyant, perky, catchy, romantic, simple and charming. This song is a contemporary French Urbano. | 2009-03-14T07:26:23Z | Rodrigue Chakode | Crédit montage: Thekknicolas ;) | ["Music of Africa", "Music"] | ["male singer", "medium tempo", "french pop", "french love song", "french pop", "urban pop", "r&b", "french urbano", "synthesiser arrangements", "digital drums", "tambourine beats", "drum machine", "catchy", "buoyant", "punchy", "energetic", "enthusiastic", "youthful", "catchy", "charming", "simple"] | 7 | CPX6f-Awx-0 | 1361 | |
STEPHEN CURRY I SOULJA BOY I OFFICAL MUSIC VIDEO HD 2015 🎵 | A male vocalist sings this HIp-hop. The tempo is medium with subdued keyboard accompaniment, slick drumming, boomy bass drops, synthesised arrangements and vocal backup. The song is youthful; enthusiastic, passionate, insistent, repetitive, groovy,rhythmic chanting with a dance groove. This song is Contemporary Hip-Hop/Rap. | 2016-01-25T22:24:17Z | Mike P | (No copyright infringement is intended) All rights belong to the NBA & ESPN. Entertainment. Music: Soulja Boy - Stephen Curry This for my boy Steph Curry We did it Yeah [Hook] I'm feelin' like Stephen Curry I'm feelin' like Stephen Curry I'm feelin' like Stephen Curry, swish Stephen Curry I'm feelin' like Stephen Curry I'm feelin' like Stephen Curry I'm feelin' like Stephen Curry, swish, swish Stephen Curry, Stephen Curry, Steph Curry Stephen Curry, Steph Curry, swish Steph Curry I'm stuntin' on 'em like I'm Stephen Curry [Verse 1] Steph Curry Number 30 I was stuntin' on 'em, they wouldn't believe me Shootin' 3's from half court, make it look easy I'm the best point guard in the league NBA All day I cross Lebron, shot a 3 in his face Steph Curry, I be Curry with the shot boy I be Chef Curry with pot boy [Hook] I'm feelin' like Stephen Curry I'm feelin' like Stephen Curry I'm feelin' like Stephen Curry, swish Stephen Curry I'm feelin' like Stephen Curry I'm feelin' like Stephen Curry I'm feelin' like Stephen Curry, swish, swish Stephen Curry, Stephen Curry, Steph Curry Stephen Curry, Steph Curry, swish Steph Curry I'm stuntin' on 'em like I'm Stephen Curry [Verse 2] I know that they hate Cause this dope nation Ghost, they want me (?) we made it All we had to do was be some patience So we been patient And I done haters Steph Curry pullin' up with a new drop Steph Curry, make a half court jump shot Hop up out the 'Rari with a lot of guap I'm team Curry (?) [Hook] I'm feelin' like Stephen Curry I'm feelin' like Stephen Curry I'm feelin' like Stephen Curry, swish Stephen Curry I'm feelin' like Stephen Curry I'm feelin' like Stephen Curry I'm feelin' like Stephen Curry, swish, swish Stephen Curry, Stephen Curry, Steph Curry Stephen Curry, Steph Curry, swish Steph Curry I'm stuntin' on 'em like I'm Stephen Curry [Outro] Aye, aye, aye, swish Aye, aye, aye, aye Aye, aye, aye, aye Congratulations my boys Keep doin' your thing boo Know I'm a big fan, nigga Congratulations my boys Forreal Copyright Disclaimer Unde… | ["Music", "Zing", "Hip hop music"] | ["male vocalist", "medium tempo", "rap", "raper", "vocal riff", "reverb", "syncopated background harmony", "hip-hop", "pop rap", "rhythmic patter", "boomy bass lines", "slick drumming", "drum machine", "digital drums", "rhythmic", "chanting", "repetitive", "passionate", "insistent", "keyboard accompaniment", "synthesiser arrangements", "electronic music", "groovy", "dance music", "trap", "trippy", "youthful", "female vocal backup"] | 7 | GwTXkfuc5v8 | 1764 | |
Zina Rifia "houbak nar" by SOFALK, ABDER, NABIL - Rai'n'B Fever 4 | A male vocalist sings this energetic pop song. The tempo is fast with piano accompaniment, bright digital drumming, synthesiser arrangements and groovy bass lines. The song is youthful, fresh, catchy, vivacious, upbeat, sprightly and buoyant with a dance groove. This song is a Hip-Hop Pop song. | 2011-05-01T14:45:49Z | Najim Sofalk | ZINA RIFIA AVEC SOFALK, ABDER, NABIL ET J-BEEZY ... MERCI POUR VOS COMMENTAIRES C'EST JUSTE ENORME !! | ["Music of Africa", "Music"] | ["male vocalist", "medium fast", "foreign language", "pop", "hip-hop pop", "groovy bass line", "lively piano", "digital drums", "synthesiser arrangements", "youthful", "spirited", "dance groove", "club music", "dance pop", "dance music", "groovy", "funky", "youthful", "high spirited"] | 7 | Jk2mvFrdZTU | 2030 | |
► Animash - United State of Pop - MashUp ◄ || Happy New Year ;D || and now 400+ Subbies :) | A male vocalist sings this animated and upbeat pop song. The song starts with a slow tempo with male vocals and soft but emphatic piano accompaniment and cello drone, and a whirring sound like a camera rolling. Post this the song picks up to an upbeat tempo with hard hitting drumming, cymbal rides, upbeat synthesiser harmony and electronic instruments. The song is a ,vibrant, spirited, bouncy, punchy, vivacious, youthful Electronic Dance music/Synth Pop. | 2010-01-02T11:40:42Z | White Liolynx | Edit - on september 13th Huh... I thougt a long time about it, and now... I delete ALL anotations! becasue of problems, too slow video and they were alredy too much! o.o so, hope nobody is angry of me *blush* and thanks you all for 1.000 "likes" on this video =D _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ UPDATE of the January 5th, 2010 : WOW! I get in 3 days 60 new subbies? omfg, THANK YOOOOOOOOOOOOOOOU!! ANNOTATIONS - LINK : - - - (this link is "closed" now, maybe I will write it someday here again xD) hehe, as I saw this remix, I thoght "ooooh my god!...i love it... yay I'm making an animash with it" =D Its for new yeah, but I've had some problems, so its too late =( well, but I hope you like it anyway =) hmm, I think the video looks really simple..but it was hard to work on it =P weeeell... ^^ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ • PROGRAMM : Sony Vegas Pro 9 Song : United State of Pop 2009 (Blame It on the Pop) © DJ Earworm Clips: Bambi 2 Lady and the Tramp 1 and 2 Lion King 1 and 2 Brother Bear 1 Fox and the Hound 1 and 2 Oliver & Co. Aristocats 101 Dalmatians Bolt © Disney/ Pixar Spirit © Dreamworks Balto 1 © Universal All Dogs go to Heaven 2 © MGM Ice Age © Blue Sky Studios HONORS: Second day: #77 - Most Discussed (Today) - Germany #11 - Most Discussed (Today) - Film & Animation - Germany #10 - Top Favorited (Today) - Germany #2 - Top Favorited (Today) - Film & Animation - Germany #20 - Top Favorited (Today) - Film & Animation #24 - Top Rated (Today) - Germany #2 - Top Rated (Today) - Film & Animation - Germany #51 - Top Rated (Today) - Film & Animation #11 - Top Rated (This Week) - Film & Animation - Germany Third day: #50 - Most Discussed (Today) - Germany #4 - Most Discussed (Today) - Film & Animation - Germany #74 - Most Discussed (Today) - Film & Animation #85 - Most Discussed (This Week) - Film & Animation - Germany #46 - Most Viewed (Today) - Germany #86 - Most Viewed (Today) - Film & Animation - Germany #85 - Most Viewed (Today) - F… | ["Music", "Burst, pop"] | ["male vocalist", "slow beginning", "cello drone", "digital drums", "electronic music", "electronic instrumentation", "auto tune", "fast tempo", "edm", "synth pop", "buoyant", "punchy", "vibrant", "animated", "youthful", "spirited", "burgeoning music", "whirring sound", "camera roll sound", "auto tuned voice", "animated instrumentation", "soft paino", "vigorous drumming", "oud cymbals", "vocal backup", "female vocal riff", "song beginning", "pop", "pop rock", "animate", "buoyant", "happy", "lively", "spirited"] | 7 | KMQmM12G9Z4 | 2076 | |
Mt Eden Dubstep - Sarah McLachlan: Silence | A female vocalist sings this trippy vocal riff. The tempo is medium with atmospheric synthesiser and digital drums. The song is heavily synthesised and is psychedelic, intense, enigmatic, mysterious and youthful with a dance groove. This song is an EDM/Electro Pop song. | 2009-06-12T09:12:04Z | Mt Eden Official | ► FREE DOWNLOAD : http://click.dj/mreden/sarah-mclachlan-silence-mt-eden-remix ► Facebook: https://www.facebook.com/MtEdenOfficial ► SoundCloud: http://soundcloud.com/mtedenofficial ► YouTube: http://www.youtube.com/MtEdenDnB08 ► Twitter: https://twitter.com/MtEdenOfficial ► Beatport: http://www.beatport.com/artist/mt-ede... Cheers for all the support . We can't wait to share more with you Enjoy | ["Electronic music", "Music", "Dubstep"] | ["female vocals", "electronic music", "enigmatic", "medium tempo", "atmospheric synthesiser", "electronic music", "high notes", "high pitched", "dissonant", "psychedelic", "heavily synthesised", "drum rhythm", "digital drums", "drum machine", "youthful", "dance music", "dance hits", "pop", "dance pop", "club", "club music", "dance music", "party music", "dance groove", "edm", "trance", "trap", "trippy"] | 7 | Nymjfq2kXnI | 2384 | |
Big Mac Chant挑战 – FS Fuying & Sam 流行曲风 | This song is a vocal duet of male singers in a foreign language . The tempo is medium fast with an animated electric guitar melody, boomy bass drops, digital drums and synthesiser arrangements. The music is buoyant, youthful,punchy, groovy and emphatic with mellow vocals. This song is contemporary Pop. | 2016-10-13T01:58:19Z | McDonaldsMalaysia | 快来学唱FS Fuying&Sam版本的Big Mac Chant挑战歌曲,之后到Smule与他们合唱,再将影片上传到Facebook或Instagram,最后到www.mcdonalds.com.my/mybigmacchant报名参加,就有机会赢取高达RM10,000现金奖,以及与他们见面的机会!马上行动! | ["Music", "Vocal music"] | ["male vocalist", "duet", "medium fast tempo", "foreign language", "electric guitar lead", "boomy bass drops", "synthesiser arrangements", "cymbals", "electronic sounds", "digital drums", "youthful", "energetic", "enthusiastic", "groovy", "punchy music", "mellow vocals", "electro pop"] | 7 | XaqVAF-ADWU | 3201 | |
Big Fat (Original Mix) - Tonic Feat. Tarantula Man | This music is instrumental. The tempo is medium fast with synthesiser arrangements , digital drums and electronic music . The music is upbeat, pulsating, youthful, buoyant, exciting, punchy , psychedelic and has propulsive beats with a dance groove. This music is EDM/Techno. | 2012-04-02T00:42:17Z | xMusicOfTheWorldx | Dont Forget To Susbscribe!!!!! | ["Electronic music", "House music", "Music", "Electronica"] | ["instrumental", "medium fast tempo", "propulsive beats", "psychedelic", "hypnotic", "steady rhythm", "electronic music", "house", "upbeat", "energetic", "pulsating", "electrifying", "youthful", "buoyant", "techno music", "punchy beats", "synthesiser arrangement", "digital drums", "dj", "dj mixer", "dance music", "club music", "synth pop", "electronica"] | 7 | cFIZraIPAXE | 3690 | |
Full Torva + Divine PKing - HIGH RISK! 2b+ | This song is an animated instrumental. The tempo is fast with synthesiser arrangements, intense drumming, groovy bass lines and digital sound effects. The music is upbeat, catchy, compelling, youthful, psychedelic, trance like and intense with an upbeat dance groove. This song is contemporary Synth Pop. | 2011-03-02T22:56:59Z | Pixel Bones | Make sure you thumbs up :)! CRAZY RISK! | ["Music", "Angry music"] | ["instrumental", "fast tempo", "synth rock", "animated", "video game music", "psychedelic", "digital sound effects", "vigorous", "intense", "trap", "trance trippy", "psychedelic", "dance music", "dance hits", "club music", "youthful", "spirited", "groovy bass line", "intense drumming", "synthesiser arrangements", "electronic instruments", "digital drums", "digital soundeffect"] | 7 | pn6toTLXAck | 4734 | |
|Deep house| Cutting Shapes | A male vocalist sings this catchy song. The tempo is fast with synthesiser arrangement, punchy digital drum beats, groovy bass line and melodic vocal backup. The music has a repetitive, catchy vocal riff. It is youthful, punchy, bouncy, thumping, pulsating, and throbbing with soulful vocals and a dance groove. This music is Deep House/Techno pop. | 2014-02-20T00:28:06Z | Simon Boles | ["Disco", "Music"] | ["male singer", "fast tempo", "punchy drum beats", "digital drums", "synthesiser arrangements", "electronic effects", "reverb", "techno music", "edm", "electronica", "dance pop", "club music", "deep house", "pulsating beats", "electrifying", "youthful", "punchy", "throbbing", "buoyant", "psychedelic", "repetitive", "incessant beats", "melodious", "groovy bass lines", "ambient mixes", "atmospheric", "advanced chord structure", "soulful vocals", "unobstructive", "stimulating", "dancing"] | 7 | poxsF3-HeP0 | 4736 |
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;