musiccaps_details (view)
1 row where musiccaps_author = 4, musiccaps_names contains "Music" and youtube_channel = "YourGuitarSage"
This data as json, CSV (advanced)
Suggested facets: musiccaps_aspects (array)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Guitar lesson Lonely Boy by the Black Keys showing chords, licks, riffs & tricks beginner | The low quality recording features a cover of an alternative/indie song that consists of acoustic guitar melody. It sounds groovy and the recording is in mono and noisy. | 2011-12-16T06:16:34Z | YourGuitarSage | Go to http://www.yourguitarsage.com/the-ultimate-guitar-guide-part-1/ to find out how to get a free guitar ebook that will help you play this song and 100s of other songs!!! This guitar lesson vid shows you how to play Lonely Boy by the Black Keys. It shows you the chords, strumming technique and style. Check out http://yourguitarsage.com/ for info on my online instructional resources about charts, chords, strumming and the techniques that I use here in my videos.. For more guitar lessons, see my other free tutorials. For original and cover music by me, Erich, go to http://www.myspace.com/erichandreas . Since I'm so busy making new video tutorial lessons all the time and teaching guitar, I probably won't have time to answer individual questions regarding guitar. Other videos cover beginner, advanced and intermediate levels. I teach rock, blues, country and just about any other style on electric or acoustic. If you can't find your answer from the resources at the website above, keep digging into my vids, and I'm sure you will find your answer. Keep practicing!!! Your $1 UGS membership trial is right here: http://www.yourguitarsage.com/1-dollar Of course you can follow me on Twitter!! http://twitter.com/yourguitarsage Like me on facebook -- http://www.facebook.com/pages/Your-Guitar-Sage/168919156461750 Get the YourGuitarSage AppRats app for your Facebook page and never miss another video! http://apps.facebook.com/yourguitarsage/ ...and for Twitter, too! http://twitter.apprats.com/YourGuitarSage | ["Music", "Steel guitar, slide guitar", "Plucked string instrument"] | ["low quality", "alternative/indie", "acoustic guitar melody", "noisy", "mono", "groovy", "cover"] | 4 | We9P_UcHNk8 | 3119 |
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;