musiccaps_details (view)
109 rows where musiccaps_aspects contains "joyful"
This data as json, CSV (advanced)
musiccaps_aspects (array) 493 ✖
- joyful · 109 ✖
- low quality 60
- happy 43
- noisy 27
- passionate 25
- groovy bass 20
- instrumental 19
- fun 18
- mono 18
- live performance 17
- bass guitar 12
- shimmering hi hats 12
- energetic 11
- passionate male vocal 11
- acoustic guitar 10
- emotional 10
- playful 10
- punchy snare 10
- wooden percussions 10
- cheerful 9
- lively 9
- acoustic rhythm guitar 8
- children song 8
- vibrant 8
- male vocals 7
- no singer 7
- traditional 7
- clapping 6
- easygoing 6
- flat male vocal 6
- groovy piano melody 6
- pop 6
- punchy kick 6
- shimmering shakers 6
- synth lead melody 6
- upbeat 6
- acoustic drums 5
- crowd cheering 5
- exciting 5
- fast tempo 5
- festive 5
- fiddle 5
- folk 5
- orchestra 5
- percussion 5
- piano 5
- plucked strings melody 5
- shimmering bells melody 5
- soft kick hits 5
- sustained strings melody 5
- addictive 4
- breathy flute melody 4
- classical 4
- mandolin 4
- melodic singing 4
- passionate female vocal 4
- shimmering tambourine 4
- soulful 4
- accordion 3
- accordion melody 3
- banjo 3
- bluegrass 3
- claps 3
- country 3
- electric guitar 3
- electric guitar melody 3
- female vocal 3
- keyboard 3
- latin music 3
- male vocal 3
- salsa 3
- shimmering cymbals 3
- simple bass 3
- tabla 3
- trumpet 3
- ukulele 3
- vivacious 3
- acoustic guitar melody 2
- acoustic rhythm guitar chords 2
- animated 2
- arpeggiated acoustic guitar melody 2
- bansuri 2
- brass melody 2
- celebration 2
- celebratory 2
- cello 2
- christmas carols 2
- christmas cheer 2
- christmas song 2
- country folk music 2
- country music 2
- cozy 2
- distorted 2
- electronic drums 2
- enthusiastic 2
- euphoric 2
- female voice 2
- fruity male vocal 2
- groovy bass guitar 2
- harmonizing male vocals 2
- irish folk music 2
- latin dance music 2
- latin folk 2
- latin percussion 2
- male vocalist 2
- maracas 2
- marimba 2
- medium tempo 2
- mellow 2
- muffled 2
- party song 2
- regional mexican 2
- shakers 2
- single instrument 2
- sitar 2
- soft 2
- soul 2
- spirited 2
- steady tempo 2
- steel drums melody 2
- steel guitar melody 2
- uplifting 2
- upright bass 2
- vocal backup 2
- vocalisation 2
- wooden percussive elements 2
- xylophone 2
- youthful 2
- "4 on the floor" kick pattern 1
- accordeon 1
- acoustic bass guitar 1
- acoustic guitar accompaniment 1
- acoustic guitar chords 1
- acoustic guitars 1
- acoustic live performance 1
- acoustic sounding drums 1
- alpine folk music 1
- amadinda 1
- amateur home recording 1
- amateur recording 1
- ambient 1
- ambient outdoor sounds 1
- american folk 1
- andalusian 1
- animated trumpets 1
- arabian 1
- arpa jarocha 1
- arpeggiated electric guitar melody 1
- arpeggiated harp melody 1
- background harmonizing vocals 1
- backup singer 1
- band recording 1
- banjo solo 1
- baraban 1
- bass 1
- bass clarinet melody 1
- bells 1
- bells melody 1
- benign 1
- boomy kicks 1
- bowed string instruments 1
- brass band 1
- brass instrument 1
- brass section 1
- brass solo melody 1
- brass stabs 1
- bright brass melody 1
- calming 1
- cheerful drumming 1
- childlike 1
- chill 1
- chime bells 1
- chiptune 1
- choral harmony 1
- christmas greeting 1
- christmas music 1
- christmas songs 1
- church bell 1
- church bells 1
- church bells melody 1
- clarinet 1
- clarinet solo melody 1
- classic music 1
- classy 1
- clock ticking 1
- commercial song 1
- congas 1
- coughing 1
- cover 1
- cowbell 1
- crowd clapping 1
- crowd harmonizing singing 1
- crowd talking 1
- cymbals 1
- dance 1
- dance groove 1
- dance music 1
- dance rhythm 1
- danceable 1
- dholak beat 1
- dissonant string melody 1
- distorted music 1
- doo wop 1
- drum & pipe band 1
- echoing flat male vocal 1
- echoing passionate male vocal 1
- educational 1
- elderly raspy male country vocal 1
- electric guitar licks 1
- emphatic vocals 1
- energetic crash 1
- energetic cymbals 1
- entertaining 1
- epic 1
- exciting background male vocals 1
- exotic 1
- female and male voices 1
- female vocalist 1
- festive singing 1
- festivities 1
- fiddle solo 1
- flat female vocal 1
- flute 1
- flute lick 1
- folk dance 1
- folk rock 1
- folk song 1
- french horn 1
- fresh 1
- friendly 1
- funky bass lines 1
- funky basslines 1
- funky electric guitar melodies 1
- funky jazz 1
- funny boy vocal 1
- funny male vocal 1
- generic 1
- generic female voice tag 1
- ghungaroos 1
- gospel 1
- groovy bass line 1
- groovy electric guitar chords 1
- groovy organ keys melody 1
- groovy piano 1
- groovy synth bass 1
- groovy synth keys 1
- groovy trombone 1
- guiro 1
- guiro accompaniment 1
- guiro percussion 1
- guitar accompaniment 1
- hand percussion 1
- hand percussions 1
- happy bells melody 1
- harmonica 1
- harmonica melody 1
- harmonica solo 1
- harmonica solo melody 1
- harmonium 1
- harmonizing 1
- harmonizing female vocal melody 1
- harmonizing female vocals 1
- harmonizing kids vocals 1
- harmonizing male vocal 1
- harmonizing mixed choir 1
- harmonizing mixed vocals 1
- harmonizing vocals 1
- harp 1
- harp melody 1
- heartfelt 1
- heartful 1
- high notes 1
- high pitched vocal 1
- hindustani classical music 1
- hopeful 1
- hypnotic 1
- in game sound 1
- indian film music 1
- indian folk music 1
- indian folk song 1
- indian music 1
- indian traditional music 1
- inferior audio quality 1
- instrumental playback 1
- intense 1
- intricate bassline 1
- introduction 1
- jazz hits 1
- jazz music 1
- jingle bells 1
- kids laughing 1
- kids show theme 1
- kids song 1
- laser synth fx 1
- latin folk music 1
- latin influence music 1
- latin instrumental 1
- latin percussive elements 1
- latin regional music 1
- laughter 1
- life’s truths 1
- lighthearted 1
- live music 1
- live recording 1
- lively acordion 1
- lively cheerful 1
- lively keyboard harmony 1
- lively violin 1
- loud wooden percussion 1
- low male vocal 1
- male laughing 1
- male singer 1
- male vocalisation 1
- male voice 1
- mandolin solo melody 1
- mandoline melody 1
- mellow bells melody 1
- mellow female vocal 1
- mellow kick hits 1
- mellow kid vocal 1
- mellow piano chords 1
- mellow piano melody 1
- mellow rimshots 1
- mellow snare hits 1
- mellow synth pad chords 1
- melodic 1
- merry 1
- messy 1
- mexican 1
- mexican folk music 1
- minimalist 1
- minimalist music 1
- new age 1
- no voice 1
- nostalgic 1
- off-key singing 1
- orchestral music 1
- organ 1
- organ keys lead melody 1
- oud 1
- party whistle 1
- passionate accordion melody 1
- passionate boys vocals 1
- passionate female harmonizing vocals 1
- passionate female vocals 1
- passionate girls vocals 1
- passionate harmonizing choir vocals 1
- passionate woodwind melody 1
- pastoral 1
- pedal steel guitar 1
- people dancing 1
- people talking 1
- peppy 1
- percussive elements 1
- percussive horn section 1
- phone recording 1
- piano melody 1
- picked mandolin solo melody 1
- plastic impacts 1
- playback 1
- playback instrumental 1
- playful singing 1
- pleasant 1
- plethora of instruments 1
- polish fiddle 1
- polish folk music 1
- pop rock 1
- pop-rock 1
- popping sounds 1
- popular song 1
- portugal 1
- positive 1
- procession 1
- punjabi folk song 1
- punjabi song 1
- punjabi wedding song 1
- reggae 1
- reggae music 1
- regional music 1
- relaxed 1
- relaxing 1
- reverberant 1
- reverberant fruity male vocal 1
- rhythm 1
- rock 1
- romanian 1
- romanian folk music 1
- rural 1
- santa claus 1
- saxophones 1
- saxophones harmony 1
- scottish bagpipes 1
- scraper instrument 1
- sensual 1
- shimmering acoustic guitar chords 1
- shimmering bells 1
- shimmering crash cymbal 1
- shimmering open hats 1
- shimmering triangle 1
- shoe tapping 1
- short electric guitar lick 1
- short violin melody 1
- shouting 1
- simple hi hats 1
- simple kick 1
- simple kick pattern 1
- simple tune 1
- singing along 1
- sizzling triangle 1
- ska band 1
- ska orchestra 1
- sleigh bells 1
- smooth bass 1
- smooth double bass 1
- snappy rimshots 1
- snappy snare 1
- snaps 1
- snare rolls 1
- soft kick 1
- soft snare 1
- sound effects 1
- southern 1
- spanish 1
- spanish guitar 1
- spanish song 1
- spirited congas 1
- spirited drumming 1
- spoken word 1
- static 1
- steady drumming 1
- steel guitar repetitive guitar 1
- storytelling style singing 1
- street performance 1
- strings 1
- strings melody 1
- sunny 1
- suspenseful 1
- sustained brass melody 1
- sustained organ keys chord 1
- sustained strings 1
- symphony 1
- syncopated snare 1
- syncopated vocals 1
- synth choir keys 1
- synth keys melody 1
- synth melody 1
- synth pad 1
- synth sound effects 1
- talking 1
- tambourine 1
- tambourine beat 1
- tango 1
- tapping 1
- tarab 1
- timeless 1
- timpani 1
- tinny metallic percussions 1
- toms roll 1
- trumpets animated trumpet 1
- tubular bells 1
- ugandan traditional music 1
- uilleann pipes 1
- ukelele harmony 1
- uptempo 1
- venezuelan 1
- vibrant piano playing 1
- viola 1
- violin lick 1
- violin melody 1
- vocal harmony 1
- wedding 1
- wedding music 1
- wedding rituals 1
- weird 1
- whistling 1
- wide 1
- wide acoustic guitar chords 1
- wide acoustic guitars melody 1
- wide brass melody 1
- wide electric guitar melody 1
- wide groovy piano melody 1
- wide harmonizing background vocals 1
- wide harmonizing children vocals 1
- wide keys melody 1
- wide plucked echoing strings 1
- wide staccato female vocal melody 1
- wide strings melody 1
- wide sustained strings 1
- wide synth pad 1
- wide wooden percussions 1
- wobbly percussion 1
- woodwind melody 1
- world music 1
youtube_published (date) 106 ✖
- 2009-04-28 2
- 2010-04-03 2
- 2013-03-18 2
- 2006-11-03 1
- 2007-05-09 1
- 2007-05-27 1
- 2007-06-24 1
- 2007-07-17 1
- 2007-07-24 1
- 2007-08-09 1
- 2007-12-11 1
- 2008-01-05 1
- 2008-01-06 1
- 2008-01-16 1
- 2008-01-22 1
- 2008-02-01 1
- 2008-03-23 1
- 2008-05-20 1
- 2008-06-02 1
- 2008-06-20 1
- 2008-07-10 1
- 2008-07-26 1
- 2008-09-05 1
- 2008-09-09 1
- 2008-10-02 1
- 2008-10-19 1
- 2008-11-17 1
- 2009-01-04 1
- 2009-01-17 1
- 2009-01-27 1
- 2009-02-01 1
- 2009-02-21 1
- 2009-03-10 1
- 2009-03-29 1
- 2009-03-31 1
- 2009-04-08 1
- 2009-04-12 1
- 2009-05-14 1
- 2009-05-20 1
- 2009-06-19 1
- 2009-06-23 1
- 2009-08-03 1
- 2009-09-17 1
- 2009-09-20 1
- 2009-12-16 1
- 2010-03-07 1
- 2010-05-10 1
- 2010-10-02 1
- 2010-11-14 1
- 2010-11-20 1
- 2010-12-22 1
- 2010-12-30 1
- 2011-01-16 1
- 2011-02-04 1
- 2011-02-07 1
- 2011-02-09 1
- 2011-03-13 1
- 2011-03-15 1
- 2011-04-15 1
- 2011-05-02 1
- 2011-05-24 1
- 2011-07-14 1
- 2011-08-25 1
- 2011-09-13 1
- 2011-10-20 1
- 2011-11-23 1
- 2011-11-28 1
- 2011-12-02 1
- 2011-12-10 1
- 2012-02-17 1
- 2012-03-19 1
- 2012-04-19 1
- 2012-04-21 1
- 2012-05-11 1
- 2012-06-02 1
- 2012-11-22 1
- 2012-11-27 1
- 2012-12-06 1
- 2013-01-19 1
- 2013-02-01 1
- 2013-03-11 1
- 2013-03-28 1
- 2013-04-25 1
- 2013-07-09 1
- 2013-07-27 1
- 2013-07-31 1
- 2013-12-04 1
- 2014-01-03 1
- 2014-01-28 1
- 2014-02-20 1
- 2014-04-08 1
- 2014-04-18 1
- 2014-04-20 1
- 2014-06-04 1
- 2014-07-23 1
- 2014-07-30 1
- 2014-09-14 1
- 2014-09-24 1
- 2014-10-14 1
- 2014-11-30 1
- 2015-04-09 1
- 2015-05-01 1
- 2015-11-17 1
- 2016-01-06 1
- 2016-03-08 1
- 2016-03-13 1
musiccaps_names (array) 99 ✖
- Music 87
- Musical instrument 18
- Singing 15
- Bluegrass 9
- Music for children 9
- Accordion 8
- Mandolin 8
- Country 7
- Traditional music 7
- Bowed string instrument 6
- Christmas music 6
- Music of Latin America 6
- Percussion 6
- Folk music 5
- Guitar 5
- Plucked string instrument 5
- Ska 5
- Song 5
- Speech 5
- Wind instrument, woodwind instrument 5
- Christian music 4
- Gospel music 4
- Happy music 4
- Salsa music 4
- Wedding music 4
- A capella 3
- Brass instrument 3
- Choir 3
- Classical music 3
- Drum 3
- Harmonica 3
- Harp 3
- Jazz 3
- Violin, fiddle 3
- /t/dd00003 2
- Acoustic guitar 2
- Banjo 2
- Bell 2
- Blues 2
- Drum kit 2
- Exciting music 2
- Flamenco 2
- French horn 2
- Jingle (music) 2
- Keyboard (musical) 2
- Middle Eastern music 2
- Music of Africa 2
- New-age music 2
- Orchestra 2
- Piano 2
- Pizzicato 2
- Pop music 2
- Rattle (instrument) 2
- Soul music 2
- Steelpan 2
- Synthetic singing 2
- Tabla 2
- Tambourine 2
- Timpani 2
- Vocal music 2
- /t/dd00032 1
- Ambient music 1
- Baby laughter 1
- Bagpipes 1
- Boing 1
- Carnatic music 1
- Cello 1
- Chorus effect 1
- Chuckle, chortle 1
- Church bell 1
- Clapping 1
- Clarinet 1
- Cough 1
- Ding 1
- Disco 1
- Double bass 1
- Effects unit 1
- Flute 1
- Funk 1
- Giggle 1
- Glockenspiel 1
- Harpsichord 1
- Maraca 1
- Marimba, xylophone 1
- Music of Asia 1
- Music of Bollywood 1
- Sitar 1
- Soundtrack music 1
- Steel guitar, slide guitar 1
- Strum 1
- Swing music 1
- Tick 1
- Trombone 1
- Trumpet 1
- Ukulele 1
- Video game music 1
- Whoop 1
- Wood block 1
- Yell 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
mandolinvideo.avi | The excerpt features a mandolin playing a folk song. This is the only musical instrument playing, there aren't others or any voices singing. The character of the song is joyful. | 2012-04-19T17:06:56Z | Stuart Wailing Resonators | This video is of a Stuart Wailing Resonator Mandolin being played by Phil Tyler. See other instrument made by Stuart Wailing at https://stuartwailingresonator.000webhostapp.com/index.html | ["Guitar", "Music", "Mandolin", "Musical instrument", "Plucked string instrument", "Bluegrass"] | ["mandolin", "instrumental", "no voice", "joyful", "folk song"] | 2 | w2vMywh5Nto | 5232 | |
rapsódia tango | This is a latin music piece in the style of tango. It is an instrumental piece. The only instrument being played is an accordion. The accordion is playing a joyful tune. This piece could be playing in the background at an Iberian coffee shop. | 2009-06-19T15:25:02Z | Eurico Martins e Cristina Música-Oficial | acordeonista | ["Accordion"] | ["latin music", "tango", "no singer", "instrumental", "single instrument", "accordion", "joyful", "lively"] | 9 | wEHRmd84Dwc | 5250 | |
Rain Forest - Ambient New Age Reiki Music Video -By Equinox | This is a new age piece. There is a flute playing the main melody with a lot of staccato notes. The rhythmic background consists of a medium tempo electronic drum beat with percussive elements all over the spectrum. There is a playful atmosphere to the piece. This piece can be used in the soundtrack of a children's TV show or an advertisement jingle. | 2007-05-27T18:15:06Z | AmbientMusic | HD Version http://www.youtube.com/watch?v=xBDcJKb-9vk&fmt=18 Amazon Rain Forest - By Equinox - Ambient Music Collective - RainForest - New Age Reiki Music Video with scenes of the Amazon Rainforest ©1994 AMC Dedicated to the honor of the **Mapuche Nation** http://www.myspace.com/mapuchenation | ["New-age music", "Music", "Ambient music"] | ["ambient", "new age", "flute", "bass", "electronic drums", "percussive elements", "playful", "joyful", "benign"] | 9 | xBDcJKb-9vk | 5309 | |
dorel bass boss si lilian de la craiova | This is the live performance of a Romanian folk music piece. It is instrumental. There is an accordion playing the leading melody while the fiddle, acoustic guitar and the upright bass play in the background. There is a percussive element in the rhythmic background. The atmosphere is lively and joyful. | 2010-10-02T11:31:13Z | bosssbosssmihaita | la o terasa in las palmas de gran canarias | ["Accordion"] | ["romanian folk music", "live performance", "instrumental", "accordion", "upright bass", "acoustic guitar", "percussion", "fiddle", "lively", "upbeat", "joyful"] | 9 | xR2p3UED4VU | 5328 | |
Melbourne Ska Orchestra - The Best Things In Life Are Free | A male singer sings this jazz melody with the backup singer in vocal harmony. The song is medium tempo, with saxophone harmony, ska drumming rhythm and a good bass line. The song is entertaining and groovy. The song is a classic jazz tune played in ska style. | 2012-12-06T06:35:18Z | Melbourne Ska Orchestra | The Melbourne Ska Orchestra's take on 1920's classic, "The Best Things In Life Are Free" from their 2013 self-titled album. Available here: https://abcmusic.lnk.to/MelbourneSkaOrchestra This music video was filmed at the legendary Allan Eaton Studios in Melbourne, Australia and features vocalist Pat Powell. The track featured on Freeview Australia's national TV campaign with Melbourne Ska Orchestra Conductor/MC Nicky Bomba and members of the orchestra. www.melbourneskaorchestra.com Video Clip produced by Bison Films and Clayton Jacobson | ["Music", "Ska"] | ["male singer", "reggae music", "ska band", "dance rhythm", "people dancing", "band recording", "classy", "medium tempo", "guitar accompaniment", "bass guitar", "saxophones harmony", "backup singer", "vocal harmony", "groovy bass line", "jazz music", "funky jazz", "percussive horn section", "joyful", "passionate", "medium tempo", "syncopated vocals", "ska orchestra", "jazz hits", "life’s truths"] | 1 | xUVvBF9BWdg | 5333 | |
Tarantella calabrese - Organetto e tamburello (accordion and tambourine) | The low quality recording features a passionate accordion melody playing over a shimmering tambourine. It sounds joyful, happy and the recording is noisy and in mono. | 2011-01-16T09:00:36Z | Francesco Iacopino | Una tarantella calabrese suonata all'organetto e tamburello. Artisti: Giuseppe (organetto) e suo padre Leo (tamburello) A calabrian tarantella performed with accordion and tambourine. Artists: Giuseppe (accordion) and his father Leo (tambourine) | ["Music", "Musical instrument", "Tambourine", "Accordion"] | ["low quality", "shimmering tambourine", "passionate accordion melody", "joyful", "happy", "noisy", "mono"] | 4 | xxNroISqkt4 | 5368 | |
Clanadonia - Freak Music - Scotland | This is a street performance by a drum & pipe band. In the beginning, there is a female voice talking. Then, she starts playing the Scottish bagpipes in a joyful manner. A male voice shouts at the crowd to get them into mood and the crowd starts cheering. The atmosphere is vibrant. This piece could be used in the soundtrack of a historical drama movie that takes place in Scotland. | 2009-08-03T19:16:55Z | FreakMusicLtd | Hire Clanadonia with Freak Music - http://www.freakmusic.co.uk Clanadonia are leading exponents of traditional Celtic folk with an emphasis on tribal percussion. Although the band's musical roots have been passed down from their ancestors, this five piece have been cited as something more than just another Scottish pipes and drums band. | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["street performance", "drum & pipe band", "female voice", "talking", "scottish bagpipes", "male voice", "shouting", "crowd cheering", "vibrant", "joyful"] | 9 | yOJtRE-617I | 5404 | |
Christina Pluhar, une âme italienne. | The low quality recording features a string melody playing over smooth double bass, mellow piano chords and short violin melody. It sounds passionate, emotional and joyful. | 2007-05-09T18:04:15Z | Nearness | Christina Pluhar L'Arpeggiata Ciaconna, Rossi. 17ème. Extrait sans introduction orale. Véronique Gens, soprano. Christina Pluhar, théorbe, harpe baroque. Eero Palviainen, guitare baroque, archiluth. Veronika Skuplik, violon baroque. Mira Glodeanu, violon baroque. Bruno Cocset, violoncelle. Chitarra Battente, guitare baroque. Marcello Vitale. Paulina van Laarhoven lirone, viole. Mieneke van den Velden, viole. Christine Plubeau, viole. Richard Myron, contrebasse. Elisabeth Seitz, psaltérion. Elisabeth Geiger, orgue, clavecin. Haru Kitamika, orgue. Michèle Claude, percussion. | ["Cello", "Double bass", "Harpsichord", "Music", "Musical instrument", "Violin, fiddle", "Classical music", "Bowed string instrument", "Percussion"] | ["low quality", "mellow piano chords", "smooth double bass", "strings melody", "short violin melody", "passionate", "emotional", "joyful"] | 4 | yScg02DM-jY | 5412 | |
The Sound of Music - The Lonely Goatherd | The low quality recording features a live performance that consists of harmonizing female vocals singing over mellow piano and groovy trombone melody. There are some shoe tapping sounds from performers. It sounds fun, happy, joyful and the recording is in mono and noisy. | 2009-04-28T01:33:41Z | Meagan Leanne | Meagan Leanne singing "The Lonely Goatherd" and "The Sound of Music" (The Hills Are Alive) for the final performance of Spencerville Adventist Academy's "The Sound of Music" in April of 2009. | ["Music", "/t/dd00032", "Exciting music"] | ["low quality", "mono", "live performance", "noisy", "groovy trombone", "mellow piano melody", "shoe tapping", "harmonizing female vocals", "fun", "happy", "joyful"] | 4 | zbCqre50eLM | 5497 |
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;