musiccaps_details (view)
16 rows where search matches "guitar", musiccaps_aspects contains "groovy bass guitar", musiccaps_aspects contains "punchy kick" and musiccaps_aspects contains "shimmering hi hats"
This data as json, CSV (advanced)
musiccaps_aspects (array) 80 ✖
- groovy bass guitar · 16 ✖
- punchy kick · 16 ✖
- shimmering hi hats · 16 ✖
- punchy snare 10
- low quality 9
- rock 9
- energetic 7
- flat male vocal 7
- passionate male vocal 5
- addictive 4
- emotional 4
- groovy 4
- live performance 4
- arpeggiated electric guitar melody 3
- exciting 3
- noisy 3
- electric guitar melody 2
- energetic crash cymbal 2
- energetic cymbals 2
- fun 2
- happy 2
- passionate 2
- pop 2
- snappy rimshots 2
- wide electric guitar melody 2
- aggressive 1
- aggressive electric guitar riffs 1
- alternative rock 1
- clapping 1
- claps 1
- crowd cheering 1
- crowd singing 1
- crushed snare 1
- drum sticks countdown 1
- easygoing 1
- echoing female exhale sound 1
- electric guitar mellow feedback 1
- electric guitar melodies 1
- electric guitars melodies 1
- energetic crash cymbals 1
- euphoric 1
- flat female vocal 1
- funky electric guitar melody 1
- groovy piano chord progression 1
- groovy piano chords 1
- groovy piano melody 1
- humming 1
- in game audio 1
- instrumental 1
- messy 1
- mono 1
- muddy 1
- passionate electric guitar solo melody 1
- playback 1
- popping sounds 1
- punk 1
- regional mexican 1
- shimmering bells melody 1
- shimmering tambourine 1
- shoe tapping 1
- short snare rolls 1
- sloppy 1
- smooth 1
- soft rock 1
- soft synth keys melody 1
- soulful 1
- squeaky sound effect 1
- sustained strings melody 1
- sweet female vocal 1
- synth lead melody 1
- tom roll 1
- unbalanced stereo 1
- uplifting 1
- wide acoustic guitar melody 1
- wide electric guitar chords 1
- wide electric rhythm guitar 1
- wide harmonizing background vocals 1
- wide harmonizing mixed vocals 1
- wide mellow synth pad 1
- wooden bouncy percussion 1
musiccaps_names (array) 29 ✖
- Music 16
- Rock music 4
- Singing 4
- Independent music 3
- Song 3
- Musical instrument 2
- Psychedelic rock 2
- Punk rock 2
- Speech 2
- Bass guitar 1
- Blues 1
- Christmas music 1
- Country 1
- Funk 1
- Gospel music 1
- Grunge 1
- Guitar 1
- Happy music 1
- Heavy metal 1
- Jingle (music) 1
- Plucked string instrument 1
- Progressive rock 1
- Rock and roll 1
- Sad music 1
- Ska 1
- Soul music 1
- Squeak 1
- Tap 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 |
---|---|---|---|---|---|---|---|---|---|---|
Coco Party - Dancing Queens iPhone Gameplay #DroidCheatGaming | The low quality recording features an in-game audio recording that features an echoing female exhale sound, shimmering hi hats, claps, shimmering bells melody and groovy bass guitar. In the second half of the loop, the song changes and there is a sweet female vocal humming a melody. It sounds exciting, happy and fun. | 2015-06-29T16:56:52Z | DroidCheat | *If you enjoyed my video please Comment, Like, Favorite, Subscribe and Share as this really helps me :) More Videos http://www.youtube.com/DroidCheat iTunes App Store https://itunes.apple.com/us/app/coco-party-dancing-queens/id966516051?mt=8 *Playlists Hungry Shark Evolution https://www.youtube.com/playlist?list=PL0nbKWe8lMkK1Z0LfBCdx3viTQr5WBHCX *Pou https://www.youtube.com/playlist?list=PL0nbKWe8lMkLWeka6q4KGk9khezThSa4y *Gameplay https://www.youtube.com/playlist?list=PL0nbKWe8lMkJgQCA2_N1kTTK2qk7LifQb *Subway Surfers https://www.youtube.com/playlist?list=PL0nbKWe8lMkJxN1_hhWMhONPHWp_VOT2O *Angry Birds https://www.youtube.com/playlist?list=PL0nbKWe8lMkLZvgE0MIi2wdZw6_QoujwD Coco's big party is coming up and she needs your professional styling help! Do you have what it takes to make Coco the Dancing Queen? Dress up Coco in the most stylish dancing outfits and get her ready for the big party! Dance with Coco and show off your hottest moves before a panel of professional judges! Express your unique sense of style with this luxurious, 3D fashion app! Personalize Coco and choose from over 200 of the hottest outfits and accessories! ! You can even choose Coco's hair color and skin tone! Head to the spa, apply professional makeup, and show off your stunning new dance party look! Features: √ Dance with Coco and show off your moves at the big party! √ Perform for the judges and await your scores! √ Be Coco’s very own stylist! √ Choose from the most glamorous outfits and trendy accessories! √ Customize Coco’s look — choose her skin tone, eyes, lips, hair, and more! √ Enjoy SPA time! Relax at the Coco Spa! √ Smile for the camera! Take photos of Coco's stunning new look! #DroidCheatGaming #Letsplay #gaming #gamer #videogames #games #game #androidgames #gameplay | ["Music", "Speech", "Happy music"] | ["low quality", "popping sounds", "echoing female exhale sound", "shimmering hi hats", "happy", "fun", "sweet female vocal", "humming", "claps", "punchy kick", "shimmering bells melody", "groovy bass guitar", "in game audio", "exciting"] | 4 | 0khKvVDyYV4 | 205 | |
"Watermelon Crawl" Line Dance | The low quality recording features clapping and shoe tapping sounds over rock songs played on playback. The song consists of a passionate male vocal that sings over punchy kick and snare hits, shimmering hi hats, electric guitar melody and groovy bass guitar. The recording is in mono and a bit noisy, as it was probably recorded with a phone. | 2010-03-27T06:09:42Z | Linda Turner | Nashville West, Ceres, California Country Line Lessons March 25. 2010. NO COPYRIGHT INFRINGEMENT INTENDED. I do not own anything. All rights reserved to the respective music labels. This is only used as a teaching guide or tool to the line dance world. "Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for "fair use" for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favor of fair use." | ["Country", "Music", "Tap"] | ["low quality", "clapping", "shoe tapping", "mono", "noisy", "rock", "playback", "passionate male vocal", "electric guitar melody", "punchy snare", "shimmering hi hats", "groovy bass guitar", "punchy kick"] | 4 | 1_YHHL_t2GI | 289 | |
Fed Up - "So Stupid" | The low quality recording features a punk song that consists of a groovy bass guitar, punchy kick, shimmering hi hats, energetic cymbals and aggressive electric guitar riffs. At the very beginning of the loop, there is a drum stick countdown, after which the bass drops. It sounds energetic, groovy and aggressive. | 2007-05-04T20:57:37Z | f1rstperson | This was the first music video I ever edited and filmed. It is simply awful, but it's fun too look back at the process and realize the things we learn. The band Fed Up was from Kansas City...this song was off their first EP....and they grew to be one of the best punk rock bands around (in my opinion). Check out the other video I did for them 3 years later...called "When Looking Back". | ["Bass guitar", "Heavy metal", "Music", "Punk rock", "Rock music", "Progressive rock"] | ["punk", "low quality", "groovy bass guitar", "punchy snare", "punchy kick", "shimmering hi hats", "energetic cymbals", "aggressive electric guitar riffs", "aggressive", "energetic", "groovy", "drum sticks countdown"] | 4 | ARXTRdKCupM | 1115 | |
Felix Hagan & The Family - Sing Your Last Lullaby | The Rock song features a flat male vocal singing over a wide electric guitar melody, shimmering hi hats, energetic crash cymbals, punchy snare and kick hits, groovy bass guitar and piano chord progression. At the end of the loop, there is a short tom roll, representing a transition to the next section. It sounds energetic - like something you would hear on a radio. | 2013-08-13T22:24:25Z | Felix Hagan | This is the second video from our EP, String Up The Entertainer, which will be released in September. It is quite possibly the silliest thing we have ever done. We hope you enjoy it. For gigs, news, photos and everything else visit: http://www.facebook.com/felixhaganmusic The EP, along with our last album, will be available to download at: http://felixhagan.bandcamp.com/ Twitter also exists: @FelixHagan Feel free to check out our other videos on here and if you like them, come down to a show! We'd love to meet you. Crew: Director: Joe Mannion - sleepingstate.com DOP: Guy Gotto Camera Assistant: Rob Abercrombie Hair and Make Up: Rebecca Doney Cast: Jesus: Felix Hagan Judas: Ellie Cowan Peter: Will Stanley Disciples: Tash Hodgson, Stuart Mann, Tom Webber, Effie Stoodley, Gareth Williams, Rebecca Doney, Jess O'Neill, Amy Schofield, David Wilson and Rob Abercrombie. We would especially like to thank Clare College, Cambridge and Effie Stoodley for being simply beautiful and providing us with the perfect location in which to hurl custard about. We would also like to thank Dunn's Bakery, Crouch End for arming us with such delicious ammo. Go there and eat everything. That's an order. | ["Music", "Punk rock", "Independent music"] | ["rock", "flat male vocal", "wide electric guitar melody", "groovy piano melody", "shimmering hi hats", "energetic crash cymbals", "punchy kick", "groovy bass guitar", "energetic", "tom roll"] | 4 | CIoEXRnAr-Y | 1349 | |
Deep Purple- Perfect Strangers Live | The low quality recording features a live performance of a rock song that's sung by flat male vocals and played by electric guitars, groovy bass guitar and energetic drums that consists of punchy kick and snare hits and some short snare rolls, energetic cymbals and shimmering hi-hats. At one point in the loop, it seems that the drummer fell out of rhythm, so it kind of sounds sloppy. It also sounds very noisy, messy, muddy, but still energetic too. | 2007-08-14T22:42:57Z | NaturallyStoopid | One of the best performances of Deep Purple And I am proud to add them to my channel. This was performed in 2002 And is part of the DVD "PERIHELION". The Line-up Consists of Ian Gillan (vocals), Steve Morses (lead), Roger Glover (bass), Jon Lord (Keyboards) and Ian Paice (drums) Unfortunately the only way for me to get a dvd recording onto youtube for free is to use a service which only allows you to add each part by 30 seconds so it took a long time to put up but please enjoy one of THE best performances of this line up with an added keyboard solo/s | ["Singing", "Music", "Psychedelic rock", "Rock music"] | ["low quality", "noisy", "live performance", "rock", "electric guitars melodies", "groovy bass guitar", "flat male vocal", "energetic cymbals", "punchy snare", "short snare rolls", "punchy kick", "sloppy", "energetic", "shimmering hi hats", "messy", "muddy"] | 4 | CMfAu72qma0 | 1357 | |
iSqueek - Dog Squeak Toys | The low quality recording features an alternative rock song that consists of crushed snare hits, punchy kick, shimmering hi hats, groovy bass guitar, widely spread electric rhythm guitar and wide mellow synth pad, followed by some squeaky sound effects. It sounds groovy. | 2009-07-12T21:26:18Z | HarryAppsLLC | I developed this app inspired by my late dog's toys so I could have something to remember him by. Story behind iSqueek: http://www.harryapps.com/Harry_Apps_LLC/Story.html iSqueek on iTunes: http://itunes.apple.com/app/isqueek-dog-squeak-toys/id322043400?mt=8 Website: http://www.isqueek.com/ Twitter: http://www.twitter.com/isqueekapp/ Rated top ten best dog apps on iTunes app store | ["Music", "Squeak"] | ["low quality", "alternative rock", "crushed snare", "squeaky sound effect", "groovy bass guitar", "wide electric rhythm guitar", "wide mellow synth pad", "shimmering hi hats", "punchy kick", "groovy"] | 4 | EXRKJRL0TDU | 1565 | |
Mais häckseln / Corn chopping | #landwirt100k | The Rock instrumental features a passionate electric guitar solo melody played over punchy kick and snare hits, shimmering hi hats, groovy bass guitar, wooden bouncy percussion and electric guitar, mellow feedback, located in the left channel of the stereo image. It sounds groovy, addictive and passionate, thanks to that solo melody. | 2015-10-06T20:27:24Z | Franz Gosch | Fendt 310 Vario Fendt 716 Vario TMS + Kemper Champion 3000 Fendt 309 Vario TMS Steyr 768A Valtra N103.4 H5 | ["Music", "Grunge"] | ["rock", "instrumental", "groovy bass guitar", "passionate electric guitar solo melody", "punchy kick", "punchy snare", "wooden bouncy percussion", "shimmering hi hats", "electric guitar mellow feedback", "groovy", "addictive", "passionate"] | 4 | I4Jp0kB2Ns0 | 1870 | |
ずっと好きだった | The low quality recording features a live performance of a rock song and it consists of a passionate male vocal singing over groovy bass guitar, wide electric guitar melody, shimmering hi hats, punchy kick and snare hits. It sounds energetic and exciting. | 2011-10-08T06:45:59Z | Sheik | ["Singing", "Music", "Rock music", "Rock and roll"] | ["low quality", "rock", "live performance", "passionate male vocal", "wide electric guitar melody", "groovy bass guitar", "shimmering hi hats", "punchy kick", "punchy snare", "energetic", "exciting"] | 4 | InfQUMh935c | 1941 | ||
Das Leben ist ein Rodeo Schule Illingen Hiss | The Rock song features a flat male vocal singing over arpeggiated electric guitar melody located in the right channel of the stereo image, groovy bass guitar, punchy kick and snare hits and shimmering hi hats. The stereo image is unbalanced because of the electric guitar, which makes it lean towards the right channel. It sounds energetic, groovy, happy and fun. | 2012-04-21T15:03:23Z | 55alwin | Ein Stopp-Motion Projekt der Klasse H6, GHRS Illingen | ["Funk", "Music", "Rock music", "Ska"] | ["rock", "groovy bass guitar", "punchy snare", "flat male vocal", "shimmering hi hats", "punchy kick", "arpeggiated electric guitar melody", "energetic", "groovy", "unbalanced stereo", "happy", "fun"] | 4 | JNwt0afB1fQ | 1998 | |
Foreigner, Feels like the first time with lyrics | The Rock song features a passionate male vocal singing over punchy kick and snare hits, shimmering hi hats, groovy bass guitar and electric guitar melodies. It sounds energetic and exciting. | 2010-03-11T05:56:00Z | JohnysMusicChannel | song: feels like the first time artist: foreigner lyrics: I would climb any mountain Sail across a stormy sea If that's what it takes me baby To show you how much you mean to me And I guess it's just the woman in you That brings out the man in me I know I can't help myself You're all in the world to me It feels like the first time Feels like the very first time It feels like the first time It feels like the very first time I have waited a lifetime Spent my time so foolishly But now that I've found you Together we'll make history And I know that it must be the woman in you That brings out the man in me I know I can't help myself You're all that my eyes can see And it feels like the first time Like it never did before Feels like the first time Like we've opened up the door Feels like the first time Like it never will again, never again Feels like the first time, it feels like the first time It feels like the very first time, very, very, it feels It feels like the first time, oh it feels like the first time It feels like the very first time Open up the door, won't you open up the door? yeah Feels like the first time And it feels like the very first time And it feels like the first time It feels like the very first time And it feels like the first time It feels like the very first time Oh it feels, it feels like the first time Yeah it feels like the first time | ["Singing", "Guitar", "Music", "Musical instrument", "Psychedelic rock", "Plucked string instrument"] | ["rock", "passionate male vocal", "punchy kick", "punchy snare", "shimmering hi hats", "groovy bass guitar", "electric guitar melodies", "energetic", "exciting"] | 4 | PfO7ZVdzfZ4 | 2556 | |
Chiquilla. Interpretacion GRUPO FREE SOUNDS de Ensenada, BC | The low quality recording features a live performance of a regional Mexican song and it consists of passionate male vocal singing over groovy bass guitar, mellow synth keys melody and electric guitar melody, followed by shimmering tambourine, hi hats and punchy kick. It sounds passionate, emotional and soulful - like something you would hear at family gathering events. | 2012-04-20T18:44:22Z | victor lopez | PRESENTACION EN EL PROGRAMA LA VELADA DE SINTESIS TELEVISION TIJUANA (DERECHOS RESERVADOS) DEL GRUPO MUSICAL FREE SOUNDS DE ENSENADA, BC | ["Christmas music", "Gospel music", "Music", "Song"] | ["low quality", "live performance", "regional mexican", "passionate male vocal", "groovy bass guitar", "soft synth keys melody", "shimmering tambourine", "punchy kick", "electric guitar melody", "noisy", "passionate", "emotional", "soulful", "shimmering hi hats"] | 4 | RNwiEsjrhiQ | 2694 | |
Jef Neve en Café Corsari coveren Happy Together voor Music For Life | The Pop song features a passionate male vocal, alongside widely spread harmonizing mixed vocals, singing over groovy piano chord progression, funky electric guitar melody, groovy bass guitar, shimmering hi hats, punchy kick and punchy snare. It sounds emotional, addictive and euphoric - like a Christmas song. | 2014-12-01T21:30:02Z | Eén | Jef Neve en Café Corsari slaan de handen in elkaar voor Music For Life van Studio Brussel. Koop de single "Happy Together" op iTunes en steun integratie-orkest Poco A Poco. iTunes: itunes.apple.com/be/album/happy-together-single/id946169029?uo=4 Poco A Poco: pocoapoco.be/ Music For Life: musicforlife.stubru.be/ Café Corsari: een.be/CafeCorsari Met dank aan: Frank Deboosere Pat Krimson & Loredana Paul Michiels Maxine Michiels Marcel Vanthilt Peter Van de Veire Kate Ryan Andrea Croonenberghs Koen Crucke Tomas De Soete Freek Braeckman Kenji Minogue Kristof Uittebroek Gregory Frateur Laura Lynn Johannes Genard Stijn Meuris Udo Free Souffriau Bart Kaëll & Luc Appermont Koen & Kris Wauters Jelle Van Dael Tatyana Beloy Bandits Helmut Lotti Jelle Cleymans Ben Roelants Integratie-orkest Poco A poco Karen Damen Cath Luyten Eva Daeleman Saartje Vandendriessche Bert Verbeke Pieter Peirsman Daan Hugaert Ann Pira Guido Belcanto Guga Baúl Clara Cleymans Flip Kowlier Isolde Lasoen Tijs Delbeke Sioen Jo Hermans Wietse Meys Pieter Kindt Audio engineer: Jasper Maekelberg Assistant engineer: Andres Algaba Mastering engineer: Steven Maes Assistants: Philip clinckspoor en Jens De Wit Regie: Maarten Verhulst Camera: Jan Mestdagh & Manu De Smet Klank: Marco Bernaerts Make-up: Sandra Antheunis – Anne-Laure Rondel – Jelle Jacques – Lynne Van Vynckt Licht: Never Fear Shadows en PRG-EML Montage: PixMix Studios Opgenomen, gemixt en gemasterd te MotorMusic Studio’s, Mechelen. | ["Music", "Song", "Soul music"] | ["wide harmonizing mixed vocals", "passionate male vocal", "punchy snare", "groovy piano chord progression", "funky electric guitar melody", "groovy bass guitar", "pop", "shimmering hi hats", "punchy kick", "emotional", "addictive", "euphoric"] | 4 | XkBXsaSXDJ0 | 3219 | |
I've Got My Glasses On 👓 Wearing Glasses Song for Children 🧐🤓😎 The Wiggles | The low quality recording features a rock song that consists of a flat male vocal and flat female vocal talking, followed by punchy kick and snare hits, shimmering hi hats, energetic crash hits, wide electric guitar chords, groovy bass guitar and synth lead melody. It sounds energetic. | 2013-02-07T23:21:04Z | The Wiggles | Subscribe to our channel for more Wiggly videos: http://ab.co/WigglesYouTube For more Wiggly fun: Website ► http://TheWiggles.com.au Facebook ► http://facebook.com/TheWiggles Twitter ► http://twitter.com/TheWiggles Instagram ► http://instagram.com/TheWiggles Spotify ► https://ab.co/TheWigglesSpotify US & UK Shop ► https://thewigglestore.com/ AUS Shop ► https://thewigglestore.com.au/ #glasses #kidsglasses #thewiggles | ["Music", "Independent music", "Speech"] | ["low quality", "rock", "flat female vocal", "flat male vocal", "energetic crash cymbal", "groovy bass guitar", "wide electric guitar chords", "synth lead melody", "shimmering hi hats", "punchy kick", "punchy snare", "energetic"] | 4 | b-Y-AjW6MJ0 | 3594 | |
The Cult - Painted On My Heart (Official Music Video) + Lyrics [HQ Sound + HD Video] | The Soft Rock song features a flat male vocal singing over arpeggiated electric guitar melody, punchy kick, groovy bass, shimmering hi hats and snappy rimshots. It sounds emotional and easygoing. | 2010-07-16T10:19:34Z | Music Guide | OFFICIAL / ORIGINAL MUSIC VIDEO FOR THIS SONG. Artist: The Cult Song: Painted On My Heart SoundTrack From The Movie: Gone in 60 Seconds NOTE: I Don't Own Any Content Of This Song. Lyrics: I thought you'd be out of my mind And I'd finally found a way to Learn to live without you I thought it was just a matter of time Till I had a hundred reasons Not to think about you But it's just not so And after all this time I still can't let go I've still got your face Painted on my heart Scrawled upon my soul Etched upon my memory baby I've got your kiss Still burning on my lips The touch of my fingertips Is love so deep inside of me I was trying everything that I can To get my heart to forget you But it just can't seem to I guess it's just no use In every part of me Is still a part of you I've still got your face Painted on my heart Scrawled upon my soul Etched upon my memory baby I've got your kiss Still burning on my lips The touch of my fingertips Is love so deep inside of me I've still got your face Painted on my heart Painted on my heart Painted on my heart Something in your eyes keeps haunting me I'm trying to escape you And I know there ain't no way to To chase you from my mind I've still got your face Painted on my heart Scrawled upon my soul Etched upon my memory baby I've got your kiss Still burning on my lips The touch of my fingertips Is love so deep inside of me, baby I've still got your face I've still got your face painted on my heart painted on my heart painted on my heart | ["Music", "Sad music", "Tender music"] | ["soft rock", "flat male vocal", "arpeggiated electric guitar melody", "punchy kick", "groovy bass guitar", "shimmering hi hats", "snappy rimshots", "emotional", "easygoing"] | 4 | bBGcQ2-W768 | 3609 | |
Compact - Fata din vis | The low quality recording features a live performance of a rock song and it consists of flat male vocal singing over arpeggiated electric guitar melody, groovy bass guitar, shimmering hi hats, snappy rimshots and punchy kicks. In the background, there are some crowd singing and crowd cheering noises. It sounds emotional and a bit addictive. | 2008-04-19T14:23:33Z | Horia D | nice love song | ["Blues", "Singing", "Music", "Musical instrument"] | ["low quality", "live performance", "rock", "crowd cheering", "crowd singing", "flat male vocal", "punchy kick", "snappy rimshots", "shimmering hi hats", "arpeggiated electric guitar melody", "groovy bass guitar", "emotional", "addictive"] | 4 | cTJqIkSuf6s | 3710 | |
Jingles Eleições 2010 - Angela Amin - PP - leobrandao.net | The Pop song features a flat male vocal, alongside wide harmonizing background vocals, singing over punchy kick and snare hits, shimmering hi hats, energetic crash cymbals, groovy piano chords and widely spread acoustic guitar melody. It sounds smooth, uplifting and addictive thanks to those harmonizing vocals. | 2010-11-22T18:27:42Z | LB Jingles | Cortesia do site http://jingles.leobrandao.net Jingle Eleições 2010 Nome: Angela Amin - Santa Catarina Coligação: Aliança com Santa Catarina PP - PDT - PT do B | ["Jingle (music)", "Music", "Independent music", "Song"] | ["pop", "sustained strings melody", "flat male vocal", "punchy snare", "wide harmonizing background vocals", "punchy kick", "shimmering hi hats", "energetic crash cymbal", "groovy piano chords", "wide acoustic guitar melody", "uplifting", "groovy bass guitar", "smooth", "addictive"] | 4 | lvktro0asjs | 4430 |
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;