musiccaps_details (view)
23 rows where search matches "guitar", musiccaps_aspects contains "groovy bass", musiccaps_aspects contains "low quality" and musiccaps_aspects contains "punchy kick"
This data as json, CSV (advanced)
Suggested facets: musiccaps_names
musiccaps_aspects (array) 119 ✖
- groovy bass · 23 ✖
- low quality · 23 ✖
- punchy kick · 23 ✖
- punchy snare 15
- energetic 11
- shimmering hi hats 11
- passionate 8
- groovy 7
- electric guitar melody 6
- live performance 6
- addictive 5
- easygoing 4
- emotional 4
- funky 4
- funky electric guitar melody 4
- noisy 4
- rock 4
- brass melody 3
- claps 3
- exciting 3
- passionate female vocal 3
- passionate male vocal 3
- pop 3
- wide electric guitar melody 3
- flat male vocal 2
- folk 2
- fun 2
- happy 2
- harmonizing male vocals 2
- jazz 2
- messy 2
- reggae 2
- regional mexican 2
- shimmering cymbals 2
- shimmering shakers 2
- snare roll 2
- strings melody 2
- accordion melody 1
- acoustic guitar chords 1
- acoustic rhythm guitar 1
- addictive female vocal 1
- aggressive 1
- background male vocal 1
- background male vocals 1
- background music 1
- bouncy wooden percussions 1
- brass stabs 1
- chill 1
- cinematic 1
- clicky keys 1
- crowd cheering 1
- crowd clapping 1
- disco 1
- distorted 1
- distorted static sound 1
- distorted wide electric guitars 1
- echoing brass melody 1
- echoing synth bell melody 1
- electric guitars melodies 1
- energetic crash 1
- energetic crash cymbals 1
- energetic cymbals 1
- epic 1
- fruity male vocal 1
- funky electric guitar 1
- funky electric guitar chords 1
- funky piano chords 1
- groovy rhodes keys melody 1
- groovy synth keys 1
- groovy synth keys melody 1
- harmonizing background female vocals 1
- harmonizing background vocals 1
- harsh 1
- hip hop 1
- joyful 1
- latin urban 1
- manic 1
- mellow 1
- metal 1
- metallic percussive elements 1
- mono 1
- offbeat wide electric guitar chords 1
- passionate female vocals 1
- passionate male vocals 1
- passionate sitar guitar 1
- piano melody 1
- powerful 1
- pulsating synth melody 1
- repetitive piano melody 1
- reverberant male vocal 1
- rock orchestra 1
- rock playback 1
- saxophone melody 1
- screaming female vocal 1
- shimmering crash cymbal 1
- short offbeat accordion chords 1
- simple hi hats 1
- simple strings melody 1
- snappy snare 1
- soft 1
- soft crash cymbals 1
- soft male vocal 1
- steel drums melody 1
- string melody 1
- sustained organ keys chord 1
- sustained strings melody 1
- synth keys melody 1
- synth lead melody 1
- synth pad 1
- synth pad chords 1
- traditional pop 1
- trumpet melody 1
- unbalanced stereo 1
- wide acoustic guitar chords 1
- wide acoustic rhythm guitar 1
- wide bouncy wooden percussion 1
- wide harmonizing vocals 1
- wide passionate harmonizing male vocals 1
- wooden percussions 1
musiccaps_names (array) 37 ✖
- Music 18
- Funk 3
- Singing 3
- Ska 3
- Song 3
- Electric piano 2
- Electronic organ 2
- Happy music 2
- Keyboard (musical) 2
- Musical instrument 2
- Organ 2
- Piano 2
- Punk rock 2
- Reggae 2
- Rock music 2
- Accordion 1
- Angry music 1
- Background music 1
- Choir 1
- Classical music 1
- Drum kit 1
- Exciting music 1
- Folk music 1
- Guitar 1
- Hip hop music 1
- Music of Asia 1
- Music of Latin America 1
- Opera 1
- Pop music 1
- Progressive rock 1
- Psychedelic rock 1
- Rapping 1
- Rhythm and blues 1
- Sad music 1
- Salsa music 1
- Swing music 1
- Tender music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Muzika kurdi Kurdish Music اغاني كردية - Gule te Je kerina 👍👍👍 | The Folk song features a passionately played sitar guitar, groovy bass and short offbeat accordion chords, followed by metallic percussive elements and punchy kick. The recording is a bit lower in quality due to loud clicky keys sounds. It sounds passionate and emotional. | 2014-12-16T01:20:13Z | Muzika Kurdi | Muzika kurdi - Kurdish Music Gule te Je kerina - اغاني كردية....اشتركو بقناتي# | ["Background music", "Music", "Sad music"] | ["folk", "passionate sitar guitar", "groovy bass", "punchy kick", "metallic percussive elements", "short offbeat accordion chords", "low quality", "clicky keys", "emotional"] | 4 | -sevczF5etI | 94 | |
La Bamba - twist And Shout - Anderson Palopoli | The Low Quality recording features a regional Mexican song sung by reverberant male vocals over acoustic guitar chords, punchy snare and kick hits, groovy bass and funky piano chords. There is a short snare roll at one point that serves as a transition to the next section of the song. Sounds a bit muffled, as it is a live performance, but also energetic and fun. | 2010-03-10T03:24:15Z | WJSTUDIO2010 | Musica do DVD do Showman Anderson Palopoli | ["Music", "Pop music", "Ska"] | ["low quality", "regional mexican", "reverberant male vocal", "acoustic guitar chords", "groovy bass", "funky piano chords", "simple hi hats", "punchy kick", "punchy snare", "snare roll", "energetic", "fun"] | 4 | 1Q9DXhXMSFI | 269 | |
Ethiopia - Sisay Lukas (Mamila) - Eskemeche - (Offical Music Video) - New Ethiopian Music 2015 | The low quality recording features a pop song that contains a soft male vocal singing over soft crash cymbals, claps, punchy kick, shimmering shakers, groovy bass, piano melody and electric guitar melody. It sounds easygoing. | 2015-01-02T18:45:00Z | Ethio One Love | Subscribe now: Sisay Lukas (Mamila) - Eskemeche - (Offical Music Video) - New ETHIOPIAN MUSIC - Ethiopian. © Copyright: Ethio One Love Any unauthorized use, copying or distribution is strictly prohibited. Like us on Facebook:https://www.facebook.com/Ethio1love | ["Music", "Happy music"] | ["low quality", "pop", "electric guitar melody", "punchy kick", "shimmering shakers", "groovy bass", "claps", "soft crash cymbals", "soft male vocal", "piano melody", "easygoing"] | 4 | 1Rd1w7Ty1ak | 273 | |
El Pali - De Agujeritos! | The low quality recording features a regional Mexican song that consists of harmonizing male vocals singing over wide, bouncy wooden percussion, wide acoustic rhythm guitar, groovy bass, punchy kick and strings melody. It sounds passionate, energetic and groovy. | 2009-02-08T22:49:27Z | frager046 | ["Music", "Ska"] | ["regional mexican", "low quality", "wide bouncy wooden percussion", "wide acoustic rhythm guitar", "harmonizing male vocals", "groovy bass", "punchy kick", "strings melody", "passionate", "energetic", "groovy"] | 4 | 3rbWoeUg9yo | 508 | ||
Cristina D'Avena - Shugo Chara - La Magia del Cuore Videosigle HD Dvd version 2 minuti | The low quality recording features a rock song that consists of a passionate female vocal, alongside harmonizing background female vocals, singing over wide acoustic guitar chords, groovy bass, punchy kick and snare hits. It sounds addictive and easygoing, even though the recording is a bit messy. | 2011-03-15T21:08:19Z | Mondosigle | Cristina D'Avena - Shugo Chara - La Magia del Cuore Videosigle HD Dvd version 2 minuti | ["Music", "Happy music"] | ["low quality", "rock", "wide acoustic guitar chords", "groovy bass", "harmonizing background female vocals", "passionate female vocal", "punchy kick", "punchy snare", "shimmering hi hats", "addictive", "easygoing", "messy"] | 4 | 7RtQpW2dSU4 | 846 | |
Lee Min Ho - Faith Korean Drama 2012 | The low quality recording features a pop song that consists of an electric guitar melody, shimmering hi hats, groovy bass, sustained strings melody, pulsating synth melody, punchy kick and echoing synth bell melody. It sounds emotional, passionate and cinematic, as it also sounds like something that would go well as a background music for movies. | 2012-11-02T12:16:52Z | MsDallia91 | Faith also called the great doctor is a Korean historical drama made in 2012 with Lee Min Ho and Kim Hee Sun. | ["Music", "Tender music"] | ["pop", "low quality", "electric guitar melody", "shimmering hi hats", "groovy bass", "sustained strings melody", "pulsating synth melody", "punchy kick", "echoing synth bell melody", "emotional", "passionate", "cinematic", "background music"] | 4 | 8FZb_R2UANY | 906 | |
Upgrade Music vs. Jeon - Ataniro & Ritmo - Amor Cruel | The low quality recording features a latin urban song that consists of a passionate male vocal, alongside wide harmonizing vocals, singing over punchy kick and snare hits, shimmering cymbals, funky electric guitar melody, synth pad chords, groovy bass and synth keys melody. It sounds energetic and addictive. | 2014-05-19T23:20:11Z | Javier' Abreu | Upgrade Music Aruba - Amor Cruel | ["Folk music", "Music", "Rhythm and blues"] | ["low quality", "latin urban", "passionate male vocal", "punchy kick", "punchy snare", "shimmering cymbals", "funky electric guitar melody", "synth pad chords", "groovy bass", "wide harmonizing vocals", "synth keys melody", "energetic", "addictive"] | 4 | 8OsmFmhNjoA | 920 | |
Nightcore Fight Inside | The low quality recording features a metal song that consists of a screaming female vocal singing over punchy kick and snare hits, energetic cymbals, groovy bass guitar, wide distorted electric guitars, strings melody and repetitive piano melody. At the very end of the loop, there is a short distorted static sound. It sounds energetic, aggressive and manic. | 2012-08-10T08:11:02Z | Tobias Fritz Holm | Like and Subscribe. picture: http://i1.ytimg.com/vi/BscoQHJrNm8/maxresdefault.jpg | ["Music", "Angry music"] | ["low quality", "metal", "screaming female vocal", "punchy snare", "energetic cymbals", "punchy kick", "repetitive piano melody", "distorted wide electric guitars", "groovy bass", "strings melody", "energetic", "aggressive", "manic", "distorted static sound"] | 4 | BscoQHJrNm8 | 1300 | |
Brian Auger - Compared to what (Live at Baked Potato) | The low quality recording features a live performance of a jazz song and it consists of a groovy bass guitar, groovy rhodes keys, electric guitar melody, shimmering hi hats, punchy kick and punchy snare hits. It sounds groovy, funky and passionate. The recording is noisy and in mono. | 2011-11-22T14:17:10Z | Bluedreams | The Brian Auger's Oblivion express live at "Baked Potato", Hollywood 2004. The Band is: Brian Auger - Hammond Organ, Keyboards and Electric piano Savannah Grace Auger - Vocals Derek Frank - Bass Karma D. Auger - Drums | ["Organ", "Electric piano", "Electronic organ", "Keyboard (musical)", "Piano"] | ["low quality", "jazz", "live performance", "mono", "noisy", "groovy bass", "groovy rhodes keys melody", "electric guitar melody", "shimmering hi hats", "punchy kick", "punchy snare", "funky", "groovy", "passionate"] | 4 | CrkxrgTiVyk | 1410 | |
Norske Artister - Venn | The low quality recording features a live performance of a rock song that contains harmonizing background vocals, alongside passionate female vocals, singing over wide electric guitar melody, punchy snare, groovy bass, punchy kick and shimmering hi hats and crash cymbals. It sounds emotional, passionate and addictive - thanks to that cadence. | 2007-12-08T21:06:41Z | Primož Dimnik | Norske Artister - Venn (Live) Espen Lind, Lene Marlin, Sivert Hoyem, Thomas Dybdahl; Espen Lind, Lene Marlin, Bertine Zetlitz, Sissel Kyrkjebø, Kurt Nilsen; Ravi, Morten Abel, ... | ["Singing", "Music", "Choir"] | ["low quality", "live performance", "rock", "harmonizing background vocals", "passionate female vocals", "wide electric guitar melody", "punchy snare", "groovy bass", "punchy kick", "shimmering hi hats", "emotional", "passionate", "addictive", "shimmering crash cymbal"] | 4 | EsssGCL-Axw | 1597 | |
Roots Reggae Mix | The low quality recording features a reggae song that consists of passionate male vocals singing over shimmering hi hats, snappy snare, punchy kick, groovy bass, brass melody and funky electric guitar chords. It sounds chill and easygoing. | 2009-01-22T20:42:39Z | lessofslack | A roots reggae mix with horace andy, meditations, congos max romeo, hugh mundell, king tubby! Enjoy Reggae Roots! THE PLAYLIST IS HERE!!!! 1.The Meditations - Rasta Shall Conquer(Greatest Hits 197X)--- 2. Dr Alimantado - Born For a Purpose 3.Dennis Brown - Black Liberation(Words Of Wisdom1979)--- 4.Max Romeo & The Upsetters - My Jamaican Collie(The Coming Of Jah 1967-76)--- 5.Horace Andy - If I(In The Light/In The Light Dub 1977)--- 6.Hugh Mundell - Jah Will Provide(Africa Must Be Free 1983)--- 7.i forgot - update in a few weeks--- 8.The Terrors - Assemble Not Thyself(The Chantells & Friends-Children Of Jah 1977-79)--- 9.Horace Andy - Do You Love My Music(In The Light/In The Light Dub 1977)--- Thanks to all supporters of good old Reggae Tunes! -peace- | ["Funk", "Music", "Reggae", "Song"] | ["low quality", "reggae", "passionate male vocals", "shimmering hi hats", "snappy snare", "groovy bass", "brass melody", "funky electric guitar chords", "punchy kick", "easygoing", "chill"] | 4 | L0-l1LIa22g | 2141 | |
Love me two times 2 (Doors) played on Gibson and piano bass | The low quality recording features a synth lead melody and groovy synth piano playing over rock songs played on playback. The song consists of a punchy kick and snare hits, shimmering hi hats, funky electric guitar melody, groovy bass and passionate male vocals singing over it in the beginning. It sounds funky and groovy, while the recording is a bit noisy. | 2007-04-13T18:21:38Z | serenities | The Doors; Love me two times, played on a Gibson G101 (1967) and a Fender Rhodes Piano Bass (1966). Original background song by The Doors. | ["Organ", "Electric piano", "Electronic organ", "Keyboard (musical)", "Piano"] | ["low quality", "noisy", "rock playback", "punchy snare", "shimmering hi hats", "funky electric guitar melody", "groovy bass", "passionate male vocal", "punchy kick", "groovy synth keys", "synth lead melody", "groovy", "funky"] | 4 | Simd4JoehW8 | 2782 | |
Jon Cleary - When You Get Back (Live at Jazz Fest 2007) | The low quality recording features a live performance of a jazz song that consists of a wide passionate, harmonizing male vocals singing over punchy snare and kick hits, shimmering hi hats, groovy bass guitar, synth pad and funky electric guitar melody. It sounds funky, groovy and passionate. | 2009-04-24T23:01:22Z | Jon Cleary | Jon Cleary live at the New Orleans Jazz & Heritage Festival Follow Jon https://www.facebook.com/jonclearymusicofficial/ https://www.instagram.com/jonclearymusic/ https://twitter.com/jonclearymusic http://www.bandsintown.com/JonCleary | ["Ska"] | ["low quality", "noisy", "jazz", "live performance", "synth pad", "groovy bass", "funky electric guitar melody", "wide passionate harmonizing male vocals", "punchy kick", "punchy kick", "shimmering hi hats", "funky", "groovy", "passionate"] | 4 | _y07ENAx2_E | 3503 | |
Boom Boom Room-J Paul Jr. | The low quality recording features a fruity male vocal singing over steel drums melody, electric guitar melody, brass stabs, punchy kick and snare hits, energetic crash cymbal, groovy bass, shimmering shakers and sustained organ keys chord. It sounds joyful, happy and exciting. | 2011-07-14T03:42:01Z | Bigzydecohal21 | Let Tha Rebel take u to the Boom Boom Room | ["Singing", "Funk", "Music"] | ["low quality", "steel drums melody", "electric guitar melody", "brass stabs", "sustained organ keys chord", "punchy snare", "punchy kick", "groovy bass", "energetic crash", "fruity male vocal", "shimmering shakers", "joyful", "happy", "exciting"] | 4 | d61plJ66vE8 | 3762 | |
Fatima Tuz Zahra Oyshee-De De pal Tule de - Live on RTV MUSIC STATION | The low quality recording features a live performance of a traditional pop song and it consists of an addictive female vocal singing over punchy kick and snare hits, groovy bass, electric guitar melody, strings melody and wooden percussion. There is a short snare roll, right before the bass drops. It sounds messy, a bit harsh, distorted, but also passionate, addictive and energetic. | 2015-11-15T15:01:18Z | Oyshee Express | Singer- Fatima Tuz zahra Oyshee Lyric & Tune: Abdur Rahman Boyati Produced by Khoshru Anchored by Liza Bass Guitar- Sohel Rana Flute: Kamrul Lead Guitar: Roman Keyboard: Nadim Pad: Sakib Percussion: Ujjol | ["Music of Asia", "Music", "Salsa music"] | ["live performance", "low quality", "traditional pop", "addictive female vocal", "punchy snare", "wooden percussions", "snare roll", "groovy bass", "string melody", "electric guitar melody", "punchy kick", "messy", "distorted", "harsh", "passionate", "addictive", "energetic"] | 4 | eISYX9koocM | 3855 | |
Karène Neuville 14 ans - Pasos Lesterps 2015 | The low quality recording features a live performance of a folk song that contains an accordion melody playing over acoustic rhythm guitar, groovy bass, punchy kick and snare hits, shimmering cymbals, saxophone and trumpet melody. It sounds passionate and easygoing, even though the recording is noisy and the stereo image is unbalanced, due to the fact that the sound is leaning towards the left channel. | 2015-07-21T19:29:48Z | Armand Boudet | Je vous invite aujourd'hui à visiter le site www.kareneneuville.fr dans lequel vous trouverez toutes les infos sur l'agenda de Karène et les CD disponibles à la vente | ["Swing music", "Music", "Musical instrument", "Accordion"] | ["low quality", "live performance", "folk", "accordion melody", "acoustic rhythm guitar", "shimmering cymbals", "punchy kick", "punchy snare", "saxophone melody", "trumpet melody", "groovy bass", "noisy", "unbalanced stereo", "passionate", "easygoing"] | 4 | gsIB8HjsRtw | 4064 | |
Sick Funk Jam! Hug Me Squeeze Me! | The Disco song features a passionate female vocalist singing over a funky electric guitar melody, groovy bass, punchy kick and claps. It sounds passionate, funky and groovy - like something you would hear in clubs during the 80s. | 2010-06-21T23:33:22Z | turtle101392 | Debra Hurd- Hug me Squeeze Me | ["Funk", "Music", "Exciting music"] | ["disco", "low quality", "passionate female vocal", "funky electric guitar melody", "groovy bass", "punchy kick", "claps", "passionate", "funky", "groovy"] | 4 | lXrypwLQO3U | 4406 | |
Reply1988 Go Kyung-pyo-Ryu Jun-yeol-Lee Dong-hwi, chnages to 'Fire Engine' for Hye-ri 151113 EP3 | The low quality recording features a live performance of a pop song that consists of harmonizing male vocals singing over punchy kick and snare, shimmering hi hats, groovy bass, brass melody and electric guitar melody. There are some crowd clapping and cheering sounds in the background. It sounds energetic, exciting and groovy. | 2015-11-13T12:53:53Z | tvN drama | tvN Family Comedy Drama Reply 1988 Every Fri-Sat 7:50PM Broadcast | ["Singing", "Music of Latin America"] | ["live performance", "low quality", "crowd clapping", "crowd cheering", "pop", "harmonizing male vocals", "punchy snare", "punchy kick", "shimmering hi hats", "groovy bass", "brass melody", "electric guitar melody", "groovy", "energetic", "exciting"] | 4 | oBBTqXQFTiA | 4608 | |
Silent Hill Shattered Memories - Hell Frozen Rain | The low quality recording features a rock song that consists of a passionate female vocal singing over punchy kick and snare hits, shimmering hi hats, wide electric guitar melody and groovy bass guitar. It sounds energetic and addictive in the first half of the loop, while in the second part it's mellow and softer. | 2009-12-17T08:21:09Z | Person Whatname | Artist : Akira Yamaoka Vocals: Mary Elizabeth McGlynn at 3:56, it's "THERE's one that confuses me". thanks to ares5566 for the correction. From Silent Hill Shattered Memories Soundtrack. This song plays during the credits, depends on which ending you get. AWESOME FACT : at 3:34, you can hear part of Silent Hill 1 theme :) | ["Punk rock", "Psychedelic rock", "Rock music", "Song", "Progressive rock"] | ["low quality", "rock", "passionate female vocal", "wide electric guitar melody", "groovy bass", "shimmering hi hats", "punchy kick", "punchy kick", "mellow", "energetic", "addictive", "soft"] | 4 | qrzNABqN420 | 4828 | |
not ashamed - boundless worship band | The Rock Orchestra song features energetic crash cymbals, punchy kick and snare hits, groovy bass, wide electric guitar chords and simple strings melody. It sounds epic, powerful and energetic - like a theme song for an opening track of some anime. | 2008-06-20T12:19:31Z | awaefler | not ashamed got very famous in the first weeks. Now we're starting with youtube. | ["Music", "Opera", "Song", "Classical music"] | ["low quality", "rock orchestra", "energetic crash cymbals", "punchy kick", "punchy snare", "groovy bass", "wide electric guitar melody", "simple strings melody", "energetic", "epic", "powerful"] | 4 | qwGT6wvYdLo | 4834 | |
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 | |
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 | ||
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 |
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;