musiccaps_details (view)
20 rows where musiccaps_aspects contains "low quality", musiccaps_aspects contains "punchy kick" and musiccaps_aspects contains "shimmering cymbals"
This data as json, CSV (advanced)
musiccaps_aspects (array) 111 ✖
- low quality · 20 ✖
- punchy kick · 20 ✖
- shimmering cymbals · 20 ✖
- punchy snare 15
- energetic 11
- passionate 7
- addictive 4
- emotional 4
- exciting 4
- flat male vocal 4
- groovy bass 4
- acoustic rhythm guitar 3
- distorted bass guitar 3
- groovy bass guitar 3
- noisy 3
- pop 3
- rock 3
- aggressive 2
- chaotic 2
- cover 2
- fruity male vocal 2
- groovy 2
- live performance 2
- messy 2
- metal 2
- passionate female vocal 2
- smooth bass 2
- synth pad chords 2
- wide harmonizing vocals 2
- accordion melody 1
- aggressive male vocals 1
- background vocals 1
- clapping 1
- compilation 1
- crowd chattering 1
- crowd cheering 1
- dirty 1
- distorted bass 1
- drum roll 1
- drums solo 1
- easygoing 1
- electric guitar chords 1
- electro 1
- energetic male vocal 1
- energetic tom rolls 1
- fade in 1
- fade out 1
- filtered background male vocal 1
- filtered synth pad melody 1
- flat echoing male vocal 1
- flat male vocals 1
- folk 1
- fun 1
- funky electric guitar melody 1
- gospel 1
- groovy accordion melody 1
- groovy organ keys 1
- groovy piano melody 1
- groovy snare 1
- happy 1
- harmonizing choir 1
- harmonizing female background vocals 1
- harmonizing vocals 1
- heartfelt 1
- latin urban 1
- mellow bells melody 1
- mellow piano chords 1
- mellow piano melody 1
- mellow synth keys chords 1
- mono 1
- muffled 1
- muffled drums 1
- muffled male vocal 1
- muffled passionate male vocal 1
- outro 1
- passionate electric guitar solo melody 1
- passionate male vocal 1
- playback 1
- punchy bass 1
- punchy tom 1
- punk 1
- r&b 1
- repetitive synth lead melody 1
- reversed high pitched vocal riser 1
- reversed synth keys melody 1
- saxophone melody 1
- short toms roll 1
- smooth bass guitar 1
- snappy rimshots 1
- soft metal 1
- soft rock 1
- soul 1
- soulful 1
- synth keys melody 1
- synth lead melody 1
- thin 1
- trumpet melody 1
- unbalanced stereo 1
- unbalanced stereo image 1
- upbeat 1
- uptempo 1
- uptempo hi hats 1
- uptempo toms rolls 1
- weird 1
- weird repetitive electric guitar melody 1
- wide acoustic rhythm guitars 1
- wide aggressive guitars melodies 1
- wide background melodic male vocals 1
- wide electric guitar melody 1
- wide electric guitars 1
- wide soft whispering male vocals 1
musiccaps_names (array) 44 ✖
- Music 16
- Singing 4
- Angry music 3
- Musical instrument 3
- Drum 2
- Drum kit 2
- Exciting music 2
- Rhythm and blues 2
- Ska 2
- /m/02zsn 1
- Accordion 1
- Background music 1
- Bass drum 1
- Choir 1
- Christian music 1
- Cymbal 1
- Drum and bass 1
- Electric piano 1
- Electronic organ 1
- Folk music 1
- Gospel music 1
- Guitar 1
- Happy music 1
- Hi-hat 1
- Hip hop music 1
- Jazz 1
- Jingle (music) 1
- Keyboard (musical) 1
- Music of Asia 1
- Organ 1
- Percussion 1
- Piano 1
- Plucked string instrument 1
- Pop music 1
- Punk rock 1
- Rapping 1
- Rimshot 1
- Scratching (performance technique) 1
- Snare drum 1
- Speech 1
- Swing music 1
- Tapping (guitar technique) 1
- Wedding music 1
- Zing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Atreyu - Right Side Of The Bed ( LYRICS ) | The low quality recording features a wide, soft whispering male vocals singing over a wide electric guitar melody, shimmering cymbals and drum roll. In the second part of the loop there is an energetic male vocal singing over more energetic electric guitar chords, distorted bass, punchy kick and snare hits and shimmering cymbals. It sounds energetic, aggressive, but also messy and kind of chaotic, since the mix is dirty. | 2008-04-27T17:45:40Z | ShadowsxxProductions | Lyrics For Atreyu's Right Side Of The Bed | ["Music", "Angry music"] | ["metal", "wide soft whispering male vocals", "energetic male vocal", "wide electric guitar melody", "distorted bass guitar", "shimmering cymbals", "drum roll", "punchy kick", "punchy snare", "low quality", "energetic", "aggressive", "dirty", "messy", "chaotic"] | 4 | 2aPVOidHLXI | 386 | |
Tony Lucas & Kris Brooks Shouting Music Praise Break Pt.1 | The low quality recording features groovy organ keys played over punchy kick and snare hits, shimmering cymbals and groovy bass guitar. It sounds energetic, passionate and uptempo. The recording is noisy. | 2009-10-12T04:12:24Z | Ovaljean | Tony Lucas & Kris Brooks playing Shouting Music at Temple St. Jude. Filmed by Anthony Holston, Ovaljean Productions | ["Organ", "Electric piano", "Electronic organ", "Keyboard (musical)", "Piano"] | ["low quality", "uptempo", "noisy", "groovy organ keys", "punchy snare", "punchy kick", "groovy bass guitar", "shimmering cymbals", "energetic", "passionate"] | 4 | 6gTrMRQPZMU | 776 | |
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 | |
Devil in Disguise | The low quality features a rock song that consists of a muffled passionate male vocal singing over wide acoustic rhythm guitars chords, shimmering cymbals, punchy kick and groovy bass. It sounds addictive, passionate and groovy - like something you would hear in pubs and bars during the 50s. | 2009-07-27T16:11:01Z | autopeerke | ["Music", "Rhythm and blues", "Ska"] | ["low quality", "rock", "muffled passionate male vocal", "wide acoustic rhythm guitars", "shimmering cymbals", "punchy kick", "groovy bass", "passionate", "addictive", "groovy"] | 4 | 9UOPRQhNzQ8 | 1014 | ||
Jabbawockeez - Run This Town | The low quality recording features an electro song played on a device that produces the mono sound only. The song features a flat male vocal rapping, after which there is a drop that consists of punchy kick and snare hits, shimmering cymbals and synth lead melody. It sounds exciting and energetic, while the recording is noisy and in mono. | 2010-01-15T02:49:51Z | imajhaynation | http://jbwkz.com | ["Singing", "Scratching (performance technique)", "Music"] | ["low quality", "electro", "flat male vocal", "punchy kick", "punchy snare", "shimmering cymbals", "synth lead melody", "energetic", "exciting", "noisy", "mono"] | 4 | AzGtPHlrlzU | 1187 | |
Fede - Kesha - Your Love is My Drug (Drum Cover) World Version | The low quality recording features a drum cover of a pop song that consists of energetic tom rolls, shimmering cymbals and punchy kick and snare hits. The audio slowly fades out, as it is probably an Outro section of the song. | 2010-11-17T15:24:33Z | FedeRabaquino | Follow me on: Instagram: https://www.instagram.com/federabaquino Facebook: http://www.facebook.com/FedeRabaquinoMusic Twitter: http://www.twitter.com/FedeRabaquino I had to reupload this video due to copyright issues, I appologize for the audio quality, I had to pitch the song 1 semitone lower and touch the eq, to get a different wave of the track to avoid the copyright guys from bolcking my drum cover. I think that people in the US can still watch my original version with hi quality audio. Thank you guys for all the support and comments you leave on each video. About my youtube videos: I have 10 new drum covers, You can watch them in HD 720, I picked the songs, I´ll be uploding new videos every 2 weeks, The drum kit I used in this series is detailed on my youtube page. Please don´t forget to subscribe!!! Kesha - "Your Love is My Drug" from the 2010 release "Animal" Copyrighted property of its owner(s) -{}- Earphones & Headphones: MEElectronics | http://www.meelec.com | ["Cymbal", "Drum", "Drum kit", "Hi-hat", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["low quality", "cover", "pop", "energetic tom rolls", "shimmering cymbals", "punchy kick", "punchy snare", "fade out", "outro"] | 4 | FvdUm5j_oA0 | 1677 | |
Jingle "Lula e Zé No Coração'' Zé Maranhão 15 (PMDB) Paraíba 2006 | The low quality recording features a flat male vocal singing over crowd cheering sound, punchy kick, shimmering cymbals, groovy accordion melody, acoustic rhythm guitar chords and smooth bass guitar. There is a short toms roll before the bass drops. It sounds fun and happy. | 2014-03-20T05:35:44Z | Edimar Gonçalves | ["Jingle (music)", "Music"] | ["low quality", "fun", "happy", "crowd cheering", "flat male vocal", "punchy kick", "shimmering cymbals", "short toms roll", "groovy accordion melody", "acoustic rhythm guitar", "smooth bass guitar"] | 4 | HOIIp5NyFx0 | 1797 | ||
Naruto vs The Nine Tails | The low quality recording features a metal song that consists of an aggressive male vocal, alongside wide harmonizing background vocals, singing over punchy kick and snare hits, shimmering cymbals, distorted bass guitar and wide aggressive electric guitar melody. | 2012-06-14T00:53:29Z | ULTRAnumbAMV | Like, Favorite, Subscribe (I finally got a Naruto fight to upload) | ["Music", "Angry music"] | ["low quality", "metal", "wide harmonizing vocals", "aggressive male vocals", "wide aggressive guitars melodies", "distorted bass guitar", "shimmering cymbals", "punchy kick", "punchy snare", "energetic", "aggressive"] | 4 | JL4Z2_5Q7sU | 1992 | |
A Mother Son Wedding Song (I'll Always Be Your Mother) | The low quality recording features a soul song sung by passionate female vocalists over mellow piano chords, smooth bass, shimmering cymbals and punchy kick and snare hits. There are some crowd chattering sounds. It sounds emotional, passionate and heartfelt. | 2009-02-21T21:19:28Z | mothersonweddingsong | http://www.shopmysongs.com to purchase I'll Always be Your Mother Mother son wedding songs & Father daughter wedding & First Dance Songssongs visit Lyrics...I'll Always Be Your Mother This is a special day When two are joined as one I love my new daughter I'll always love you son Care for each other Be faithful till the end Follow what's in your heart May you always stay best friends Chorus: It's the start of your new life As husband & wife Hope the good days outshine the bad May laughter brighten the sad Know I'm here for you To help or just talk to Believe in each other I'll always be your mother The day will be here soon When you'll have Kids to love God will watch over you From heaven up above Pray for patience & wisdom To give your kids your best You'll teach them right from wrong They'll bring you happiness Chorus Repeat Bridge: I'll always be your mother, it completes my life My tears are filled with love, for you & your new wife You are a caring son, I'll forever be proud of Cherish your new bride, We can always share your love It's the start of your new life Believe in each other I'll always be your mother Copyright © 2006 by Lynn Leonti/Jim McShane Ill Always Be Your Mother is a new mother and son wedding song that I wrote for my sons wedding in 2006. When my son told me he was getting married, I knew I wanted to write a song for him and his new bride. My intention was to give him something special and personal. As I started to write the song, it became more obvious to me that it would be a wonderful song to be played at the wedding that he and I could dance to. The focus of this mother and son song was not so much about him as a boy growing up. It was about his special wedding day and the start of his new life with his new bride. I wanted to welcome his new bride into our family as my new daughter and wanted her to know that we could always share his love. I wanted to let him know that I would always be there for him. … | ["Singing", "/m/02zsn", "Music", "Wedding music"] | ["low quality", "soul", "emotional", "passionate female vocal", "mellow piano chords", "smooth bass", "punchy bass", "punchy kick", "shimmering cymbals", "crowd chattering", "passionate", "heartfelt"] | 4 | KzvdKLdBw3s | 2138 | |
Keith Carlock: Modern Drummer Festival 2005 | The low quality recording features a drummer playing his solo over a weird repetitive electric guitar solo melody. The drums consist of punchy kick and snare hits and shimmering cymbals. Overall it sounds energetic and exciting. | 2008-01-17T21:53:20Z | Hudson Music | Keith Performs at the Modern Drummer Festival 2005. More information at HudsonMusic.com | ["Drum", "Drum kit", "Jazz", "Music", "Musical instrument"] | ["low quality", "weird repetitive electric guitar melody", "punchy kick", "punchy snare", "shimmering cymbals", "energetic", "drums solo", "exciting"] | 4 | P39x5dOsJ40 | 2498 | |
Humbuckers vs P90 Pickups | The low quality recording features a cover of a rock song that consists of passionate electric guitar melody playing over playback. The playback features a groovy bass guitar, punchy snare and kick hits, shimmering cymbals and mellow synth key chords. It sounds groovy - thanks to the bass-drums relationship and passion - thanks to the electric guitar melody. | 2012-11-27T09:11:40Z | intheblues | Humbuckers vs P90 Electric Guitar Pickups. The Red Les Paul is a Tokai Love Rock with Humbucker Pickups The Gold Top is a Gibson Studio Les Paul with P90 Pickups I am playing into a Fender Blues Jr iii Gold Amplifier (into a AxeTrak) with a Klon Overdrive Pedal and a Boss Digital Delay DD7 on Analog mode. This YouTube channel participates in Affiliate programs. These programs are designed in a way for the channel to earn an income by using the links provided in the description or pinned comment section. Please note: Not all links on this Youtube channel are affiliate links. | ["Tapping (guitar technique)", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["low quality", "rock", "passionate electric guitar solo melody", "cover", "playback", "groovy bass guitar", "shimmering cymbals", "punchy snare", "punchy kick", "mellow synth keys chords", "groovy", "passionate"] | 4 | PyVuHAskeUg | 2584 | |
Fifth Harmony "Hero" - Live Week 3 - The X Factor USA 2012 | The low quality recording features a live performance of a pop song that consists of a passionate female vocal, alongside harmonizing background female vocals singing over synth pad chords, punchy kick and snare hits, shimmering cymbals, claps, mellow bells melody and smooth bass. It sounds emotional and passionate. | 2012-11-15T07:55:28Z | Eduardo Villavicencio | 14/11/12 - Top 12 Fifth Harmony sings "Hero" PRE-ORDER FIFTH HARMONY'S NEW SINGLE "BO$$" ON ITUNES NOW http://smarturl.it/5HBOSS | ["Singing", "Music of Asia"] | ["low quality", "passionate female vocal", "harmonizing female background vocals", "shimmering cymbals", "mellow bells melody", "smooth bass", "punchy snare", "punchy kick", "synth pad chords", "emotional", "passionate", "live performance", "pop", "clapping"] | 4 | TiDdR-6bIcY | 2860 | |
Press Play - Unashamed [ Christian Music Video + Download ] | The low recording features a soft rock song that consists of flat, echoing male vocal singing over muffled drums and reversed synth keys melody located in the left channel of the stereo image - which makes the stereo image a bit unbalanced. The drums consist of groovy snare, punchy kicks and shimmering cymbals. At the end of the loop, there is a reversed high pitched vocal riser. It sounds thin and a bit muffled overall. | 2009-05-25T05:29:34Z | snappruss | Press Play - Unashamed [ Christian Music Video + Download ] Download this song as a ringtone at http://www.jesustones.com right now! Press Play - Unashamed [ Christian Music Video + Download ] Press Play - Unashamed [ Christian Music Video + Download ] Press Play - Unashamed [ Christian Music Video + Download ] | ["Drum and bass", "Christian music", "Music"] | ["low quality", "muffled drums", "reversed synth keys melody", "flat echoing male vocal", "reversed high pitched vocal riser", "soft rock", "groovy snare", "punchy kick", "shimmering cymbals", "thin", "muffled", "unbalanced stereo image"] | 4 | afavVsmFWds | 3566 | |
Far East Movement - She's On The Move HQ | The low quality recording features a pop song that consists of harmonizing vocals singing over punchy snare and kick hits and shimmering cymbals. It sounds energetic and exciting. | 2010-03-19T22:20:52Z | Paweł Szymański | Far East Movement - She's On The Move from Gossip Girl S03E14 'The Lady Vanished' I do not own any right to this video! | ["Music", "Exciting music"] | ["low quality", "pop", "harmonizing vocals", "punchy snare", "shimmering cymbals", "punchy kick", "energetic", "exciting"] | 4 | dT7uHHQEYHQ | 3789 | |
Blame! AMV | The low quality recording features a soft metal song that consists of muffled male vocals, alongside wide background melodic male vocals, singing over filtered synth pad, uptempo toms rolls, punchy snare and kick hits and shimmering cymbals. It sounds energetic and addictive. | 2011-04-05T13:27:08Z | Slimjim3k | Recently got into this bad ass Manga called Blame! saw the short anime, had to make an AMV Media used Video: Blame! Ver. 0.11: Salvaged disc by Ciboby Directed by: Shintaro Inokawa Original Manga Written by: Tsutomu Nihei Music by: Celldweller Song: Own Little World (Hujamaflunk Mix) Image at end of video: Frizz-bee (from deviantart) All of the above mentioned assets I own legal copies of, though I do not own the actual material, I do not own any of the content used in this video nor did I make any of it, it was all used without permission. All I did was mash together some music and videos. | ["Music", "Angry music"] | ["low quality", "soft metal", "uptempo toms rolls", "punchy snare", "wide background melodic male vocals", "muffled male vocal", "punchy kick", "shimmering cymbals", "energetic", "addictive", "filtered synth pad melody"] | 4 | fmHbWq-7-iQ | 3976 | |
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 | |
Webisode 8: The Sound Of Music | The low quality recording features a compilation of rock songs in-between which there is a flat male vocal talking. At the very beginning there is a short snippet of a groovy piano melody and fruity male vocal singing over it. After that, there is an even shorter snippet of a song that consists of acoustic rhythm guitar and a male vocalist singing over it. And at the end of the loop, there is a fade in into a flat male vocal singing with background vocals over punchy kick, punchy snare, shimmering cymbals, distorted bass guitar and electric guitar melody. Overall it sounds weird and chaotic, due to the arrangement of the sounds, but it is also energetic. | 2008-08-05T09:05:06Z | weezer | The Sound Of Music Tour Dates after the jump (since the press release is live): Sep 23 Boston, MA Tsongas Arena Sep 24 New York, NY Madison Square Garden Sep 26 Atlantic City, NJ Borgata Casino Sep 27 Philadelphia, PA Susquehanna Center Sep 29 Detroit, MI The Palace of Auburn Hills Sep 30 Toronto, ON Air Canada Center Oct 2 Chicago, IL All State Arena Oct 3 St. Paul, MN Xcel Arena Oct 5 Denver, CO Broomfield Oct 7 Salt Lake City, UT E Center Oct 9 Portland OR Memorial Coliseum Oct 10 Vancouver, BC GM Place Oct 11 Seattle, WA Key Arena Oct 13 San Jose, CA Events Center Oct 14 Los Angeles, CA The Forum Oct 17 San Diego, CA Cox Arena Oct 18 Phoenix, AZ Arizona State Fair Oct 20 Austin, TX Frank Erwin Center Oct 21 Dallas, TX Nokia Theater Oct 23 Houston, TX Reliant Arena Oct 25 Atlanta, GA Gwinnett Arena | ["Music", "Speech", "Exciting music"] | ["compilation", "fade in", "rock", "groovy piano melody", "fruity male vocal", "flat male vocals", "low quality", "punchy snare", "punchy kick", "shimmering cymbals", "background vocals", "electric guitar chords", "acoustic rhythm guitar", "distorted bass guitar", "chaotic", "energetic", "weird"] | 4 | hwe6y-jSqdQ | 4152 | |
FGHT Dallas: Rev. Timothy Wright sings 'He Kept Me', 80/50 Celebration | The low quality recording features a fruity male vocal talking, after which he starts singing over harmonizing choir, groovy bass, mellow piano melody, shimmering cymbals, punchy kick, punchy tom and snappy rimshots. It sounds emotional, soulful and passionate. | 2008-01-08T05:19:40Z | Full Gospel Holy Temple | Rev. Timothy Wright ministers with this song. | ["Singing", "Gospel music", "Choir"] | ["low quality", "fruity male vocal", "gospel", "harmonizing choir", "groovy bass", "mellow piano melody", "shimmering cymbals", "punchy kick", "punchy tom", "snappy rimshots", "emotional", "soulful", "passionate"] | 4 | lSbCqHZy_l4 | 4399 | |
Wale - Focused clean version | The low quality recording features a R&B song that consists of flat male vocals, alongside filtered background male vocals, singing over punchy kick and snare hits, shimmering cymbals, uptempo hi hats, distorted bass and repetitive synth lead melody. It sounds messy, as the frequencies are clashing with each other, but also energetic, emotional and addictive - like something you would quickly learn to sing along. | 2011-11-26T16:53:06Z | DjDrewskie | I was Really Feeiling His Albm But There Was No Clean Version Anywhere So You KNow I Had To Do It! if want anymore songs done comment nd ill get to it I DO NOT OWN ANY RIGHTS TO THIS SONG RML | ["Music", "Rapping", "Zing", "Hip hop music"] | ["low quality", "r&b", "uptempo hi hats", "distorted bass", "repetitive synth lead melody", "filtered background male vocal", "punchy snare", "shimmering cymbals", "punchy kick", "flat male vocal", "energetic", "emotional", "addictive", "messy"] | 4 | nSLxQLYYoNE | 4538 | |
Pocket Rocket - See The Problem (Punk Rock Music Video) | The low quality recording features a punk song that contains flat male vocal singing over punchy kick and snare hits, shimmering cymbals, wide electric guitars and groovy bass guitar. It sounds energetic, exciting and upbeat - like something you would jump to at concerts. | 2006-09-22T06:12:51Z | powerswap | The first music video of the aspiring austrian punk-rock-band "Pocket Rocket". | ["Background music", "Music", "Punk rock", "Pop music", "Ska", "Happy music"] | ["punk", "energetic", "exciting", "groovy bass guitar", "wide electric guitars", "shimmering cymbals", "punchy snare", "punchy kick", "flat male vocal", "upbeat", "low quality"] | 4 | pbVYSktQ5jE | 4726 |
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;