musiccaps_details (view)
12 rows where search matches "guitar", musiccaps_aspects contains "instrumental" and musiccaps_names contains "Flamenco" sorted by youtube_published
This data as json, CSV (advanced)
Suggested facets: musiccaps_names
musiccaps_aspects (array) 90 ✖
- instrumental · 12 ✖
- acoustic guitar 8
- no singer 5
- flamenco 4
- easygoing 3
- mandolin 3
- exotic 2
- mellow 2
- no percussion 2
- sensual 2
- single instrument 2
- acoustic 1
- acoustic guitar accompaniment 1
- adventurous 1
- aggressive guitar playing 1
- banjo 1
- bass guitar 1
- bluegrass 1
- blues rock 1
- busking 1
- calming 1
- captivating 1
- cello 1
- clean sound 1
- compilation 1
- dexterity 1
- dexterous 1
- eccentric 1
- electric guitar 1
- eloquent 1
- emotional 1
- energetic 1
- exercise 1
- extremely rapid guitar rhythm 1
- fast tempo 1
- fingerstyle guitar 1
- folk dance 1
- free stroke 1
- fun 1
- groovy 1
- guitar solo 1
- guitar song 1
- inferior quality audio 1
- italian folk music 1
- joyful 1
- lively 1
- medium tempo 1
- mellifluous 1
- melodic 1
- minimal instruments 1
- minimalist 1
- moderate tempo 1
- movie music 1
- moving 1
- muffled audio 1
- napoletana 1
- no other instruments 1
- no voice 1
- no voices 1
- orchestra 1
- palm muting 1
- pastoral 1
- people talking in background 1
- percussion 1
- picado 1
- playful 1
- plucking 1
- repeating theme 1
- resonator guitar 1
- rhythmic guitar 1
- rising 1
- rock music 1
- romantic 1
- romantic mood 1
- rural 1
- serene 1
- simple melody 1
- slow tempo 1
- soft 1
- soothing 1
- spanish 1
- spanish guitar 1
- spirited 1
- tarantella 1
- ukulele 1
- uplifting 1
- video game music 1
- vigorous 1
- western music 1
- whistling 1
musiccaps_names (array) 19 ✖
- Flamenco · 12 ✖
- Music 11
- Acoustic guitar 7
- Guitar 6
- Musical instrument 6
- Plucked string instrument 6
- Strum 5
- Music of Latin America 2
- Banjo 1
- Bass guitar 1
- Bluegrass 1
- Blues 1
- Folk music 1
- Gospel music 1
- Mandolin 1
- Music of Bollywood 1
- Rock and roll 1
- Rock music 1
- Salsa music 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
Extreme Speed Guitar Solo - Flamenco - Paco de Lucia, picado.! | This song is an instrumental. The tempo is fast and vigorous, with the musician playing a very rapid harmony on the Spanish guitar with an acoustic guitar accompaniment; the song is energetic, vibrant, enthusiastic, and shows a lot of dexterity with the instrument. This song is an instrumental Pop rock song. | 2010-05-16T08:26:49Z | Pavel Čížek | Zde je sestřih zatim vybraných, z různých záběrů, extremě nejrychlejších kytarových sól stylu španělského Flamenca od Paca de Lucii. Jak je možno pozorovat, tento styl patří pro akustickou kytaru mezi nejtvrdší a nejtěžší styly vůbec,!!! a zároveň tím silně konkurujícím stylům elektrycké kytary - Rock-Metalu a jim podobným stylům. Pohleď te na prsty pravé ruky, s pomocí dobře upravených nehtů s posilněným zpevńujícím lakem,(technika picado) v této rychlosti, se zvuk připodobńuje, jako rychlý datlový nebo-li tremolový ťukavý efekt, oproti trsátku se to napodobit nedá.!! | ["Bass guitar", "Flamenco", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum"] | ["instrumental", "spanish guitar", "energetic", "vigorous", "spirited", "rhythmic guitar", "extremely rapid guitar rhythm", "dexterity", "acoustic guitar accompaniment", "muffled audio", "inferior quality audio"] | 7 | 15Mw2jyyHk0 | 235 | |
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 | |
cowboy music-instrumental | This is a Western music piece performed live by an orchestra. There is a mandolin playing the main melody. Many strummed instruments such as acoustic guitar and ukulele are being played in the melodic background. These sounds evoke an adventurous feeling This piece could be used in the soundtrack of a Western movie/TV series. It could also suit well in the soundtrack of a wild west themed video game like Red Dead Redemption. | 2011-07-30T10:27:10Z | shashirao20072001 | cowboy music-instrumental | ["Flamenco", "Music", "Salsa music"] | ["western music", "no singer", "instrumental", "orchestra", "mandolin", "ukulele", "acoustic guitar", "bass guitar", "adventurous", "eccentric", "movie music", "video game music"] | 9 | w9CxACZ5Oi0 | 5244 | |
ROZBĚH BLUEGRASS MUSIC | This is a bluegrass music piece. There is a mandolin playing the main tune as the lead while a banjo and an acoustic guitar are supporting it in the melodic background. There is a joyful feeling to this piece. It could be used in the soundtrack of a movie or a TV show with a rural setting. It could also be used in the background of pastoral social media content. | 2011-08-25T14:41:30Z | honzabaseman | 00. Úvod 01. MATTERHORN 02. PLEASE SEARCH A HEART 03. FOX ON THE RUN 04. HROU ZÍSKÁŠ HROW 05. SALT CREEK 06. ZÁTOKA 07. NOČNÍ VLAK 08. ZLATÁ RYBKA 09. BLACK DIAMOND 10. PÁDÍ MISSISSIPPI 11. FOGGY MOUNTAIN BREAKDAUN 12. KAROLÍNA 13. SVÍCEN ZMIZEL V TMÁCH 14. ARKANSAS TRAVELLER 15. PÝCHA PŘEDCHÁZÍ PÁD 16. PŘÍSAHEJ 17. SAIL TO AUSTRALIA | ["Gospel music", "Folk music", "Flamenco", "Music", "Music of Bollywood", "Music of Latin America", "Bluegrass"] | ["bluegrass", "no singer", "instrumental", "banjo", "mandolin", "acoustic guitar", "playful", "joyful", "uplifting", "easygoing", "rural", "pastoral"] | 9 | 0-7PyzhzuYQ | 108 | |
Love Acoustic Guitar ! Great Blues rock and roll ! Happy Music. Yannick Lebossé.Je pousse un cri. | This blues instrumental rock song features an acoustic guitar being aggressively strummed. There are no other instruments in this song. There are no voices in this song. The tempo of this song is fast. The rhythm of this song comprises fast upstrokes and downstrokes. Some of the strums are muted and the main rhythm is played with a mix of open and palm muted techniques. | 2011-10-04T14:47:11Z | Je Pousse Un Cri | Love Acoustic Guitar ! Great Blues rock and roll ! Happy Music. Yannick Lebossé.Je pousse un cri. #guitar #blues #acoustic You can find another great blues guitar video here http://www.youtube.com/watch?v=2_oXgPnaZOs Blues is related to roots such as African-American in the south of USA from the 19th century .We Love the blues or jazz, rhythm blues, rock and roll with guitar and, heavy metal music, hip hop music, reggae, country music, and pop music, We Like also Dan Aykroyd John Belushi The Blues Brothers. The Ray Charles, James Brown, Cab Calloway, Aretha Franklin, John Lee Hooker. B.B. King, Bo Diddley, Erykah Badu, Eric Clapton, Steve Winwood, Charlie Musselwhite, Blues Traveller, Jimmy Vaughn, Jeff Baxter. Visit our Channel for tutorials and More Guitar videos! http://www.youtube.com/Jepousseuncri Please Subscribe if you want to watch more music videos ! More Youtube Guitar Videos: Spanish Guitar and Blues with Yannick Lebossé https://youtu.be/oTXa6FFnPI0 https://youtu.be/KC3hJFvQv3A https://youtu.be/2_oXgPnaZOs https://youtu.be/kXo8Y6qz6QA https://youtu.be/TFJPThBuLks https://youtu.be/57JtLg098Go https://youtu.be/AJw-x30L46E https://youtu.be/QsSq6hgB1XQ https://youtu.be/6VkzfVRSS24 https://youtu.be/iJM6sOhjC0g https://youtu.be/jWBc6eLHF0o https://youtu.be/tyrfXzZ-KG4 https://youtu.be/kGbgVy4BhyE https://youtu.be/U1D_q-GjFUE https://youtu.be/thdR68WFyDk https://youtu.be/KF11JAqMUR4 https://youtu.be/ngYt1vos2RM https://youtu.be/3ZduJh_0GHU Irish Music Ghillies https://www.youtube.com/watch?v=JZoYGaKR8Qg https://www.youtube.com/watch?v=tEJQuwHm88I https://www.youtube.com/watch?v=JVh3T2CYNv4 http://ghillies.wixsite.com/ghillies Gueule de loup https://www.youtube.com/watch?v=Ga1zaiZ3Q-U https://www.youtube.com/watch?v=AMwfa4wyRUw https://www.youtube.com/watch?v=mJ9LhiGgeR8 https://www.youtube.com/watch?v=wfQ3c70jWPc https://www.youtube.com/watch?v=s66MBQrce3k Les Compagnons du gras jambon . https://www.youtube.com/watch?v=mZCw75PhgIc https://www.youtube.com/watch?v=mi5GmLLxWoA Luc Arbogast https:… | ["Blues", "Flamenco", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Rock music", "Rock and roll"] | ["blues rock", "fast tempo", "acoustic guitar", "no voice", "instrumental", "no percussion", "minimal instruments", "aggressive guitar playing", "palm muting"] | 0 | AJw-x30L46E | 1105 | |
Tarantella Napoletana - Italian Mandolin music by Antonio Calsolaro | This is an Italian folk music piece. It is a live performance recording. There is a mandolin playing the main tune of the piece while an acoustic guitar plays in the melodic background. The atmosphere of the piece is lively. This piece could be used in the soundtrack of a documentary taking place in the Mediterranean region. It could also be used in tourism agency advertisements. Another possible use is as an accompaniment piece for Italian folk dance courses. | 2012-12-02T08:29:31Z | Christian L. Caballero (235binelli) | Tarantella Napoletana, (Italian tarantella by Napoli) played by the Italian mandolin Maestro ANTONIO CALSOLARO and Francesco Polito (Guitar), traditional folk music of Napoli and Italian culture, the Mandolin music was introduce, during the 18th century, in the "Italian Barbers Saloon". The Maestro Calsolaro give us this dancing Tarantella music to his world friends, sponsored by http://www.italianbusinessguide.com/ ITALIAN MUSIC MAESTRO ANTONIO CALSOLARO - LESSONS AND LIVE CONCERT He's preparing a Mandolin Master Class in the "Culture Palace of Alessano Lecce - Italy" the final week of March 2013, it will be divided in beginners and experts mandolin lessons, a full week of Mandolin sharing experience. He will give His own exclusive "Traditional Italian Sheet Music" to each participant If you need more info please call in Italy +39.333.6371644 or Email to info@ital-usa.com Furthermore he's available for live music concerts, exhibitions, shows, Italian party around the world, please contact us for your requirements ITALIAN TARANTELLA - Tarantella Napoletana Tarantella music is a folk dance music characterized by a fast upbeat tempo, usually in 6/8 time (sometimes 18/8 or 4/4), accompanied by tambourines (tamburello) and mandolin. It is among the most recognized of traditional Italian music, it names change according to the varies Italian region, Tammuriata in Campania (Naples - Napoli), Pizzica Pizzica in Lecce - Salento region, Sonu a ballu in Calabria. Tarantella is popular in Southern Italy and one of the symbols of the Italian culture in the world. In the Salento's region of Italy the bite of a locally common type of spider called "tarantula" was popularly believed to be highly poisonous and to lead to a hysterical condition known as Tarantism. The stated belief in the 16th and 17th centuries were that the victims needed to engage in a frenzied dance to prevent death of the disease using very rhythmic music, this kind of music was known Tarantella. ITALIAN MANDOLIN Mandolins evolved from the lute family in… | ["Banjo", "Flamenco", "Acoustic guitar", "Music", "Mandolin"] | ["italian folk music", "tarantella", "napoletana", "no singer", "instrumental", "acoustic", "mandolin", "acoustic guitar", "folk dance", "easygoing", "fun", "lively"] | 9 | 5FlNBuS7YgM | 648 | |
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 | |
AMAZING Whistling Solos! Buskers perform On A Slow Boat to China in NYC Subway | This music is a pleasant instrumental. The music is slow tempo with a soft cello and guitar duet with a whistle melody. The song is mellow, soothing, calming , dulcet, warm and relaxing in contrast to the background noises of people talking and walking. The musicians are buskers. | 2016-04-08T15:02:24Z | Benjamin Lamson | I've been living in NYC for nearly a decade and these are two of the best buskers I've ever seen. Not only is this guys voice butter but they're both amazing whistlers! My only regret is that I started filming halfway through the song. Filmed at the Metropolitan Lorimer stop on the G train. UPDATE: Vilray recorded and released his first album. Download it at http://vilray.bandcamp.com/ Band's Info: http://patreon.com/vilray http://soundcloud.com/vilray http://www.facebook.com/Vilray-75001313101/ http://www.vilraysings.com http://www.instagram.com/vilray/ http://twitter.com/theactualvilray Jukin Media Verified (Original) * For licensing / permission to use: Contact - licensing(at)jukinmediadotcom | ["Flamenco", "Music"] | ["instrumental", "slow tempo", "cello", "whistling", "resonator guitar", "acoustic guitar", "simple melody", "people talking in background", "busking", "minimalist", "soft", "mellow", "captivating", "serene"] | 7 | rfQ94EXIpTc | 4891 |
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;