musiccaps_details (view)
11 rows where musiccaps_aspects contains "male vocalist", musiccaps_aspects contains "rap" and musiccaps_aspects contains "youthful"
This data as json, CSV (advanced)
musiccaps_aspects (array) 132 ✖
- male vocalist · 11 ✖
- rap · 11 ✖
- youthful · 11 ✖
- hip-hop 10
- rhythmic patter 7
- drum machine 5
- passionate 5
- persuasive 5
- punchy 5
- buoyant 4
- rhythmic speech 4
- club music 3
- dance groove 3
- dance music 3
- digital drums 3
- dj 3
- electronic music 3
- emphatic 3
- engaging 3
- medium fast tempo 3
- medium tempo 3
- slow tempo 3
- synthesiser arrangements 3
- trap 3
- vocal backup 3
- boomy 2
- bouncy 2
- chanting 2
- digital drum 2
- dj mixer 2
- edm 2
- electronica 2
- emotional 2
- energetic 2
- enthusiastic 2
- fast tempo 2
- hip-hop hits 2
- hypnotic 2
- insistent 2
- intense 2
- keyboard harmony 2
- pop rap 2
- psychedelic 2
- recurring beat 2
- rhythmic 2
- slick drumming 2
- street vernacular 2
- synthesiser articulation 2
- vocal riff 2
- alternative indie 1
- amateur percussionist 1
- amplified guitar 1
- amplified piano 1
- beat boxing 1
- beep 1
- boomy bass lines 1
- catchy 1
- catchy vocal riff 1
- compelling 1
- digital beats 1
- digital drum arrangement 1
- digital drum imitation 1
- digital drumming 1
- disco rap 1
- drum beats 1
- drum machines 1
- edm trap 1
- electro hop 1
- electro house 1
- electro-hop 1
- electronic arrangements 1
- electronic articulation 1
- energetic vocal backup 1
- female vocal backup 1
- freedom 1
- freestyle rap 1
- funk rap 1
- funky 1
- funky snare drumming 1
- groovy 1
- groovy bass line 1
- groovy bass lines 1
- heavy bass 1
- hip-hop-rap 1
- house music 1
- incessant 1
- inspirational 1
- keyboard accompaniment 1
- kindness 1
- love 1
- low audio quality 1
- melody keyboard 1
- mouth and throat coordinated sounds 1
- objectionable lyrics 1
- peace 1
- percussions 1
- pop 1
- progressive 1
- punk rap 1
- r&b 1
- rap hits 1
- raper 1
- rave music 1
- reggae fusion 1
- repetitive 1
- resilience 1
- reverb 1
- rhythm arrangement 1
- rhythmic beat 1
- skilled 1
- slang 1
- slangy lyrics 1
- soul 1
- southern hip hop 1
- steady drumming 1
- story telling 1
- street rapper 1
- subtle bass 1
- syncopated background harmony 1
- syncopated piano accompaniment 1
- synth articulation 1
- synthesiser arrangement 1
- techno hop 1
- trippy 1
- turn table 1
- turn table imitation 1
- vigorous 1
- vigorous vocals 1
- vocal percussion 1
- vocal percussionist 1
- vocal turntablism 1
- vocalisation 1
musiccaps_names (array) 12 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Narcy featuring Shadia Mansour "Hamdulillah" Official Music Video | A male vocalist sings this Rap. The tempo is slow with enthusiastic drumming, syncopated piano harmony, digital beats ,keyboard arrangements with vocal backup and a catchy vocal riff. The rap is catchy, youthful, insightful, enthusiastic, intense, passionate, emotional and persuasive. This song is contemporary Rap/Hip-Hop. | 2010-09-14T17:43:13Z | IRAQ-A-FELLA | Available on iTunes, Shazam, Rdio, Anghami and AmazonMP3 Follow The Narcicyst Facebook: https://www.facebook.com/Narcicyst Twitter: http://www.twitter.com/TheNarcicyst Insta: http://www.instagram.com/narcynarce http://www.thenarcicyst.com The Narcicyst featuring Shadia Mansour - "Hamdulillah" (Official Music Video) Directed and Edited by Ridwan Adhami Written by Yassin Alsalman and Shadia Mansour Original Track produced by SandhiLL Piano by Stefan Christoff Additional production and arrangement by Doctor Dinar and The Narcicyst To say 'Hamdulillah' is to be grateful for what one has. The images of the past decades have cast a veil on our identity as a people. We, as international brothers and sisters, are now witness to injustice in real time. We watch our Wars in HD. It is time for us to claim our faces back. This video is a global collaborative effort by 10 photographers- from London to Lebanon, Cairo To Canada, Abu Dhabi to America- to create a portrait of the New Global Citizens. They are DJs, MCs, poets, architects, teachers, doctors, parents and children. Most of all they are people. Thank you to everyone that was involved. We are blessed to have each other. LYRICS Bismillah, like the feeling when I miss Falah, then wish to God in clouds to lift us all Hamdulilah, wonder if Bibi can ever see me, and if I back to Basrah will it ever receive me, Bismillah, homies that have the time to talk, Now I wish to stars that angel find Nawaf. Hamdulillah, I stand awed at the strength of my sister Kiss her and thank God our mission is planned for us. Bismillah, mamati inti hayati, moms the best one, hold her close to heart like my left lung Hamdulillah, for the truth in a being as beaming the moon queen you blessed my future to be with Bismillah, for the souls anguish, love, and the moment my brothers programmed these drums, Hamdulillah, We put the truth to the test, proof that we're blessed students of this music at best. Bismillah, Before I spit this bar, way Before Militants tried to split t… | ["Music", "Pop music", "Middle Eastern music"] | ["male vocalist", "slow tempo", "hip-hop", "rap", "progressive", "vocal backup", "youthful", "funky snare drumming", "digital beats", "syncopated piano accompaniment", "groovy bass line", "synthesiser arrangements", "persuasive", "story telling", "rhythmic patter", "rhythmic speech", "intense", "passionate", "emotional", "intense", "vocal riff"] | 7 | 0ISHZQJdeSw | 142 | |
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 | |
Amazing beatboxing, you won't believe it! (original, full) | This music clip is of a male vocalist doing a beat box. The tempo is medium fast with the vocalist imitating the digital drums, turntable and Dj mixer to a perfection. This vocal percussion is lively, rhythmic, youthful and engaging. | 2010-02-07T14:15:29Z | Karesz Fromvald | This is the uncut, original and full version of the beatboxing, no camera-changing. This guy is beatboxing like you never heard! MUST SEE! He is Joseph Poolpo, he is from France - thanks for the comment. This is a show, called Nouvelle Star, it's like America's Got Talent, the france version of the talent show. What's the best part? Can you do better? Write in the comments section below. I can't believe it's true! Amazing! Really Cool beatboxing! America's got talent THANKS FOR MORE THAN A MILLION VIEWS!!! #48 - Most Viewed - Music - Israel #37 - Most Viewed - Music - France #52 - Most Viewed - Music - Italy #33 - Most Viewed - Music - Czech Republic #30 - Most Viewed - Music - Czech Republic #18 - Most Viewed - Music - Israel #89 - Most Viewed - Israel #58 - Most Viewed - Music - France Thank you. -REUPLOADED | ["Beatboxing", "Music"] | ["vocalisation", "medium fast tempo", "male vocalist", "punchy", "boomy", "buoyant", "rap", "dance groove", "vocal percussionist", "youthful", "rhythmic", "skilled", "engaging", "beat boxing", "turn table imitation", "vigorous", "youthful", "vocal percussion", "vocal turntablism", "mouth and throat coordinated sounds", "dj", "hip-hop-rap", "digital drum imitation"] | 7 | 0abzD7hBTRk | 187 | |
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 | |
ROCAFELLA FREESTYLES: PT.1 "WHO SHOT YA?" | A male vocalist sings this passionate Hip-Hop. The tempo is medium fast with synthesiser articulation, digital drumming and turn table effects with vocal backup. The song is enthusiastic, passionate, persuasive, emphatic, emotional , youthful and groovy. This song is a freestyle Hip-Hop. | 2008-11-03T18:30:55Z | Cipha Sounds | CIPHA SOUNDS HAS DUG INTO THE VAULT TO FIND THIS NEVER BEFORE SEEN VIDEO OF THE ROCAFELLA CAMP FREESTYLING ON FUNKMASTER FLEX SHOW ON HOT97 FROM 2001! | ["Scratching (performance technique)"] | ["male vocalist", "medium fast tempo", "persuasive", "insistent", "turn table", "rap", "hip-hop", "dj", "dj mixer", "youthful", "emphatic", "youthful", "rhythmic speech", "rhythmic patter", "street vernacular", "rhythmic beat", "punchy", "buoyant", "freestyle rap"] | 7 | C5Zs-Lb2rIM | 1328 | |
R.A The Rugged Man - Midnight Thud | A male vocalist sings this passionate Rap. The tempo is medium with steady drumming, keyboard harmony, amplified piano accompaniment, and groovy bass lines . The song is emotional, intense, persuasive, intense and has a catchy groove. This song is contemporary Rap/Hip-Hop. | 2008-09-10T09:04:15Z | Markus Priebe Jakobsson | The song Midnight Thud by the rugged man, with lyrics. | ["Music", "Rapping", "Hip hop music"] | ["male vocalist", "medium tempo", "hip-hop", "rap", "rhythmic patter", "rhythmic speech", "slang", "objectionable lyrics", "passionate", "emotional", "intense", "emphatic", "persuasive", "catchy", "youthful", "steady drumming", "melody keyboard", "amplified piano", "groovy bass lines"] | 7 | CrbZHPkHeV4 | 1407 | |
Matisyahu - One Day featuring Akon | A male vocalist sings this enthusiastic hip-hop song. The tempo is medium fast with a lively keyboard harmony, slick drumming, subtle drumming, cymbals, synthesiser arrangements and enthusiastic vocal backup. The song is lively, spirited, youthful, passionate, emotional and persuasive. It talks about love, peace, freedom,harmony and kindness towards humankind. This song is a Reggae Fusion/ Hip-Hop song. | 2010-01-13T21:27:05Z | Matisyahu | Matisyahu's One Day featuring Akon Matisyahu on tour now! http://matisyahuworld.com/tour/ MATISYAHU TOUR DATES *with Rebelution 8/7 Albuquerque,NM Sandia Amphitheatre* 8/8 Phoenix, AZ Mesa Amphitheatre* 8/9 Costa Mesa, CA Pacific Amphitheatre* 8/10 San Diego, CA Open Air Theatre* 8/11 Sacramento, CA Ace of Spades 8/12 Boise, ID Knitting Factory 8/13 Missoula, MT Big Sky Brewery* 8/14 Seattle, WA Marymoor Amphitheatre* 8/16 Eugene, WA Cuthbert Amphitheatre* 8/17 Berkeley, CA Greek Theatre* 8/18 Santa Barbara, CA Santa Barbara Bowl* 8/20 Jacksonville, OR Britt Pavilion* 8/21 Stateline, NV Montbleu Outdoor Arena* 8/22 Las Vegas, NV The Pool at Cosmopolitan* 8/23 Salt Lake City, UT The Complex* 8/24 Morrison, CO Red Rocks Amphitheatre 8/25 Kansas City, MO Crossroads KC 8/26 Des Moines, IA Wooly's 8/27 Minneapolis, MN First Avenue 8/28 Madison, W The Majestic 8/29 Bloomington, IL Castle Theatre 8/31 Ft. Wayne, IN Piere's 9/1 Cleveland, OH House of Blues 9/3 Joliet, IL Mojoes 9/7 Philadelphia, PA Penn's Landing* 9/8 Asbury Park, NJ Stone Poney Summerstage* 9/9 Clifton Park, NY Upstate Concert Hall 9/10 New York, NY Central Park Summerstage* 9/11 Baltimore, MD Pier Six Concert Pavilion* 9/12 Charlotte, NC The Fillmore* 9/14 Atlanta, GA The Tabernacle* 9/15 Norfolk, VA The Norva 9/16 Wilmington, NC Brooklyn Arts Center 9/17 Orlando, FL Hard Rock Live Follow Matisyahu on Facebook http://www.facebook.com/matisyahu Follow Matisyahu on Twitter: http://www.twitter.com/matisyahu | ["Music of Africa", "Music"] | ["male vocalist", "medium fast tempo", "keyboard harmony", "subtle bass", "synthesiser articulation", "energetic vocal backup", "drum machine", "digital drum", "slick drumming", "alternative indie", "r&b", "soul", "pop", "resilience", "kindness", "freedom", "love", "peace", "inspirational", "youthful", "reggae fusion", "hip-hop", "rap"] | 7 | D8zK7PHIkgA | 1443 | |
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 | |
Hadiya Deville..Make it Ping Pong...mpg | A male vocalist sings this spirited hip-hop. The tempo is fast with synthesiser articulation, digital drum arrangements and vocal backup. The music is a youthful , enthusiastic, bouncy, punchy rhythmic patter with a dance groove. This song is contemporary Hip-Hop/ Rap. | 2011-11-26T16:20:24Z | Loc Deville | This is a Must See Video..2 Year old Hadiya Shaheed..aka Hadiya Deville..Rocks Out, to her Fathers New Single ''Make it Ping Pong''.. ---Talent is in the D.N.A..--SEE FOR YOUR SELF :) | ["Music", "Rapping", "Hip hop music"] | ["male vocalist", "fast tempo", "hip-hop", "rap", "bouncy", "punchy", "funk rap", "punk rap", "rhythmic patter", "rhythmic speech", "engaging", "passionate", "energetic", "enthusiastic", "vocal backup", "recurring beat", "youthful", "keyboard harmony", "digital drum arrangement", "drum machine", "synth articulation", "vocal backup", "dance groove", "dj", "club music", "dance music", "hip-hop hits"] | 7 | QBMM1ocXkhY | 2602 | |
Pete Kolo Feat Chop Chop - "Help Wanted" | A male vocalist sings this spirited rap. The tempo is medium with keyboard accompaniment, digital drums,electric guitar riff and synthesiser arrangements with vocal backup. The song is passionate, compelling, strong telling, chanting, persuasive and youthful. This song is Contemporary Rap-Hip-Hop. | 2012-09-11T19:47:40Z | 2beyond1 | #Theanbm Pete Kolo releases single "Help wanted" ft. Chop Chop #SOB Anbm.inc@gmail.com @Theanbm @PeteGotBeats @ChopChop_SOB Director: @Stedy4dog , 2DCProductions | ["Music", "Rhythm and blues"] | ["male vocalist", "medium tempo", "rap", "rap hits", "digital drum", "youthful", "street rapper", "disco rap", "hip-hop", "hip-hop hits", "rhythmic patter", "electronic music", "drum machine", "synthesiser arrangements", "vocal backup", "passionate", "engaging", "compelling", "persuasive", "street vernacular", "slangy lyrics", "chanting", "recurring beat", "amplified guitar"] | 7 | SxYnb9_qDtk | 2800 | |
Runescape Dungeoneering Guide - Doors [HD] | This song has a male vocalist singing a rhythmic vocal riff to the beat of digital drumming followed by the sound of a beep. The percussion is amateur and the vocals are muffled as the audio quality is inferior. The song is slow tempo and the beat is punchy, groovy, buoyant and youthful. | 2010-10-15T16:30:46Z | adamchrome | This video shows the different doors that you can encounter during a dungeon and how to complete them all. Doors in dungeoneering are very important in exploring the floor as these are the gateways between rooms. You must know how to bypass all the doors you can be faced with in order to fully explore a dungeon. There are 3 main types of doors: Locked doors requiring a key to open Guardian doors protected by the monsters in the room Skill doors blocked by an obstruction requiring a skill and/or item to bypass Locked doors are opened with keys that can be found throughout the dungeon. One player, known as the key holder, should carry all the keys so that it is easy to manage which keys the team has. If a locked door is a very long way away from the starting room and your team doesn't have the correct key, then it is highly advisable for a team member to place a gatestone at the door to avoid time running through the dungeon. --------------------------------------------------- Guardian doors are doors which can't be opened until all monsters in the room have been killed, except for the dinosaurs. When you are clearing a guardian room with your team, there is a certain order that players should kill the monsters, based on their difficulty. As a basic principle, all monsters that can see through the shadow-silk hood should be eliminated first. Even if you don't own a silk hood, other team members will take less damage when they're dead resulting in less food used in the long run. Mages - Mages should be killed first because of their damaging magic attack and their ability to negate the effects of the shadow-silk hood. Forgotten mages and Necromancers fall under this category. Shades - Shades and ghosts are highly dangerous due to their highly damaging range and magic attacks. Demons and other mages - Lesser, greater and black demons hit quite considerable amounts of damage with magic and melee. Spiders - Spiders should be killed after the dangerous mages because of their poisoning ab… | ["Busy signal", "Music"] | ["percussions", "drum machine", "boomy", "catchy vocal riff", "digital drumming", "youthful", "buoyant", "punchy", "bouncy", "dance groove", "amateur percussionist", "male vocalist", "slow tempo", "pop rap", "low audio quality", "rap", "hip-hop", "beep", "drum beats", "rhythm arrangement"] | 7 | YZx0_GRtvJk | 3295 |
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;