musiccaps_details (view)
21 rows where musiccaps_aspects contains "cheering" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
| video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
|---|---|---|---|---|---|---|---|---|---|---|
| The Muddy Hill Boys - Bluegrass To Rockin'The Country Jamboree | A group of male vocalists sing this happy, upbeat country /bluegrass song. The tempo is fast with vigorous and animated acoustic guitar, banjo, mandolin and auto harp lead and harmony. The song is a live performance with ambient sounds of clapping, cheering and people talking. This song is a cheerful Country Pop/Bluegrass song. | 2015-04-05T21:37:46Z | chrisdixie1 | https://www.facebook.com/themuddyhillboys?fref=ts Rockin' The Country Jamboree N°1 - à TOURS 37 FRANCE organisé par DiscOldies le 28/03/2015 | ["Banjo", "Country", "Music", "Rock and roll", "Bluegrass"] | ["male vocalists", "fast tempo", "cheerful", "happy", "acoustic guitar", "vigorous banjo", "auto harp", "mandolin", "ambient noises", "clapping", "cheering", "people talking", "live performance", "gig", "concert", "cheering", "country music", "country folk music", "bluegrass", "inferior audio quality", "amateur recording", "lively", "spirited", "enthusiastic", "vivacious", "youthful", "happy", "celebratory", "festive"] | 7 | 0XxinBtKouQ | 179 | |
| Shira Choir Rocking it away with Pinky Weber Music by Pinny Ostreicher | A male vocalist sings this spirited song. The tempo is fast with trumpets, keyboard harmony, steady drumming and simple bass lines along with vocal backup. The song is happy, energetic, enthusiastic, popular, peppy, vivacious and celebratory. There are sounds in the background of people talking, hooting, cheering and scuttling and rustling. This is a popular Folk/Regional song. | 2015-09-04T19:04:46Z | Go Jewish Music | At a Siyem in Upstate! | ["Singing", "Music", "Ska", "Music of Latin America"] | ["male singer", "fast tempo", "vocal backup", "popular songs", "hooting", "rustling", "home video", "amateur recording", "party songs", "foreign language", "lively trumpets", "keyboard harmony", "steady drumming", "straight bass lines", "vocal backup", "people talking", "cheering", "energetic", "happy", "enthusiastic", "home video", "inferior audio quality", "folk song", "regional music", "happy", "peppy", "chirpy"] | 7 | 1hABzqBHh7w | 297 | |
| Guantanamera - Steel Drum Music (Kool Vibes and Carlton) | This music is instrumental. The tempo is fast with a lively keyboard harmony, steady drumming, groovy bass lines and harmonica melodic. The song is fresh, groovy, sunny, happy; vivacious and spirited. The song is a live performance outdoors as there are ambient nature sounds like the breeze,and sound of people talking. | 2010-05-02T01:44:59Z | nineeighttwo | Kool Vibes with Carlton (Stick 2 Pan) on Steel Drums. St. Lucian band which performs in Florida, Georgia, Carolinas, New York, Texas...East and West coast. | ["Music", "Steelpan"] | ["instrumental", "fast tempo", "lively", "fresh", "breeze", "people talking", "clapping", "cheering", "tambourine beats", "youthful", "simple vivacious", "ambient nature sounds", "people talking", "keyboard harmony", "lively drums", "groovy bas line", "harmonica melody"] | 7 | 1j13NdQiw8c | 301 | |
| Groom performs surprise Flash Mob Dance for his Bride | A male vocalist sings this upbeat pop song. The tempo is medium fast with thumping drum beats, percussion instruments, ukulele melody, keyboard accompaniment and rhythmic guitar. The audio is muddled making it difficult to hear the finer elements of the song. The song is energetic, enthusiastic, happy, fresh, peppy, perky , groovy. There is background chatter, clapping, cheering and rustling. The song is a Pop Rock/Alternative Indie. | 2014-09-02T16:09:17Z | Blue Kite Cinema | http://facebook.com/BlueKiteCinema Michael put together a flash mob dance with 80 friends and family members and surprised his new wife, Jessica, with it on their wedding day! This is a little teaser video including that dance and a few snippets from their day. | ["Music", "Tap"] | ["male singer", "fast tempo", "happy song", "groovy", "ukele melody", "acoustic guitar", "keyboard accompaniment", "emphatic vocals", "vocal backup", "energetic", "peppy", "buoyant", "dance grove", "party song", "club music", "muffled sounds", "boomy drumming", "strong drum beats", "clapping", "cheering", "happy", "peppy", "cheerful", "muddled audio", "synthesiser", "percussion grooves", "african percussion", "thumping music", "indie pop", "ukele"] | 7 | 3fqWosszpnE | 492 | |
| Bicycle Piano -Mickey Mouse March | A male vocalist sings this energetic song. The tempo is fast with a spirited piano accompaniment and ambient street noises like vehicles, people talking and breeze. There is a sound of clapping and cheering indicating that this is a live street performance. The audio quality is inferior causing static and muffled sounds.This song is a cheerful, animated, spirited, happy, chirpy and bouncy pop. | 2007-10-08T15:21:12Z | M K | Who the leader of the club that made for you and me! | ["Applause", "Music"] | ["male vocalist", "fast tempo", "piano harmony", "bouncy", "chirpy", "animated", "vivid", "vivacious", "ambient street sounds", "inferior audio quality", "mufffled audio", "catchy riff", "animated singing", "enthusiastic paino", "catchy vocal riff", "clapping", "people talking", "cheering", "vehicle sounds", "live performance", "gig", "concert", "street performance", "busking", "busker"] | 7 | 6ragcEJVErI | 792 | |
| DELIJE - HELL Rises at The NORTH GATES | This song is an instrumental. The tempo is medium with an enthusiastic keyboard harmony, steady drumming and boomy bass lines with rustling , whooshing sounds, muffled voices of people cheering or chanting and crackling sounds. The song is intense, passionate, youthful, inspiring, impactful and fervent. The audio quality is inferior so the music is muddy and incoherent. | 2008-06-02T21:36:25Z | noztankz | What really goes on behind the NORTH GATES of the Marakana.... | ["Music", "Angry music"] | ["instrumental", "intense musical medium tempo", "inspiring", "impactful", "cheering", "muffled sounds", "muffled audio", "crackling sound", "people chanting", "keyboard harmony", "boomy bass line", "steady drumming", "youthful", "energetic", "urgent", "passionate", "fervent", "ardent", "inferior quality audio", "rustling sound"] | 7 | 8WnXfe3ud4E | 924 | |
| Awesome Yodeling - 12 year old Yodel Expert!! | A female vocalist sings this upbeat country song. The tempo is fast with enthusiastic fiddle, banjo, resonator, mandolin and dobro accompaniment, tambourine beats, keyboard harmony, bright drumming and groovy bass lines. There is sound of clapping, cheering, people talking, party horns and hooting superimposed on the song, indicating that this is a live performance. The song is a spirited, lively,happy, punchy and buoyant Country Song. | 2009-09-08T15:22:16Z | dollarforeddiedotcom | This girl learned how to yodel from a tape and a yodeling book. That's some crazy yodeling! Presented for your viewing pleasure by: The Dollar for Eddie Channel! Send a dollar to support a writer's dreams, read some stories, and BE ENTERTAINED along the way. That little dollar will support a good cause! My name is Eddie, and I'm a starving artist. Or, rather, a starving writer. Living paycheck to paycheck, I've had a hard time making ends meet and still have the time to develop my writing career. Donate a simple, single dollar, and get a little something cool in return! Mail it, with your name and a short message (if you wish), to: P.O.Box 60387 Colorado Springs, Co 80960 Visit my website, http://DollarForEddie.com, to see more information, be entertained, and find out exactly what your donation will buy! http://DollarForEddie.com | ["Applause", "Music"] | ["female vocalist", "fast tempo", "country song", "live audience", "stage performance", "clapping", "cheering", "applause", "hooting", "country music", "regional folk", "fiddle", "resonator", "banjo", "mandolin", "infectious drumming", "funky bass", "keyboard rhythm", "spirited", "lively", "energetic", "upbeat", "happy", "infectious engaging", "live performance", "gig"] | 7 | B00nfVc4FPI | 1192 | |
| GTA 5 FUNNY MUSIC VIDEOS! (GTA V FUNNY MOMENTS) | The Hip Hop song features a passionate female vocal singing and flat male vocal rapping over piano chords, punchy kick and snare hits, repetitive synth hits and sustained strings melody. At the end of the first section there is an echoing effect on vocals. It sounds energetic and addictive, even though the audio cuts out in the middle of the chorus, straight to the verse. | 2016-04-21T18:30:00Z | GTA5Videos | A BRAND NEW EPISODE OF GTA 5 FUNNY MUSIC VIDEOS! Want more GTA V Funny Moments, Fails, Music Videos, Mods and more? Then make sure to hit that Subscribe button! ★ HELP US TO 1 MILLION SUBSCRIBERS! http://bit.ly/350ksubs ツ Creator here: https://www.youtube.com/channel/UCeQPpxV8dXffd7XRhXq48Uw Song list: Smooth Criminal - Michael Jackson My Way - Fetty Wap Me,Myself,and I - G-Eazy x Bebe Rexha In Too Deep - Sum 41 Chumbawamba - Tubthumping Timber - Kesha ft.Pitbull Uma Therman - Fall Out Boy Just Dance - Lady Gaga Rocky Theme "Gonna Fly Now" Daddy - PSY Nasty Freestyle - T-Wayne Gives You Hell - American Rejects I Don't Fuck with You - Big Sean ft. E-40 Grind On Me - Pretty Ricky Watch Out - 2 Chainz Girl on Fire - Alicia Keys Fire Water Burn - Bloodhound Gang No Flex Zone - Rae Sremmurd Another One Bites the Dust - Queen Swag on - Souja Boy Teenage Dirtbag - Wheetus Be a Billionaire - Travie McCoy ft.Bruno Mars In the End - Linkin Park Candy Shop - 50 Cent Hot in Here - Nelly My Band - D-12 Cut It - O.T. Genesis ft.Young Dolph Work - Rihanna ft.Drake Gangsta's Paradise - Coolio ft. L.V R. Kelly - I Believe I Can Fly Macklemore & Ryan Lewis - Downtown Outro Song: Golden Skies by Liam Aidan ------------------------------------------------------------------------------ How to submit a video to GTA5Videos: 1: Upload a video to youtube. 2: Go on our channel and send it to us via 'Send message'. 3: In the youtube message let us know that we're are allowed to upload it & put the link to the video in that message. ------------------------------------------------------------------------------ Playlists: GTA 5 Funny Moments: http://goo.gl/XokJvv GTA 5 Funny Music Videos: http://goo.gl/qeWtAz GTA 5 Mods: http://goo.gl/1mZ3r5 Twitter: http://goo.gl/mJDKLa Facebook: http://goo.gl/JuH3Sn ------------------------------------------------------------------------------ Please respect each other in the comment section! ツ Wondering what kind of promotions we offer? Ask here: http://bit.ly/Getshoutouts | ["Music", "/t/dd00032"] | ["hip hop", "piano chords progression", "repetitive synth hits", "passionate female vocal", "flat male vocal", "punchy snare", "punchy kick", "cheering", "audio cutout", "echoing effect", "sustained strings melody", "energetic", "addictive"] | 4 | FaD9qs2ACpI | 1653 | |
| Lydia 5 yrs.old wins the Taylor Ware Yodel On Contest!! | A female vocalist sings this rather vigorous country song. The tempo is fast with vocalisation. The vocalist is yodelling vigorously and rhythmically to the accompaniment of an animated banjo, fiddle, resonator and mandolin harmony, vibrant drumming and. | 2008-08-12T02:50:34Z | Epps Music | Lydia yodeling Cowboy Sweetheart at Taylor Ware's Yodel On Contest in Tenn. | ["Singing", "Yodeling", "Music", "Song"] | ["female vocalist", "fast tempo", "falsetto", "high notes", "resonator", "people clapping", "cheering", "breeze", "ambient nature sounds", "energetic vocals", "spirited drumming", "vigorous banjo accompaniment", "mandolin", "fiddle", "dobro", "rapid singing", "energetic", "vocalisation", "spirited", "enthusiastic", "normal voice to falsetto", "rapid change in pitch"] | 7 | GuQFhmGqdog | 1760 | |
| Super Bowl Shuffle.wmv | This clip is an amateur recording with very muffled audio. The song sounds like a lively chant, with women giggling, people talking and a booming , echoing voice that sounds like an announcement. | 2011-01-07T04:12:03Z | dapokeXmen | Super Bowl Shuffle video from Byron, Il lip sync contest in 2006 | ["Music", "Shuffle"] | ["muffled audio", "chanting", "people talking", "booming voice", "announcement", "clapping", "hi-fi", "feet scuttling", "cheering", "giggling", "echoing", "muddled singing", "rhythmic chant", "noisy", "busy"] | 7 | IS5V2yjPp3k | 1907 | |
| Best Mehndi Dance 2012 - DhoomBros | This music is an electronic dance instrumental. The tempo is fast with synthesiser arrangements, digital drumming, DJ mixer and electronic effects. The sound quality is inferior and muffled with static and booming sounds. The performance is live with ambient sounds of people whistling, cheering and talking. This is an Electro Pop instrumental. | 2012-09-11T20:59:32Z | DhoomBros | https://www.facebook.com/DhoomBrosOfficial http://www.dhoombros.com/ https://www.facebook.com/IHussainAsif https://www.facebook.com/ishehry https://www.facebook.com/iAtifKhan https://www.facebook.com/iWaqasRiaz https://twitter.com/iHussainAsif http://twitter.com/#!/oyeshehry http://twitter.com/#!/atifron http://twitter.com/l3films Subscribe, Comment, Share, Thumbs UP! | ["Scratching (performance technique)", "Music", "Inside, large room or hall"] | ["instrumental", "fast tempo", "electronic music", "futuristic", "fourth world music", "punchy", "buoyant", "electrifying", "pulsating", "inferior audio quality", "booming sounds", "muffled audio", "drum machine", "dj mixer", "whistling", "people talking", "cheering", "live performance", "dance music", "electro pop", "edm"] | 7 | KyjeM7J-Pz4 | 2137 | |
| butterfingers epitome at harmonic may ochestra MCPA | The low quality recording features a live performance including resonating bass, energetic drums and strings melody. The recording is in a terrible condition, as the bass is resonating much and the sound is overall muffled and muddy. There are some cheering and clapping sounds from a crowd. The listener can barely hear the instruments, as it sounds chaotic. It was definitely recorded with a phone. | 2008-05-16T03:40:16Z | arsany arsad | long lost but not forgotten song.. | ["Music", "Rock and roll", "Harmonic"] | ["low quality", "crowd cheering", "muffled sound", "resonating bass", "live performance", "strings melody", "energetic drums", "cheering", "clapping", "chaotic"] | 4 | LwmwCpAVPWU | 2229 | |
| Chicas Roland's - Cumbia - El Hijo De Tuta | A female vocalist sings this Spanish melody. The tempo is medium with keyboard harmony, tambourine beats, rhythmic congas and acoustic guitar. The song is upbeat, buoyant, groovy, lively, spirited,youthful and engaging. This is an outdoor live performance as there are ambient sounds like gentle wind, people talking, clapping and cheering. This song is a lively Spanish Pop song. | 2008-06-13T21:36:48Z | Palmeras Disco | Video "del Baul De Los Recuerdos" de Las Chicas Roland's interpretando la cumbia "El Hijo De Tuta" en Junio del 2002. Espero les guste... | ["Singing", "Music", "Rattle (instrument)"] | ["female singer", "medium tempo", "pop", "spirited", "lively", "buoyant", "engaging", "vivacious", "spanish", "amateur recording", "muffled audio", "acordion harmony", "congas beat", "keyboard accompaniment", "rhythmic acoustic guitar", "live performance", "outdoors", "ambient sounds", "people talking", "cheering", "clapping", "inferior audio quality", "groovy dance beat", "buoyant", "youthful", "tambourine beats"] | 7 | Py8Vd0-qxYU | 2583 | |
| Eddie Santiago Live - Mia | This song is a spirited Latin instrumental. The song is fast tempo with distorted keyboard harmony, electric guitar and percussion with some vocalisation. The song quality is inferior but the vibe of the song is upbeat, peppy, happy, celebratory, energetic with the sound of chatter in the background. This song is Latin pop. | 2008-03-24T14:32:02Z | Fernando Escobar | Eddie Santiago Live - Mia | ["Music", "Steelpan"] | ["congas", "muffled sounds", "keyboard accompaniment", "crowd chatter", "cheering", "percussion", "fast tempo", "electric guitar riff", "inferior audio quality", "vocalisation", "energetic", "happy", "merry", "buoyant", "latin music", "latin folk", "latin pop", "latin dance music", "celebratory"] | 7 | QVpsAY9oR_4 | 2624 | |
| Safe Sane and Single - Comedy Tap (retro) | A male vocalist sings this energetic song. The tempo is fast with accordion harmony, funky bass lines, vigorous drumming,rhythmic acoustic guitar and keyboard harmony. The audio is muffled making it difficult to hear the other elements in the song. This song is a live performance as there are sounds of clapping, cheering and people murmuring. This song is a vibrant,vivacious,bright, punchy, and energetic Pop. | 2007-10-29T08:51:30Z | FatLane | Another one from the archives. | ["Singing", "Music", "Tap"] | ["male vocalist", "fast tempo", "animated music", "clapping", "live performance", "people talking", "cheering", "accordion melody", "vigorous drumming", "keyboard harmony", "steady bass lines", "acoustic guitar", "lively vocals", "inferior audio quality", "muffled audio", "crowd cheering"] | 7 | ZgooDijn2as | 3403 | |
| Melanie Moore Auditions | This is a recording of a piano song being played on a speaker. There is a live audience that cheers and applauds. The song feels light and whimsical. | 2011-05-28T14:56:46Z | cabaret2006 | She's amazing... I wish she's through to Live shows... | ["Music", "Vibraphone"] | ["live recording", "audience applause", "piano playing", "cheering", "bright", "light"] | 3 | aUx0xMF9pwU | 3547 | |
| 【東方】TAM TOHO Violin LIVE! 05 ナイト・オブ・ナイツ Night Of Knights | This music is an animated instrumental. The tempo is very fast with a violin playing a very vigorous and upbeat amplified violin harmony with synthesiser arrangements and punchy digital drumming.The music is pulsating, energetic, enthusiastic, throbbing, youthful,powerful, compelling, engaging and untiring. The audio quality is inferior and there are sounds of hustling,people clapping along, chatting and cheering Indicating that this is a live performance. | 2010-05-18T13:53:31Z | TAM [タム] ViolinPiano 放浪のバイオリニスト | Violin:TAM(TAMUSIC) バイオリン：タム（タムシック） 二次創作：ビートまりお（COOL&CREATE）http://cool-create.cc/ ZUN (上海アリス幻樂団) : Original Violin:TAM http://tam3.name/ Product:TAMUSIC http://tamusic.jp/ 10.04.29 大⑨州東方祭２ dai9shuu touhou sai inKyushu 10.04.29 大⑨州東方祭２ ＠九州小倉 http://www11.atpages.jp/daikyusyutoho... の3:30からスタートしたライブ企画の一幕です ライブ観客2000人弱？（一列35～40人？×50列？）の前で、前回に引き続きライブをやらせて頂きました ・関連動画 【東方】ナイト・オブ・ナイツをバイオリンで弾いてみた【演奏】 http://www.youtube.com/watch?v=S4IarEh_23Q | ["Theme music", "Music", "Musical instrument", "Violin, fiddle"] | ["instrumental", "fast tempo", "amplified viloin", "throbbing", "pulsating", "powerful", "untiring", "punchy drum rhythm", "youthful", "animated", "cheerful", "vigorous background music", "synthesiser arrangement", "vigorous drumming", "clapping", "cheering", "live performance", "concert", "excite crowd", "animated melody", "harmonious", "spirited enthusiastic"] | 7 | bNvp4y9WSGM | 3620 | |
| Alpenblech - Baritone in der Nacht | This music is a lively instrumental. The tempo is fast with bright trumpet harmony of French horns, trumpets accompaniment and a steady, punchy bass drum rhythm. The music is upbeat, punchy, buoyant, spirited, lively and vivacious. The audio quality is an amateur recording. This music is a live performance with ambient sounds of people clapping and cheering . | 2008-09-21T04:23:44Z | polkasignorina | Blasmusik vom Feinsten! Solisten: Markus Mikusch und Peter Seitz Infos auf www.alpenblech.de | ["Brass instrument", "Music", "Musical instrument", "Tambourine", "Trombone", "Trumpet"] | ["instrumental", "fast tempo", "brass band", "classical", "western classical music", "trumpet symphony", "live performance", "concert", "live audience", "clapping", "cheering", "ambient sounds", "gig", "inferior audio quality", "amateur recording", "lively trumpets", "thumping drum beat", "bass drum", "lively", "spirited", "energetic", "enthusiastic", "buoyant", "french horn harmony", "wind instrument"] | 7 | br4A2uNud50 | 3660 | |
| Torvill and Dean 1983 Rock n Roll OSP | This music is a high energy Rock and Roll. The tempo is fast with a vivacious electric guitar melody, punchy drumming, animated trumpets, funky bass line, keyboard and acoustic guitar accompaniment . The music is high energy, vivacious, bright, groovy,enthusiastic and animated Rock and Roll instrumental. | 2007-11-18T01:14:20Z | BJH1981 | Torvill & Dean's Rock n Roll OSP from 1983 World Championships | ["Music", "Roll", "Rock and roll"] | ["instrumental", "fast tempo", "ambient background sounds", "clapping", "live performance", "poor audio quality", "muffled music", "cheering", "people talking", "enthusiastic electronic guitar melody", "hard hitting drumming", "bright trumpeting", "groovy bass line", "rhythmic acoustic guitar", "keyboard harmony", "brass band", "wind instruments", "dance groove", "jive", "rock and roll", "retro rock", "energetic", "enthusiastic", "pulsating", "buoyant", "upbeat", "high spirited"] | 7 | fEHsR679g1M | 3934 | |
| Palladium Salsa Social | 13 Marzo | Music by Dj Rumbero | A male vocalist sings this peppy Latin pop song.the tempo is medium with animated trumpets, keyboard harmony and percussions rhythms of bongos, congas and subtle drums. The song is muffled and there are sounds in the background of people talking, cheering, the sound of clinking, scuffling and tapping. The song is super imposed by the background sounds. This song is a latin pop song. | 2015-03-14T07:40:22Z | Jorge Rodriguez | Palladium Salsa Social music by Dj Rumbero a través de YouTube Capture | ["Singing", "Music", "Music of Latin America", "Salsa music"] | ["male vocalist", "medium tempo", "latin song", "super imposing background", "mexican", "cheering", "dance music", "latin dance music", "dance hits", "spanish", "dance music", "congas", "bongos", "trumpets", "steady beat", "salsa", "bachata", "people talking", "clinking", "tapping sound", "scuffling", "low audio quality", "muddled audio"] | 7 | sOyHkcK_lOA | 4947 | |
| Stand By Me (steel pan) | This music is a cheerful instrumental. The tempo is medium with the lead harmony on a Xylophone, energetic drumming, keyboard accompaniment and rhythmic acoustic guitar. The audio quality is inferior and the music is muffled and muddy. There are background sounds like people talking, laughing and ambient nature sounds like a breeze. The music is fun, youthful, simple, enjoyable, chirpy and vivacious. | 2008-02-13T06:13:56Z | svart3n | Steel Pan band at the 30th anniversary Flatbush Frolic in Brooklyn, NY, 2007. See the video in better quality @ http://youtu.be/LlCS3ZVutuk | ["Music", "Steelpan"] | ["instrumental", "medium tempo", "rhythmic acoustic guitar", "background sounds", "ambient nature sounds", "people talking", "sound of laughter", "cheering", "tapping", "merry", "happy", "chirpy", "cheerful", "’ enjoyable", "xylophone harmony", "energetic drumming", "muffled audio", "keyboard harmony", "lively beat", "catchy", "rhythmic beat", "pop song", "popular", "simple"] | 7 | tV3rvUSlVnY | 5043 |
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;