musiccaps_details (view)
18 rows where search matches "guitar", musiccaps_names contains "Flamenco" and musiccaps_names contains "Plucked string instrument" sorted by youtube_link
This data as json, CSV (advanced)
Suggested facets: musiccaps_names
musiccaps_aspects (array) >30 ✖
- acoustic guitar 8
- flamenco 7
- instrumental 6
- emotional 4
- easygoing 3
- exotic 3
- low quality 3
- noisy 3
- nylon string guitar 3
- sensual 3
- acoustic guitar arpeggio 2
- live performance 2
- medium tempo 2
- mellow 2
- mono 2
- no singer 2
- passionate 2
- rock music 2
- romantic 2
- single instrument 2
- acoustic 1
- acoustic flamenco guitar melody 1
- acoustic rhythm guitar chords progression 1
- additive rhythm 1
- amateur recording 1
- arpeggiated acoustic flamenco guitar melody 1
- buzzy 1
- calming 1
- classical guitar 1
- clean sound 1
- …
youtube_published (date) 18 ✖
- 2006-05-24 1
- 2006-09-07 1
- 2007-05-27 1
- 2007-09-24 1
- 2008-07-24 1
- 2009-02-25 1
- 2009-03-21 1
- 2010-02-17 1
- 2010-05-08 1
- 2010-11-24 1
- 2011-11-22 1
- 2011-11-24 1
- 2012-05-06 1
- 2012-11-02 1
- 2013-07-15 1
- 2014-08-22 1
- 2015-06-02 1
- 2015-07-07 1
musiccaps_names (array) 15 ✖
- Flamenco · 18 ✖
- Plucked string instrument · 18 ✖
- Music 17
- Guitar 15
- Musical instrument 14
- Acoustic guitar 12
- Strum 8
- Speech 2
- Bass guitar 1
- Country 1
- Folk music 1
- Mandolin 1
- Music of Latin America 1
- Steel guitar, slide guitar 1
- Ukulele 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Change The World, Eric Clapton, Fingerstyle Guitar, Jake Reichbart, lesson available | This is an instrumental rock music piece. The piece is being performed on a clean sounding electric guitar. There is an easygoing guitar solo being played. The atmosphere is groovy. This piece could be used as an advertisement jingle. | 2008-07-24T14:41:20Z | Jake Reichbart | Updated 2021: I have continued to post a new guitar arrangement nearly every Friday for the past 12 years, currently up to 550+ guitar arrangement videos. I have also produced 200+ full length video lessons teaching some of my most popular arrangements note for note, going into right hand technique, articulation, improvisation and 100 other topics that solo guitar arranging is made of. To learn all about my lessons, cost and discounts, please visit here: https://www.jakereichbart.com/jr-lessons.html check out also my method lesson "An introduction to fingerstyle guitar and solo guitar arranging" here: https://youtu.be/Yug7Qe-xNXs email me jake.reichbart@gmail.com with any questions. Also, please consider becoming a patron for as little as $3 at https://www.patreon.com/JakeReichbart Monthly lessons, on air requests, custom arrangements made just for you are among the perks offered, please take a look, thanks! The best fingerstyle guitar lessons on YouTube! Please read on! Updated June, 2018 - An hour long widescreen DVD lesson - also downloadable - on how to perform this arrangement, and much more, is now available!!! Every note and chord is shown slowly and in closeup. No online store, just email me at jake.reichbart@gmail.com to learn more! All my video guitar lessons are now also available as downloads, simply email jake.reichbart@gmail.com for all the info and just write "Guitar Lessons", or similar, in the subject line! Most lessons are on my specific song arrangements for solo guitar, check out these samples: https://www.youtube.com/watch?v=LM2ZyCduUqk Also check out my lesson "How to Arrange Any Song for Solo Guitar": http://www.youtube.com/watch?v=jg-et0nVgo8 #fingerstyle #fingerstyleguitar #acousticguitar #guitarcover #jazzguitar #acousticcover #sologuitar A complete list of all my 200+ guitar lessons, and much more, is available at https://www.jakereichbart.com/guitar-video-lessons/dvds-downloadable-guitar-lessons.html and you can also email me at jake.reichbart@gmail.com for more info. Please… | ["Flamenco", "Guitar", "Musical instrument", "Plucked string instrument"] | ["rock music", "no singer", "instrumental", "single instrument", "electric guitar", "clean sound", "guitar solo", "easygoing", "groovy"] | 9 | QS3DabGF41Y | 2619 | |
David Serva por Seguiriya | This song features a guitar being played to a flamenco melody. Fingerstyle guitar is used. The song starts off at a higher register and ends at the lower register. The guitar is strummed at intervals. There are no other instruments in this song. There are no voices in this instrumental song. This song has a romantic mood. This song can be played at a quiet restaurant overlooking the sunset. | 2010-05-08T16:19:56Z | Dararith Long | David Jones (Serva) por Seguiriya in one of his public recordings. I really like the intro. The bulerias ending is quite nice as well. About the life of Serva: http://www.sfflamenco.com/historical/features/2002-04/balladofgypsydavy.html | ["Flamenco", "Acoustic guitar", "Music", "Strum", "Plucked string instrument"] | ["guitar song", "flamenco", "fingerstyle guitar", "no other instruments", "no voices", "instrumental", "moderate tempo", "romantic mood", "no percussion"] | 0 | EIzBD62ja8E | 1543 | |
FLAMENCO GUITAR CHILL-OUT | The low quality recording features an arpeggiated acoustic flamenco guitar melody. The recording is noisy, in mono, and it sounds sad, easygoing and emotional. | 2007-09-24T10:53:49Z | maitzegur | Flamenco Chill-Out | ["Flamenco", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["low quality", "mono", "noisy", "arpeggiated acoustic flamenco guitar melody", "sad", "emotional", "easygoing"] | 4 | IKfmu7tAyUE | 1894 | |
FLAMENCO GUITAR METHOD by atrafana | This is a compilation of various flamenco recordings. The acoustic guitar is being played at first with the picado technique and then with the free stroke technique. There is a percussive backing track in each part. The music has an exotic feel to it. These separate parts could be used as an advertisement jingle or they could be sampled for use in beat-making. | 2015-06-02T13:05:38Z | atrafanaSchool | Get the Flamenco Guitar Method: https://gumroad.com/l/DFrI ---------------------------------------------------------------- FLAMENCO GUITAR METHOD contents: The method addresses beginner and intermediate players. Instructional videos are accompanied by both interactive and PDF sheet music in both standard notation and tablature. 46 videos in total with associated tabs Contents Overview: How to Develop Picado Speed The Comprehensive Picado Package Free Stroke Fundamentals Pulgar Training Package Alzapua Training Package Arpeggio Package Tremolo Training Package Legato Mastery Package Compas Strumming Developing Rasgueado Detailed Contents: FLAMENCO 01 The Comprehensive Picado Package (4 videos) Video: How to Develop Picado Speed 10 Picado Agility Exercises- video + tabs (tef, pdf) Daily Picado Routine - video + tabs (tef, pdf) Picado Speed Drill - Sextuplets - video + tabs (tef, pdf) Free Stroke Fundamentals (3 videos) Video: Free Stroke Fundamentals; free stroke action, producing good tone, combining free stroke with the rest stroke thumb Basic Free Stroke Exercise 01 - video + tabs (tef, pdf) Basic Free Stroke Exercise 02 - video + tabs (tef, pdf) Pulgar Training Package (7 videos) Basic Flamenco Pulgar Instructional video pulgar buleria 01 - video + tabs (tef, pdf) pulgar buleria 02 - video + tabs (tef, pdf) pulgar solea 01 - video + tabs (tef, pdf) pulgar solea 02 - video + tabs (tef, pdf) pulgar tangos 01 - video + tabs (tef, pdf) pulgar tangos 02 - video + tabs (tef, pdf) FLAMENCO 02 Alzapua Training Package (6 videos) Video: Alzapua Basics Alzapua Exercise - 1 - Malaguena - video + tabs (tef, pdf) Alzapua Exercise - 11 - Fandangos de Huelva - video + tabs (tef, pdf) Alzapua Exercise - 12 - Solea - video + tabs (tef, pdf) Alzapua Exercise - 13 - Solea por Buleria - video + tabs (tef, pdf) Alzapua Exercise - 00 - Buleria - video + tabs (tef, pdf) Arpeggio Package (5 videos) Arpeggio Exercise - 1 - El Vito - video + tabs (tef, pdf) Arpeggio Exercise - 3 - Malaguena - video + tabs (tef, … | ["Flamenco", "Guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["flamenco", "acoustic guitar", "picado", "free stroke", "instrumental", "compilation", "percussion", "exotic", "sensual"] | 9 | EptdhC17avY | 1593 | |
Faraon - Flamenco Rumba_20/11/2011@Barceloan | This is a recording of two flamenco guitarists playing a captivating latin american rhythm. It's upbeat and suitable for dancing. The one guitarist strums chords in the percussive flamenco style, while the other guitarist plays flamenco lead with arpeggios and licks. The performance is live and outside. There is reverb applied to the lead guitar. Both are playing on nylon strings. | 2011-11-24T17:50:51Z | Julian Kan | Spanish Guitar - Adrian Roman & Martin Sazandeh's performance at Cathedral, Gothic Quarter, Barcelona | ["Folk music", "Flamenco", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["live performance", "flamenco guitarists", "acoustic guitar", "nylon string guitar", "latin american music", "upbeat", "energetic", "dance", "reverb"] | 3 | KChjW89XOF0 | 2064 | |
Flamenco Guitar Barcelona | The low quality recording features a live performance of flamenco guitar and acoustic guitar chord progressions. Towards the end of the loop, there are some percussive guitar taps. The recording is noisy as it was recorded outside. | 2007-05-27T15:37:31Z | hendu2006 | Pair of flamenco guitarists outside Barcelona Cathedral in the Gothic Quarter, Friday, May 25, 2007 | ["Flamenco", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["low quality", "mono", "noisy", "acoustic rhythm guitar chords progression", "flamenco guitar chord progression", "guitar tap percussion"] | 4 | t-CjLfu9zCk | 4994 | |
Flamenco Guitar Farruca | This is a flamenco music piece. The only instrument being played is an acoustic guitar. The acoustic guitar is playing exotic tunes. There is a sensual atmosphere. This piece could be used in the soundtrack of a romance movie, especially during the more intimate scenes. | 2010-11-24T21:03:32Z | Mundo Flamenco | Amir John Haddad played this "Farruca" in october 2010, during a recording session for the Website of Mundo Flamenco. He plays a Andrés Daniel Marvi rosewood/spruce guitar from 2010. | ["Flamenco", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument", "Music of Latin America"] | ["flamenco", "no singer", "instrumental", "single instrument", "acoustic guitar", "exotic", "sensual", "romantic"] | 9 | S2yXmXUJ5xU | 2736 | |
Flamenco guitar - Livio Gianola - Sicomoro | Solo nylon string acoustic guitar played fingerstyle in a flamenco tradition. The guitar has lower bass notes than a regular 6 string guitar. | 2010-02-17T13:39:12Z | Veojam | Livio Ganola plays his tarantas "Sicomoro" on eight strings flamenco guitar. Check https://www.veojam.com/spanish_flamenco for more flamenco guitar videos | ["Flamenco", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["solo guitar", "nylon string acoustic guitar", "fingerstyle", "flamenco", "low bass notes", "extended range guitar", "free time"] | 8 | n3EeS2mVU5w | 4514 | |
Flamenco guitar and dance | A fiery, passionate flamenco duet between a nylon string guitar player and a clapping dancer. The guitar playing is virtuosic, employing flamenco strumming and fast scales. The rhythms are complex and additive. | 2006-05-24T23:46:57Z | AIRE Artists Agency | Fantastic flamenco piece - Tangos Rompeserones by Moraito - covered by Przemyslaw Haluszczak. Video presents the polish flamenco guitarists from Poznan accompanied with a drummer (palmas) + a female flamenco dancer. | ["Flamenco", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["flamenco", "duet", "spanish guitar", "classical guitar", "nylon string guitar", "hand claps", "virtuosic", "fast scales", "flamenco strumming", "additive rhythm", "complex rhythm", "fiery", "passionate"] | 8 | IwqD859w2_E | 1955 | |
Flamenco guitar lesson - Triplet rasgueado | This is an instructive flamenco guitar piece. The player is depicting how the piece must be played by starting it slow and eventually getting faster. The theme is repeated by the player. | 2006-09-07T16:33:45Z | Sal Bonavita | Flamenco guitar lesson - Triplet rasgueado This triplet (abanico) style rasgueado is one the most effective but easiest to learn. This video shows the triplet rasgueado at various speeds - Very slow (practice speed) to very fast (playing speed). it also shows a continuous rasgueado gradually building up speed and then slowing down to very slow again. Visit my website and for a more detailed description on how to play triplet rasgueado - using just the thumb (P) and middle finger (m) http://nylonguitarist.com/triplet_rasgueado_p_m_p.html Don't forget to leave something in the tip jar. ______________________________ ..// Show your SUPPORT HERE http://nylonguitarist.com/donate.html Everything I have to share is FREE for everybody. My inner voice tells me not to do the Patreon thing or start a membership. If you want something... just ask. But I will not refuse a donation if you can afford it. Enjoy your stay. ...// //WATCH NEXT: Annie's song - https://youtu.be/Y34oRHDt4_M Feelings - https://youtu.be/eE_suKEwJn4 Yesterday - https://youtu.be/rRmZgVMlskU Classical Gas - https://youtu.be/zOzVNC14b8Y The Godfather - flamenco stylehttps://youtu.be/ZsQYYiWT6Ms Take Five - https://youtu.be/4qRhbGJB6gQ La Playa - https://youtu.be/ejBnFm1msPk //KEYWORD RESEARCH TOOL (Tubebuddy) https://www.tubebuddy.com/hersoveela //CAMERA AND AUDIO GEAR I USE: - My video camera - https://amzn.to/3ptTVfD - My audio recorder - https://amzn.to/3ov876O - My microphone - https://amzn.to/2YspSsQ DISCLAIMER: Links in this description may be affiliate links. If you buy a product from these links I may receive a small commission. There is no extra charge to you. Thank you for supporting my channel. | ["Flamenco", "Acoustic guitar", "Music", "Strum", "Plucked string instrument"] | ["flamenco", "acoustic guitar", "instrumental", "exercise", "rising", "repeating theme", "spanish"] | 9 | r43WrKA6ppI | 4846 | |
Fred Stitz Plays Dobro Lap Steel part .1 open D tuning | This is an intricate country guitar performance. The guitarist plays slide guitar. The playing is complex. There is a tambourine as a percussive element on every beat. It's a live recording. | 2012-05-06T12:03:29Z | James Quinn | Fred came over to Dublin for 1 nite Razorlight gig got pulled so we hung out did a busk and made 2V ids Fred playing Dorbo lapsteel with bottle slide in open D Tuning enjoy filmed by Wascana | ["Flamenco", "Guitar", "Music", "Musical instrument", "Steel guitar, slide guitar", "Strum", "Plucked string instrument"] | ["country", "country guitar", "acoustic guitar", "slide guitar", "acoustic guitar arpeggio", "tambourine", "live recording", "intricate guitar playing"] | 3 | rfa-iUp5UQc | 4892 | |
Guajira - flamenco | The low quality recording features a live performance that consists of an acoustic flamenco guitar melody. The recording is very noisy and buzzy, but you can still hear the passion and the emotion. | 2009-02-25T06:27:26Z | khusroks | Performed and choreographed by Behnaz Khusrokhan. | ["Flamenco", "Guitar", "Acoustic guitar", "Music", "Ukulele", "Plucked string instrument"] | ["low quality", "buzzy", "noisy", "acoustic flamenco guitar melody", "passionate", "emotional", "live performance"] | 4 | hgitRq_0410 | 4126 | |
Hotel California -Guitar Harmonica solo | This is an acoustic cover of a rock music piece. There is an acoustic guitar playing a gentle melody. The piece has a slow tempo. The atmosphere is sentimental. This piece can be included in the soundtrack of a romantic movie. | 2014-08-22T20:06:06Z | Todd Emrick | I do not make money off this song or Youtube. UMPG owns the publishing rights. Please do not take this video down. "Hotel California" is the title track from the Eagles' album of the same name and was released as a single in February 1977.[6] Writing credits for the song are shared by Don Felder (music), Don Henley, and Glenn Frey (lyrics). The Eagles' original recording of the song features Henley singing the lead vocals and concludes with an extended section of electric guitar interplay between Felder and Joe Walsh. | ["Flamenco", "Acoustic guitar", "Music", "Plucked string instrument"] | ["cover", "acoustic", "rock music", "acoustic guitar", "gentle playing", "slow tempo", "mellow", "easygoing", "sentimental"] | 9 | hbCaMcbT8to | 4120 | |
How to Play the Guitar Tremolo Classical & Flamenco Style | An acoustic guitar being played walking down the fretboard using a tremolo finger picking technique. This song may be playing at home practicing guitar. This is an amateur recording. | 2012-11-02T22:27:52Z | Play & Sing With Alexandros | Hey guys! :} Well here ~it~ is! :D The Video that hundreds of you have requested from me. ;) Tremolo Guitar and how to Practice, Play ~it~ AND Develop ~it~ with some extra Exercises to further develop your Technique! Stay 'tuned' for MORE & MORE Guitar Videos by Subscribing to my Channel: http://www.youtube.com/giveorlooseit Thank you for watching my Guitar Friend! See ~you~ on the next Video! God Bless~ ----------------------------------------------------------------- If you like to help & Support me Please consider Donating ANY amount to Paypal here: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=YHKP93QNB87LN&source=url ~~Thank YOU MY GUITAR FRIEND~~ * PS: Want to learn this AND many more Picking Styles & Sing HUNDREDS of Songs??? Have NO fear! My E-Book is here: 25 Fingerstyle Techniques & Over 10 Styles of Music + 50 MP3's: http://store.payloadz.com/go?id=766057 (Paypal SAFE & 40% OFF!!) * Life is Music & Music is Life.. Without Music there can be no Life! God Bless~ * #GiveOrLooseIt #Guitar_Tremolo_Lesson #Classical_Guitar_Techniques | ["Flamenco", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["acoustic guitar", "tremolo", "amateur recording", "uptempo"] | 6 | X_nfMNpw9SA | 3197 | |
How to Practice Flamenco Scales | Flamenco Guitar | This is a clip of a tutorial where we have a male teacher playing a minor scale on a nylon string guitar. The energy of the video is calm. | 2013-07-15T03:45:07Z | Howcast | Full Playlist: https://www.youtube.com/playlist?list=PLLALQuK1NDrjihYqVBYe63py71wnGVUNi - - Like these Guitar Lessons !!! Check out the official app http://apple.co/1IFMYeJ Must Haves for any Guitar Player: On Stage XCG4 Black Tripod Guitar Stand: http://amzn.to/1KHP6HO Dunlop Trigger Curved Guitar Capo: http://amzn.to/1UrBL7c Korg GA1 Guitar and Bass Tuner: http://amzn.to/1Nafqfs Dunlop Standard Tortex Picks: http://amzn.to/1L4YMYy Ernie Ball 4037 Black Polypro Strap: http://amzn.to/1O8zLiu Watch more How to Play Flamenco Guitar videos: http://www.howcast.com/videos/510747-How-to-Practice-Flamenco-Scales-Flamenco-Guitar Okay, so I'm going to show you a good method to practice your scales and to get better and a little faster when you practice scales. It's very important that you practice with a metronome. Like I said in the previous video, if you don't have a metronome on, you're probably not practicing. So let's put our metronome on and we're going to pick a scale, whatever scale we're working on. For right now I'm just going to choose, just the regular E Minor scale. Fingering and I'm going to start with my root on the fifth string. Okay, and then we're going to do one, two, four; one, two, four; move to the fifth fret, one three four; one three four. Okay, so that's my E natural minor scale and I'm going to put my metronome to do this slow. I'm going to put it on 70 bpm, 70 beats per minute. This is a good way to practice your scales. First we're going to go up and down, just playing quarter notes and you'll go down the same way. I't's important when you practice scales that you know how to subdivide the beat accurately. So the next time we go up and down, we're going to do eighth notes, so we're going to divide the beat in half. Okay, and we're going to do that a couple of times. Next time we play our scale we're going to do triplets, which means we're going to fit three notes in the beat. It's important that we sing this or we feel this, before we even attempt to play it. So it's going to b… | ["Flamenco", "Guitar", "Acoustic guitar", "Music", "Mandolin", "Musical instrument", "Strum", "Speech", "Plucked string instrument"] | ["minor scale", "acoustic guitar arpeggio", "nylon string guitar", "male speaking", "male guide", "tutorial"] | 3 | HQ9HlWProm0 | 1799 | |
Nancy 🇮🇳 Rumba 🇮🇳 (Juan Serrano) | The song is an instrumental. The tempo is medium with a guitarist playing traditional flamenco style guitar in a rhumba rhythm. The song has a Latin dance groove and sounds delightful. The song has a poor audio quality. | 2015-07-07T18:32:38Z | Aman (Flamenco Guitarist) | Nancy (Rumba Flamenca) composed by Juan Serrano played by me on YAMAHA CG172SF Flamenco guitar. | ["Country", "Flamenco", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["rhumba music", "latin guitar player", "instrumental music", "medium tempo", "emotional", "romantic", "erotic", "madly in love", "couples dancing", "tango", "guitar lead", "guitar strumming", "music lesson ideo", "poor audio quality", "latin dance music", "groovy music", "solo instrumental", "groovy music", "dance rhythm", "flamenco guitar style"] | 1 | w4Z1QuBOMWU | 5236 | |
Paco de Lucia plays an Erez Perelman Flamenco Guitar Part 1 | This is an instrument review jam that is played in the style of flamenco music. There is an acoustic guitar being played while a male voice gives his opinion concerning the instrument. The character of the sound is sensual. The guitar sounds can be sampled for use in beat-making. | 2011-11-22T11:13:27Z | Erez Perelman | Order Your Handmade Classical or Flamenco Guitar Here: http://erez-perelman.com/contact/ Paco de Lucias playing Erez Perelman flamenco guitar. | ["Bass guitar", "Flamenco", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Speech", "Plucked string instrument"] | ["jam", "flamenco", "acoustic guitar", "male voice", "review", "exotic", "sensual"] | 9 | axqtExFY5-s | 3590 | |
Top 15 Acoustic Guitar Players | This music is an acoustic guitar instrumental. The tempo is medium with the guitarist playing a dulcet harmony on an acoustic guitar. The music is calming,soothing, melodic, eloquent, moving and emotional. | 2009-03-21T20:21:51Z | alexguitarmusic | Here is my list of the top 15 acoustic guitar players 15. Petteri Sariola 14. Kotaro Oshio 13. Justin King 12. Erik Mongrain 11. Kaki King 10. Peppino D'Agostino 9. Antoine Dufour 8. Andy Mckee 7. Stephen Bennett 6. Steven King 5. Don Ross 4. Chet Atkins 3. Lenny Breau 2. Tommy Emmanuel 1. Michael Hedges I would be interested to see what other people would consider their top 15 acoustic guitar players... add your list to the comments section, or maybe make a video response! | ["Flamenco", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["instrumental", "medium tempo", "mellifluous", "calming", "soothing", "melodic", "eloquent", "moving", "emotional", "plucking", "dexterous", "mellow", "soothing", "calming"] | 7 | XS-3djsJWTA | 3185 |
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;