musiccaps_details (view)
25 rows where musiccaps_aspects contains "amateur recording", musiccaps_aspects contains "fast tempo" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
musiccaps_names (array) >30 ✖
- Music · 25 ✖
- Musical instrument 8
- House music 3
- Singing 3
- Dance music 2
- Didgeridoo 2
- Drum and bass 2
- Dubstep 2
- Electronic dance music 2
- Electronic music 2
- Guitar 2
- Jazz 2
- Maraca 2
- Music of Latin America 2
- Percussion 2
- Plucked string instrument 2
- Rock and roll 2
- Scratching (performance technique) 2
- Shuffle 2
- Ska 2
- Tambourine 2
- Techno 2
- Acoustic guitar 1
- Banjo 1
- Bass drum 1
- Bluegrass 1
- Blues 1
- Bowed string instrument 1
- Brass instrument 1
- Classical music 1
- …
musiccaps_aspects (array) >30 ✖
- amateur recording · 25 ✖
- fast tempo · 25 ✖
- inferior audio quality 6
- instrumental 6
- live performance 5
- acoustic drums 4
- dj 4
- dj mixer 4
- enthusiastic 4
- youthful 4
- acoustic guitar 3
- cheering 3
- clapping 3
- concert 3
- e-bass 3
- gig 3
- people talking 3
- static 3
- ambient sounds 2
- buoyant 2
- catchy riff 2
- classical 2
- didgeridoo 2
- digital music 2
- e-guitar 2
- electric guitar riff 2
- electro pop 2
- electronic music 2
- energetic 2
- fourth world music 2
- …
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 | |
Joe Satriani - "Echo" (Montreux Jazz Festival 1988) | This song contains acoustic drums with reverb and a bassline playing to the kick. Someone is playing a slow evolving melody on a distorted e-guitar. In the background you can hear voices. This song may be playing live at a concert. | 2007-12-16T17:59:19Z | satchreis | Joe Satriani live at Montreux Jazz Festival (July 15, 1988). | ["Jazz", "Music"] | ["rock", "acoustic drums", "e-bass", "e-guitar", "fast tempo", "exstatic", "amateur recording"] | 6 | 1ls3ectO1F4 | 309 | |
W. A. Mozart - Rondo alla Turca (Turkish March), solo classical guitar | This audio contains someone playing a classical melody on an acoustic guitar using fingerstyle. This audio is full of reverb. This song may be playing at a talent show. | 2012-02-14T18:40:10Z | Los Angeles Guitar Academy | In Mozart's time, the Ottoman Empire still ruled Turkey (Anatolia). Their military bands, called Janissary bands, were quite popular, even in Europe. Mozart borrowed from their sound and rhythm to produce this work, which became one of the big hits of Mozart's day. Its popularity has rarely waned since then. The final movement of the sonata, Rondo Alla Turca, captures the military bands' brassy sound. In its whirling feel, it can evoke another aspect of Turkish culture which has captivated Westerners--the whirling motion of the Sufi dervishes as they perform their ancient ritual of peace and wholeness, though the Rondo whirls at light speed, in contrast to the gentle movement of the Mevlevi. Arranged and performed by Emre Sabuncuoglu. Copyright © 2012 Los Angeles Guitar Academy Publishing. All rights reserved. 𝄞 Purchase sheet music and tabs: https://onlineguitaracademy.net/classical-guitar-sheet-music 🔔 Subscribe for more great pieces and tutorials: https://www.youtube.com/user/LAGuitarAcademy?sub_confirmation=1 🐢 Slow walkthrough videos available on our online lesson program: https://onlineguitaracademy.net/online-classical-guitar-lessons 🍀 Free trial for online programs: https://onlineguitaracademy.net/register/laga-free-trial https://onlineguitaracademy.net/pricing-comparison ❤️ Love our work? Join our Patreon community and access dozens of patron-only posts and exclusive releases: https://www.patreon.com/LAGuitarAcademy ❤️ Or join our channel: https://www.youtube.com/channel/UC3eQeaR786C8HCGFMqtCUSw/join Recommended videos: ✔️ Complete list of our Mozart arrangements: https://www.youtube.com/playlist?list=PL18tTu-0TnfqPbL8O1OFBXEWx5j1QAdkj ✔️ Spring (the Four Seasons) for solo guitar: https://www.youtube.com/watch?v=fENuHRAPEmA ✔️ Maple Leaf Rag by Scott Joplin on solo guitar: https://www.youtube.com/watch?v=xRjXafdabzc ✔️ Eine kleine Nachtmusik for solo guitar: https://www.youtube.com/watch?v=_fxyXLZ65gw | ["Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["amateur recording", "classical", "fingerstile acoustic guitar", "fast tempo"] | 6 | 26HLgXWF-Co | 332 | |
Dada Life - Just BLEEP Me | This music is an upbeat instrumental. The tempo is fast with vigorous digital drumming, synthesiser arrangements and DJ mixer effects. The music is electrifying, pulsating, buoyant, punchy, groovy, youthful and high-spirited. This music is an outdoor live performance with ambient sounds. There are sounds of hysterical fans cheering, clapping and singing along. This music is Futuritic Electronic Pop/ Techno Pop. | 2011-07-19T03:10:45Z | janjubear | Dada Life @ EBC 7.17.11 | ["Disco", "Music"] | ["instrumental", "fast tempo", "dj", "dj mixer", "futuristic", "fourth world music", "psychedelic", "hypnotic", "vocalisation", "catchy vocal riff", "techno music", "hysteria", "live performance", "live audience", "outdoor performance", "ambient sounds", "people singing", "fans cheering", "clapping", "muffled audio", "amateur recording", "heavily synthesised music", "electro pop", "synth pop", "trance"] | 7 | 3zT0aiN2E70 | 526 | |
Rare Buwathay F made for ceremony! | Someone is playing a didgeridoo using circular breathing to continue airflow. A percussive stick sound can be heard and in the background you can hear waves of water. This song may be playing at the beach practicing didgeridoo by yourself. | 2007-03-12T07:32:52Z | ididjaustralia | You don't often come across an instrument that was made specifically for ceremony. This yirdaki is one such instrument, made by Larry Winiwini's dhuway or brother-in-law, Buwathay Munyarryun. Buwathay is an older brother of Djakapurra and a noted manikaymirr or songman. He makes yirdaki occasionally for sale, but this instrument stands apart from the others for the reason that it was made for ceremony. Light and thin-walled, this is a rare stick that gives insight into instruments prefered by Yolngu for personal and ceremonial use. It has a totally natural termite-eaten bore, quite smooth with few convolutions inside giving clean yet traditional gruff acoustics. Resonance is very good on account of thin walls. This stick has a great energy of its own... a truly wonderful yirdaki that would appeal to the trad head or the purist - when nothing but the best would do! http://www.ididj.com.au/store/fine_didjeridus.html | ["Didgeridoo", "Music"] | ["didgeridoo", "circular breathing", "water sound", "percussive sound", "fast tempo", "amateur recording"] | 6 | 4Psj5jYa7a4 | 566 | |
[HSD] Practise Toniic, ChrizZ, Feybi (Melbourne Shuffle Hamburg) | A digital drum is playing a monotone beat with a kick on every beat along with a repeating voice sample. In the next song a wide synth pad is playing a string sound while a female voice sample is singing a melody. These songs may be playing in a techno club. | 2010-07-16T10:24:57Z | Feybi11 | Pls comment and rate =) and sub for more ;) Edit: Sony Vegas 9.0 pro (Feybi) Songlist: Intro: Spor - 103 Degrees Dj Neo - In my mind Karpe DM - Jackin' my style Deepforces - Play it loud Walt Jensen - Ctrl walt del Ziggy X - Explode | ["Drum and bass", "House music", "Music", "Techno", "Trance music", "Shuffle", "Dubstep", "Electronic dance music", "Dance music"] | ["techno/hardstyle", "digital drums", "voice samples", "two different songs", "synth sound", "fast tempo", "amateur recording"] | 6 | 4X2aUZFZlzc | 582 | |
Dj Bicchio "Scratching with Duca" | This music is an instrumental with a groovy rhythm. The audio is of inferior quality making the sound muddled and difficult to comprehend. There is a steady rhythm in the background with the sound of a turn table, scratching , a catchy riff on the electric guitar and some sound caused by disturbance in electrical energy. | 2007-10-17T21:52:00Z | sistahduka | Dj Bicchio "Scratching with Duca" | ["Scratching (performance technique)", "Music", "Scratch"] | ["instrumental", "fast tempo", "keyboard harmony", "digital drum beat", "scratching", "catchy riff", "electric guitar riff", "muddled music", "home recording", "amateur recording", "sharp sound", "vinyl records", "scratching", "dj", "dj mixer", "clicking sound", "static"] | 7 | 5tt_GKV13G0 | 704 | |
Candy Cox @ TechnoTv [30.08.2006] | This music is instrumental. The tempo is fast with electronic beats and rhythm on a DJ mixer. The music is youthful, hypnotic, groovy; burgeoning and trance . | 2007-05-24T22:17:24Z | technotv | http://www.myspace.com/djcandycox | ["Scratching (performance technique)", "Electronic music", "House music", "Music", "Techno"] | ["instrumental", "fast tempo", "dj", "dj mixer", "static", "amateur recording", "home recording", "electronic music", "synthesiser arrangement", "digital music", "dance music", "electronica", "fourth world music", "youthful", "hypnotic", "trance", "techno pop", "electro pop"] | 7 | 65KYS3lIRII | 723 | |
Lamborghini vs. Ferrari | An acoustic drum is playing a fast and complex drum groove with a lot of crash hits and double bass drum. Distorted e-guitars strumming wild chords along with an e-bass holding the melody while a male voice is screaming/singing loud and aggressively. In-between the song high and awkward laughing can be heard. This is an amateur recording. This song may be playing at a hard rock tattoo studio. | 2008-04-07T06:27:38Z | imoldgregggggggg | Fuck Lambos, a cool video made by me. edit-Okay, if you guys keep posting these worthless, false comments, that have untrue statements, I'm just going to disable comments. Either make sure your argument has facts to back it up, or just post a comment saying something other than "lambos rule". It's not going to change my opinion; especially when everything you say is FALSE. edit-HEY FUCKERS, I KNOW THE MUSIC SUCKS; THATS WHY I PUT IT THERE FOR THE LAMBOS. one more edit: FUCKERS; I KNOW ONE OF THE CARS IS AN AUDI. I PUT IT IN THERE BECAUSE AUDI OWNS LAMBO. IT WAS A JOKE. OKAY? AND I DON'T LISTEN TO THAT GAY FUCKING MUSIC. IT WAS ALSO A JOKE. | ["Music", "Giggle"] | ["hardrock/punkrock", "acoustic drums", "e-guitars", "e-bass", "laughing", "male voice screaming", "fast tempo", "amateur recording", "agressive"] | 6 | 8ynjAtF5VnA | 963 | |
Alexander Rybak - Bergrosa | This audio contains someone playing a violin with a sad melody and strong bow strokes. The piece sounds as if someone is frustrated and emotional. This song may be playing at a concert. | 2009-05-26T21:58:16Z | eddott | Alexander Rybak performing Bergrosa (the mountain rose) at Bild.de. | ["Music", "Musical instrument", "Violin, fiddle", "Classical music", "Bowed string instrument"] | ["amateur recording", "violin", "fast tempo", "emotional", "sad", "frustrated"] | 6 | CZZSQ6rd8h0 | 1378 | |
TAIWAN Melbourne Shuffle · 曳步舞 · 鬼步舞 【T.N.S 貓少] | This music is an Electronic instrumental. The tempo is fast with punchy, synthesised music and thumping drum beats on the drum machine. The music is youthful, energetic, enthusiastic,loud, buoyant, punchy, pulsating and electrifying. The sound quality is of inferior quality and there is a bit of static. | 2013-03-15T14:55:39Z | 魑魅鳳 | ["House music", "Music", "Shuffle", "Dubstep", "Electronic dance music", "Dance music"] | ["instrumental", "fast tempo", "electronic music", "buoyant", "youthful", "pulsating", "electrifying", "static", "inferior audio quality", "amateur recording", "edm", "punchy drumming", "synthesiser articulation", "dj", "dj mixer", "dance floor", "freestyle dance", "drum machine", "digital drumming", "digital music", "distorted sounds"] | 7 | JqmOqYtQqB8 | 2038 | ||
Maracas Llaneras | Someone is playing maracas very skillfully while an acoustic guitar is supported with strumming chords that are constantly changing. This sounds like an amateur recording. This song may be playing at a local music store where people jam. | 2010-06-09T16:16:53Z | leonardoj333 | Maraquero apureño Manuel Mirabal ejecutando maracas llaneras elaboradas en San Fernando de Apure por el luthier José Leonardo Jiménez | ["Music", "Maraca"] | ["latin/country", "maracas", "acoustic guitar", "fast tempo", "amateur recording"] | 6 | P5IxlG4-CY8 | 2505 | |
Ambridge High School Steel Drum Band | This song contains an acoustic drum set playing a jazzy swing groove using kick,snare and ride. You can hear various steeldrums playing different parts of the song. One is playing as bass, others as chords in the midrange and others are playing a melody in the upper register. This song may be playing live at a local event. | 2011-10-25T00:39:52Z | christmasohio | Ambridge High School Steel Drum Band performs at the Christmas in the Woods 2011 festival. http://www.ChristmasOhio.com | ["Music", "Musical instrument", "Steelpan"] | ["steel drum band", "acoustic drums", "steel-drums", "fast tempo", "amateur recording"] | 6 | V9jIsOTC1lY | 2977 | |
Franzl Lang- Rambling in the mountains | Male voices are yodeling with a lot of reverb on their voices. They are loud and the speakers of the recording are speaking. An accordion is playing a fast melody that is panned to the right side of the speakers. A guitar is strumming a rhythmic chord on the backbeat. An upright bass is playing a walking bassline. This song may be playing at a folksfest. This is an amateur recording. | 2007-09-30T11:52:30Z | Spiciu | Let's listen to a lovely jodler sung by Franzl Lang, the jodler's king. | ["Yodeling", "Music"] | ["yodel/folkmusic", "male voices yodeling", "accordion", "acoustic guitar", "upright bass", "fast tempo", "amateur recording"] | 6 | Y8wHDcVCGa0 | 3259 | |
KJ Sawka in his Basement | This audio contains someone playing an acoustic drum with a fast paced and complex rhythm. This is an amateur recording. | 2006-11-20T22:00:36Z | briandewaide | Buy KJ Sawka's music at kjsawka.com or www.waxorchard.com Hi. My name is Kevin Sawka, and I play jungle and drum'n'bass beats. | ["Cymbal", "Drum", "Drum and bass", "Drum kit", "Electronic music", "Hi-hat", "Music", "Musical instrument", "Snare drum", "Bass drum", "Percussion"] | ["amateur recording", "acoustic drum", "fast tempo", "complex"] | 6 | b98BJ36K1wo | 3605 | |
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 | |
Lucy In The Sky With Diamonds Mandolin Cover | Someone is strumming a melody on the mandolin. The audio-quality is very poor and you can hear a high frequency ringing in the recording. This song may be playing while practicing at home. | 2007-08-26T23:16:35Z | songsbybands | "Lucy In The Sky With Diamonds" By The Beatles Played On An A-Style Mandolin. G - ----------------- D - -2---5--4--3----- A - --0----0-0--5-4-0 E - ---0--0---0------ If you wanna check out our original music, go to www.myspace.com/seanandaustin | ["Music", "Mandolin", "Musical instrument", "Plucked string instrument", "Inside, small room"] | ["amateur recording", "mandolin", "fast tempo"] | 6 | hheF-AgCqIg | 4129 | |
Best Beatbox Didgeridoo | someone is playing a didgeridoo beatboxing at the same time. Changing up rhythms sounding complex and skillfull. This is an amateur recording. This song may be playing in a talent show. | 2012-02-17T23:04:12Z | Rebelfoxify | Best Beatbox Didgeridoo This video doesnt belong to me | ["Didgeridoo", "Music"] | ["amateur recording", "didgeridoo", "beatbox", "fast tempo"] | 6 | j3a60_lwWjE | 4230 | |
Ziggy Marley - Positive Vibration ( thx guys! :] ) | A male vocalist sings this energetic song. The tempo is fast with boomy bass lines, steady drumming, keyboard harmony and enthusiastic electric guitar riff with vocal backup. The audio quality is very bad and the song is muffled and muddy. This song is a live performance with ambient sounds of people clapping and cheering. | 2007-06-01T05:36:28Z | FSUSeaAngel | Ziggy Marley in West Palm Beach, FL | ["Vibration", "Music", "Rock and roll", "Music of Latin America"] | ["male vocalist", "fast tempo", "boomy bass", "enthusiastic", "insistent", "recurring vocal riff", "youthful", "engaging", "enthusiastic", "classic pop", "electric guitar riff", "female vocal backup", "steady drumming", "incoherent music", "inferior audio quality", "muddled sounds", "live performance", "concert", "amateur recording", "keyboard accompaniment"] | 7 | kZBFQAQI7Pg | 4328 | |
Alessandra Belloni LESSON 1: Tarentella, Pizzica Tarantata | This audio contains someone playing a complex and fast rhythm on the tambourine. Also playing percussive. This song may be playing at a traditional ceremony. | 2010-11-11T00:31:24Z | BrooklynBikeBeat | Alessandra Belloni teaches and plays the healing trance dance known as Pizzica Tarantata | ["Music", "Musical instrument", "Tambourine", "Percussion"] | ["amateur recording", "tambourine", "fast tempo"] | 6 | lfCWGQ6URds | 4414 | |
HESTER GOODMAN...HAT SONG.. | This song is an animated vocalisation. The tempo is fast with a lively piano accompaniment, accordion harmony, cello rhythm, hard hitting drums, groovy bass lines, hand percussion beats and xylophone. The music is upbeat, energetic,enthusiastic, high-spirited and vivacious. This is a live performance with ambient sounds of people talking and general bustling. The audio quality is inferior. This song is a live Pop. | 2010-10-21T17:54:37Z | spaceritual72 | ...HAT SONG.....from "you could at least smile" album launch night...by HESTER GOODMAN..available at.......www.ukuleleorchestra.com | ["Singing", "Jazz", "Music", "Musical instrument", "Rattle (instrument)", "Ukulele"] | ["female vocalisation", "fast tempo", "cello", "hand percussion", "bass drums", "xylophone", "hard hitting drums", "animated piano", "shakers", "funky bass lines", "amateur recording", "live performance", "gig", "poor audio quality", "people talking", "bustling", "acordion harmony", "enthusiastic vocals"] | 7 | qXSG2uq2tNw | 4795 | |
Tokyo Ska Paradise Orchestra Live - Ska Me Crazy | An e-bass is playing a bluesy bassline along with acoustic drums with a slightly open hihat. An electric piano/organ is playing one short chord as a rhythmic element adding reggae vibes along with a e-guitar strumming fast chords on the offbeat. The guitar is running through a chorus effect. The male voices are singing a simple melody. This song may be playing at a live concert before a sports-event. | 2007-01-16T11:24:03Z | SkaRebel | SKA SKA SKA!!! | ["Singing", "Music", "Ska"] | ["skarock", "acoustic drums", "e-bass", "electric piano", "e-guitar", "male voices singing", "amateur recording", "fast tempo", "uplifting mood"] | 6 | rJZgUpzqAyY | 4864 | |
Concurso de la maraca tenares587.com | The music excerpt features a male voice that's speaking instead of singing. A latin music percussion section is driving the pulse of the music. Trumpets can be heard playing short melodies and also accents that stop and start the music. The tempo of the music is pretty fast. At one point the crowd can be heard cheering. The quality of the audio recording is not that good, which leads me to believe it was recorded with a phone. | 2008-02-01T16:36:17Z | DREVENTOS COM | TERCER VIDEO DEL BAILE DE LA MARACA EN ORLANDO CAR WASH | ["Music", "Maraca"] | ["amateur recording", "male voice", "trumpets", "crowd cheering", "latin music percussion", "fast tempo"] | 2 | uKGo4phKqLM | 5107 | |
Blink 182 - cacophony bass cover | A musician plays this rock instrumental. The tempo is fast with an intense, emphatic electric guitar riff and enthusiastic drumming and cymbal rides in the background and tambourine beats. The music is muffled as the sound quality is inferior. The music is energetic, enthusiastic, and animated . This is a Rock instrumental. | 2010-05-31T18:19:30Z | Walli182 | ["Blues", "Electric guitar", "Guitar", "Music"] | ["instrumental", "fast tempo", "electric guitar", "inferior audio quality", "catchy riff", "rock", "instrumental rock", "sonic power", "muffled audio", "soft drumming", "cymbals", "tambourine", "inferior audio quality", "energetic riff", "amateur recording"] | 7 | xx3nnVzGXa0 | 5366 |
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;