musiccaps_details (view)
111 rows where search matches "guitar", musiccaps_aspects contains "energetic" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_aspects (array) 406 ✖
- energetic · 111 ✖
- low quality 82
- punchy snare 70
- punchy kick 54
- rock 43
- groovy bass 37
- shimmering hi hats 33
- groovy bass guitar 28
- aggressive 22
- live performance 21
- distorted bass guitar 20
- flat male vocal 19
- metal 18
- shimmering cymbals 18
- addictive 17
- energetic cymbals 17
- exciting 17
- passionate 15
- passionate male vocal 13
- electric guitar melody 12
- groovy 12
- noisy 11
- wide electric guitar melody 11
- energetic drums 10
- fun 10
- manic 10
- energetic crash cymbal 8
- claps 7
- distorted 7
- happy 7
- harmonizing male vocals 7
- messy 7
- mono 7
- passionate female vocal 7
- acoustic rhythm guitar 6
- emotional 6
- energetic crash cymbals 6
- flat female vocal 6
- harsh 6
- loud 6
- pop 6
- uptempo 6
- wide electric guitar chords 6
- crowd cheering 5
- double pedal kick 5
- electric guitar solo melody 5
- instrumental 5
- punchy "4 on the floor" kick pattern 5
- crushed 4
- electro 4
- energetic crash 4
- groovy piano melody 4
- muffled 4
- powerful 4
- reverberant 4
- shimmering shakers 4
- smooth bass guitar 4
- 4 on the floor kick pattern 3
- aggressive electric guitar riffs 3
- arpeggiated electric guitar melody 3
- brass melody 3
- chaotic 3
- clapping 3
- cover 3
- disco 3
- electric guitar chords 3
- folk 3
- fruity male vocal 3
- harmonizing background vocals 3
- muddy 3
- screaming male vocal 3
- simple hi hats 3
- snare roll 3
- soulful 3
- strings melody 3
- vintage 3
- wide aggressive electric guitar chords 3
- wide electric guitar chord progression 3
- alternative/indie 2
- buzzy bass guitar 2
- compilation 2
- crowd clapping 2
- crowd noises 2
- distorted bass 2
- distorted electric guitar melody 2
- drum roll 2
- electric guitar chord progression 2
- electric guitar melodies 2
- electric guitar slide 2
- electric guitars melodies 2
- energetic male vocal 2
- epic 2
- funky bass guitar 2
- funky electric guitar 2
- funky electric guitar melody 2
- groovy acoustic rhythm guitar 2
- hard rock 2
- hip hop 2
- hollow 2
- joyful 2
- latin urban 2
- mellow 2
- mellow kick hits 2
- mellow synth pad 2
- punk 2
- regional mexican 2
- repetitive electric guitar melody 2
- repetitive synth keys melody 2
- shimmering open hat 2
- shimmering open hats 2
- short snare roll 2
- short snare rolls 2
- simple kick pattern 2
- soft 2
- soft kick 2
- suspenseful 2
- thin 2
- throaty male vocal 2
- unbalanced stereo 2
- upbeat 2
- uplifting 2
- wide acoustic rhythm guitar 2
- wide aggressive distorted electric guitars 2
- wide electric guitars 2
- wide harmonizing vocals 2
- wide toms roll 2
- "4 on the floor" kick pattern 1
- 4 on the floor kick 1
- acoustic guitar chords 1
- acoustic guitar melody 1
- acoustic rhythm guitar melody 1
- addictive electric guitar melody 1
- addictive female vocal 1
- addictive synth keys melody 1
- addictive synth melody 1
- aggressive drum cymbals 1
- aggressive electric guitar chords progression 1
- aggressive electric guitar melodies 1
- aggressive electric guitar melody 1
- aggressive electric guitar riff 1
- aggressive male vocals 1
- aggressive tom rolls 1
- aggressive wide electric guitar chords 1
- animals 1
- arpeggiated filtered melody 1
- arpeggiated guitar melody 1
- arpeggiated piano melody 1
- arpeggiated synth keys melody 1
- arpeggiated synth melody 1
- arpeggiated violin melody 1
- audio distortion 1
- background male vocal 1
- background male vocals 1
- background vocals 1
- banjo solo melody 1
- birds chirping 1
- blues 1
- boomy kick 1
- bouncy snare hits 1
- bouncy wooden percussions 1
- bright wide steel guitar melody 1
- buzzy 1
- buzzy synth bass 1
- camera shuttering sound effect 1
- choir 1
- cool saxophone solo melody 1
- country 1
- crowd noise 1
- crowd screaming 1
- crowd talking sounds 1
- dance/electronic 1
- dark 1
- dirty 1
- distant 1
- distorted flat male vocal 1
- distorted static sound 1
- distorted synth bass 1
- distorted wide electric guitars 1
- doubled flat male vocals 1
- down sweep 1
- drum break 1
- drum sticks countdown 1
- drums fade in 1
- drums solo 1
- dull 1
- easygoing 1
- easygoing electric guitar chords 1
- echoing brass melody 1
- echoing effects 1
- echoing electric guitar licks 1
- echoing electric guitar melody 1
- echoing energetic male vocal 1
- echoing male vocal 1
- electric guitar feedback 1
- electric guitar licks 1
- electric guitar power chords 1
- electric guitar solo 1
- electric rhythm guitar chords 1
- electric rhythm guitar melody 1
- energetic bass guitar 1
- energetic female vocal 1
- energetic open hats 1
- epic rock 1
- exciting background male vocals 1
- fade in 1
- fat bass guitar 1
- female choir melody 1
- female opera vocal 1
- filter mod bass 1
- filtered effect 1
- filtered female vocal 1
- flanger effect 1
- flat girl vocal 1
- flat male vocals 1
- folk/country 1
- funky 1
- funky electric guitar chords 1
- funky piano chords 1
- gated 1
- groovy accordion melody 1
- groovy distorted bass guitar 1
- groovy electric guitar chords progression 1
- groovy kick 1
- groovy organ keys 1
- groovy snare 1
- groovy synth bass 1
- groovy synth keys 1
- groovy synth keys chord progression 1
- groovy synth keys melody 1
- groovy thin bass guitar 1
- groovy toms 1
- groovy wide electric guitar riff 1
- guitar slide 1
- halloween 1
- hand tapping 1
- harmonica solo 1
- harmonica solo melody 1
- harmonizing background male vocal 1
- harmonizing background vocal 1
- harmonizing female vocal 1
- harmonizing high pitched female vocal 1
- harmonizing male background vocals 1
- harsh cymbals 1
- harsh electric guitar chords 1
- haunting 1
- heartbeat kick pattern 1
- high pitched sustained string melody 1
- house 1
- imbalanced 1
- in game sound 1
- indie rock 1
- industrial rock 1
- jazz 1
- live perforamnce 1
- long crash cymbal 1
- loud electric guitar 1
- low groovy bass 1
- low toms 1
- male chants 1
- male vocal ad libs 1
- manic drums 1
- manic solo electric guitar melody 1
- manic toms roll 1
- mellow piano melody 1
- mellow snare 1
- mellow synth bells melody 1
- mellow synth keys chords 1
- mellow synth keys melody 1
- modulated acid synth lead melody 1
- muffled electric guitar riff 1
- muffled kick 1
- muffled kick hits 1
- muffled male vocal 1
- muffled punchy snare 1
- muffled snare 1
- muffled snare hits 1
- muffled vocals 1
- nasal 1
- noisy snare hits 1
- offbeat shimmering open hats 1
- offbeat synth keys chords 1
- offbeat wide electric guitar chords 1
- organ keys glissando 1
- passionate echoing female vocal 1
- passionate female lead vocal 1
- passonate male vocal 1
- people cheering sounds 1
- pop rock 1
- powerful bass guitar 1
- pulsating synth riser 1
- punchy "4 on the floor" kick 1
- punchy double pedal kick 1
- punchy drums 1
- punchy hollow kick 1
- punchy kick hits 1
- quacking ducks sound effects 1
- r&b 1
- reggae 1
- repetitive aggressive male vocals 1
- repetitive echoing electric guitar melody 1
- repetitive filtered male vocal 1
- repetitive piano melody 1
- repetitive pulsating synth pad chord progression 1
- reverberant flute melody 1
- reverberant male vocal 1
- reverberant percussion hit 1
- reverberant snappy rimshot 1
- reverberant toms 1
- rock & roll 1
- rock orchestra 1
- saxophone solo melody 1
- screaming 1
- screaming female vocal 1
- shimmering bells melody 1
- shimmering crash cymbal 1
- shimmering crash cymbals 1
- shimmering shaker 1
- shimmering tambourine 1
- shimmering triangle 1
- shimmering wide cymbals 1
- short audio crackle 1
- short drums roll 1
- short electric guitar lick 1
- short groovy synth keys chords 1
- short reversed crash riser 1
- simmering shaker 1
- simple electric guitar melody 1
- simple kick patter 1
- simple strings melody 1
- sizzling triangle 1
- sloppy 1
- smooth double bass 1
- snare rolls 1
- soft crash cymbal 1
- soft female vocal 1
- soft kick hit 1
- soft kick hits 1
- soft male vocal 1
- soft metal 1
- soft ride cymbals 1
- soft rimshots 1
- soft rock 1
- solo brass melody 1
- solo clean electric guitar melody 1
- soulful male vocal melody 1
- steel guitar solo melody 1
- stereo microphone technique 1
- straight piano chords 1
- string melody 1
- stuttering effect 1
- subtle microphone feedback 1
- suspenseful electric guitar melody 1
- sustained string melody 1
- sustained strings melody 1
- sustained synth pad melody 1
- syncopated snare 1
- synth guitar lick 1
- synth keys chords 1
- synth keys melody 1
- synth lead melody 1
- synth pad chords 1
- thin snare 1
- tinny muffled percussive elements 1
- tinny percussive elements 1
- tinny wide minimal percussions 1
- tinny wooden percussion 1
- tom roll 1
- traditional 1
- traditional pop 1
- tremolo electric guitar chord 1
- tropical 1
- unbalanced stereo image 1
- uptempo acoustic rhythm guitar 1
- uptempo kick pattern 1
- video game trailers 1
- violin melody 1
- violins melody 1
- volume ducking 1
- warm 1
- weird 1
- weird repetitive electric guitar melody 1
- whispering male vocal 1
- whistling sound 1
- wide 1
- wide aggressive electric guitar riff 1
- wide aggressive guitars melodies 1
- wide agressive distorted electric guitar melody 1
- wide arpeggiated electric guitar melody 1
- wide background harmonizing vocals 1
- wide bouncy wooden percussion 1
- wide clapping 1
- wide claps 1
- wide electric guitar melodies 1
- wide electric guitars chord progressions 1
- wide electric guitars melodies 1
- wide electric guitars riffs 1
- wide filter mod electric guitar chords 1
- wide funky electric guitar chords 1
- wide harmonizing female vocals 1
- wide harmonizing male vocals 1
- wide manic toms 1
- wide soft whispering male vocals 1
- wide stuttering synth melody 1
- wide tinny percussive elements 1
- wooden percussions 1
- wooden percussive elements 1
musiccaps_names (array) 87 ✖
- Music 96
- Angry music 21
- Rock music 16
- Singing 13
- Heavy metal 10
- Punk rock 10
- Pop music 9
- Progressive rock 9
- Rock and roll 9
- Exciting music 8
- Psychedelic rock 8
- Roll 8
- Guitar 7
- Independent music 7
- Musical instrument 7
- Ska 7
- Disco 5
- Grunge 5
- Rhythm and blues 5
- Song 5
- Dance music 4
- Plucked string instrument 4
- Soul music 4
- Speech 4
- Banjo 3
- Drum 3
- Drum kit 3
- Funk 3
- Keyboard (musical) 3
- Music of Asia 3
- Piano 3
- Afrobeat 2
- Background music 2
- Bass guitar 2
- Brass instrument 2
- Cacophony 2
- Electric piano 2
- Electronica 2
- Folk music 2
- Harmonica 2
- House music 2
- Jazz 2
- Saxophone 2
- Swing music 2
- Techno 2
- Wind instrument, woodwind instrument 2
- /m/05zppz 1
- /t/dd00003 1
- /t/dd00032 1
- Bass drum 1
- Bluegrass 1
- Blues 1
- Burst, pop 1
- Christian music 1
- Christmas music 1
- Classical music 1
- Country 1
- Cymbal 1
- Drum and bass 1
- Drum roll 1
- Dubstep 1
- Duck 1
- Electronic dance music 1
- Electronic music 1
- Electronic organ 1
- Happy music 1
- Hi-hat 1
- Hip hop music 1
- Music of Africa 1
- Music of Latin America 1
- Opera 1
- Organ 1
- Percussion 1
- Quack 1
- Rapping 1
- Reggae 1
- Rimshot 1
- Rustling leaves 1
- Salsa music 1
- Snare drum 1
- Soundtrack music 1
- Synthetic singing 1
- Theme music 1
- Traditional music 1
- Trance music 1
- Video game music 1
- Yell 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Comb Your Hair by LoveStruck | The low quality recording features a rock song that contains filtered female vocal singing over loud and harsh electric guitar chords, energetic drums and buzzy bass guitar. It sounds chaotic due to the bad mix and since the drums are panned in an unconventional way - making the stereo image unbalanced. It sounds harsh, but also energetic. | 2010-03-19T19:57:05Z | stuspasm | LoveStruck is: Lady Anne, Vocals/ Guitar. Stu Spasm, Bass. Bloody Rich Hutchins, Drums. The band is based in Brooklyn, NYC. This song is out on Limited Edition 7" vinyl... http://www.myspace.com/lovestrucknyc or http://www.reverbnation.com/lovestrucknyc http://vimeo.com/9691399 http://www.facebook.com/pages/LoveStruck/118702 218460?ref=sgm http://garagepunk.ning.com/profile/LadyAnne | ["Blues", "Swing music", "Bass guitar", "Funk", "Music", "Pop music", "Song"] | ["low quality", "loud", "rock", "harsh electric guitar chords", "filtered female vocal", "energetic drums", "unbalanced stereo", "chaotic", "energetic", "buzzy bass guitar"] | 4 | uAgizG1hYw0 | 5096 | |
Dope Stars Inc. - Dressed Inside Your Fear | The Industrial Rock song features a groovy bass, punchy snare, groovy kick pattern, shimmering cymbals, addictive electric guitar melody and arpeggiated synth keys melody playing. It sounds energetic and emotional - like something you would jump to at concerts. | 2015-05-28T11:58:57Z | Dope Stars Inc. | DOWNLOAD ⇒ https://dopestarsinc.bandcamp.com/album/terapunk Written, directed & edited by Daniele Campea at http://www.creativesfilm.com | ["Music", "Angry music"] | ["industrial rock", "groovy bass", "punchy snare", "groovy kick", "shimmering cymbals", "addictive electric guitar melody", "arpeggiated synth keys melody", "energetic", "emotional"] | 4 | udQQrQB-gr4 | 5129 | |
Pinoy Reggae | The low quality recording features a reggae song that consists of passionate male vocal singing over offbeat, widely spread guitar chords, groovy bass, punchy kick hits, punchy snare hits layered with claps, bouncy wooden percussions and echoing brass melody. It gives off happy and fun vibes - as every reggae song should. | 2013-09-18T04:27:38Z | j baunsit | Basilyo,Brownman Revival,The Youth,The Weeddz,Enchi | ["Music", "Reggae"] | ["low quality", "reggae", "passionate male vocal", "offbeat wide electric guitar chords", "groovy bass", "punchy kick", "punchy snare", "claps", "bouncy wooden percussions", "echoing brass melody", "energetic", "happy", "fun"] | 4 | v1EDTMRmJlY | 5147 | |
Duck & Goose Hunting in Iowa 2009 | The low quality recording features a quacking ducks sound effects as an intro, after which comes a manically played drum roll that includes snares and toms, leading into the wide electric guitars, punchy kick, energetic crash cymbal, shimmering hi hats and fat bass guitar. At the very beginning, there is a short audio crackle that makes this recording's quality low. | 2010-03-09T01:33:38Z | iowatheoutdoorsman | We had another great season this year. We bagged a lot of ducks and a few geese. Now the long wait till the season opens again. You can check out more photos at http://the-outdoorsman.net/waterfowlhunting/ | ["Music", "Quack", "Duck"] | ["short audio crackle", "low quality", "quacking ducks sound effects", "manic toms roll", "shimmering hi hats", "wide electric guitars", "fat bass guitar", "punchy snare", "energetic crash", "punchy kick", "rock", "energetic", "animals"] | 4 | vBkDLBO-Aok | 5160 | |
Endo - Suffer (Official Music Video) | The Metal song features a repetitive, aggressive male vocal screaming over wide, aggressive electric guitar chords, distorted bass guitar, punchy snare and kick hits and energetic cymbals. There is a toms roll at the end of the loop. It sounds aggressive, energetic and manic - like something you would jump into a mosh pit at the concert. | 2008-01-14T16:17:42Z | cucuzza21 | This is the official music for Endo's song "Suffer" off their debut album "Evolve". Enjoy! | ["Music", "Angry music"] | ["metal", "wide aggressive electric guitar chords", "repetitive aggressive male vocals", "screaming", "distorted bass guitar", "punchy snare", "wide toms roll", "energetic cymbals", "aggressive", "energetic", "manic", "punchy kick"] | 4 | w6zHc6nRJ0o | 5242 | |
70´s Music Disco Samba Two man sound | The Disco song features a widely spread electric guitar chord progression, acoustic rhythm guitar, shimmering shakers, tinny percussive elements, followed by simple kick pattern, punchy snare and groovy bass guitar, over which sings the flat male vocal. It sounds energetic, fun and exciting, as it is something you would definitely hear in clubs during 70s and 80s. | 2010-07-19T01:10:27Z | StarsMoon14 | ["Disco", "Music", "/m/05zppz", "Rhythm and blues"] | ["disco", "wide electric guitar chord progression", "acoustic rhythm guitar", "shimmering shakers", "simple kick patter", "punchy snare", "groovy bass guitar", "wide tinny percussive elements", "sizzling triangle", "flat male vocal", "fun", "exciting", "energetic"] | 4 | wZopmfXTtxw | 5275 | ||
Electronic Music Fest - Río Grande | The Dance/Electronic song features a repetitive synth keys melody, synth guitar lick, distorted synth bass that perfectly complements the "4 on the floor" kick pattern, punchy snare hits layered with claps, simple "2 step" hi hat pattern, shimmering shakers, repetitive, pulsating synth pad chord progression and groovy synth keys chord progression. At the end of the first part of the loop, there is a short, reversed crash riser, where the drums subtly fade out, followed by energetic crash at the beginning of the second part of the loop, where the drums are brought back again. It sounds energetic and like something you would hear in clubs during the 00s. | 2012-03-06T05:44:12Z | npuntoend | Npunto de El Nuevo Día presenta: Coors Light Electronic Music Fest 2012 Música : Wolves Can Riot "Lunatic Obsession" "Mirrors" Realizado por Pablo Patrignani | ["Drum and bass", "House music", "Music", "Techno", "Trance music", "Dubstep", "Electronic dance music", "Dance music", "Exciting music"] | ["dance/electronic", "low quality", "repetitive synth keys melody", "synth guitar lick", "distorted synth bass", "simple hi hats", "energetic crash", "short reversed crash riser", "4 on the floor kick pattern", "repetitive pulsating synth pad chord progression", "groovy synth keys chord progression", "energetic", "punchy snare", "claps", "simmering shaker"] | 4 | wsdH6cv4YkA | 5290 | |
Fabolous, Jay Z, & Young Jeezy F A B O L O U S Vol 2 Block On Smash | The low quality recording features a hip hop song that consists of a flat male vocal, alongside some background male vocals, rapping over punchy kick and snare hits, shimmering hi hats, funky electric guitar, brass melody, groovy synth keys melody and groovy bass. It sounds energetic, groovy and exciting. | 2009-08-07T17:12:38Z | briellehursl21 | ["Music", "Rapping", "Hip hop music"] | ["hip hop", "punchy snare", "punchy kick", "funky electric guitar", "brass melody", "groovy synth keys melody", "groovy bass", "shimmering hi hats", "flat male vocal", "background male vocals", "energetic", "groovy", "exciting", "low quality"] | 4 | x6U1gX5a_4M | 5304 | ||
Starship Trooper in 1080p HD by Yes | The Rock song features a shimmering hi hats, energetic crash cymbal, punchy kick and snare hits, groovy bass guitar and wide electric guitars melodies playing on top of them. It sounds energetic and exciting. | 2013-11-19T02:05:24Z | vzqk50HD | From Wikipedia: According to Alice Cooper on his radio show Nights with Alice Cooper, Anderson claimed to have written the first two movements of "Starship Trooper" alone, though the "Disillusion" movement (which evolved from an earlier song "For Everyone", heard on Something's Coming: The BBC Recordings 1969--1970 and The Word Is Live) is credited to Chris Squire. The Würm part of "Starship Trooper" is a continuous cadenza of chords (G-Eb-C) played by ensemble and repeated adlib: first accompaniment: electric guitar on the right stereo channel, then acoustic guitar, bass pedals, and drums from middle channel, then organ and bass guitar with tremolo and distortion from left channel, then starts the guitar solo, that swaps from side to side. The whole piece lasts about three and a half minutes. "Würm" originally evolved from a song called "Nether Street" by Howe's earlier group, Bodast.[13] While "Wurm" (without the umlaut over the "u") is an Old English word for "dragon" (worm, wurm, wyrm), the Würm is a river in Germany which gave its name to an ice age in geology. Lyrics: Sister bluebird flying high above Shine your wings forward to the sun Hide the mystries of life on your way Though you've seen them, please don't say a word What you don't know, I have never heard Starship trooper, go sailing on by Catch my soul, catch the very light Hide the moment from my eager eye Though you've seen them, please don't tell a soul What you can't see, can't be very whole Speak to me of summer Long winters longer than time can remember The setting up of other roads To travel on in old accustomed ways I still remember the talks by the water The proud sons and daughter That knew the knowledge of the land Spoke to me in sweet accustomed ways Mother life, hold firmly on to me Catch my knowledge higher than the day Lose as much as only you can show Though you've seen me, please don't say a word What I don't know, I have never shared Loneliness is a power that we possess to give or take away forever All I know can be shown by… | ["Music", "Rock music", "Progressive rock"] | ["rock", "shimmering hi hats", "energetic crash cymbals", "wide electric guitar melody", "groovy bass", "punchy snare", "punchy kick", "energetic", "exciting"] | 4 | xk4U8BembHM | 5349 | |
Alkaline Trio - All On Black (Live On Letterman) | The low quality recording features a rock song that consists of a flat male vocal, alongside background male vocals, singing over shimmering hi hats, groovy bass, punchy kick and snare hits and electric guitar melodies. It sounds energetic and emotional. | 2007-06-24T14:06:26Z | AllHopeDeleted | All On Black Performed Live on Letterman from the album 'Good Mourning' http://www.youtube.com/jazzbandrock | ["Drum kit", "Guitar", "Music", "Musical instrument", "Punk rock", "Rock music"] | ["low quality", "rock", "background male vocal", "flat male vocal", "shimmering hi hats", "electric guitars melodies", "groovy bass", "punchy kick", "punchy snare", "emotional", "energetic"] | 4 | yQN9gj7Vk0w | 5408 | |
FaZeClan: Sniping with Style - Edited by FaZe Agony | The Rock song features harmonizing male vocals singing over punchy kick and snare hits, energetic open hats, wide electric guitar chords and distorted bass guitar. It sounds energetic and exciting. | 2011-07-15T16:59:24Z | FaZe Agony | Most of you guys probably have seen this on FaZeClan's channel, but we still want you guys to comment on like on the editing :) Please check out the second band used in this video (friends from school) http://www.facebook.com/prophetshc Thanks, Agony | ["Music", "Angry music"] | ["rock", "harmonizing male vocals", "punchy snare", "punchy kick", "energetic open hats", "wide electric guitar chords", "distorted bass guitar", "energetic", "exciting"] | 4 | z31iCbkqYyw | 5454 |
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;