musiccaps_details (view)
1 row where musiccaps_names contains "Guitar" and "youtube_published" is on date 2010-05-03
This data as json, CSV (advanced)
| video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
|---|---|---|---|---|---|---|---|---|---|---|
| How to play acoustic guitar songs classic rock style with new rhythm patterns lesson super easy! | The low quality recording features a tutorial that contains a flat male vocal talking over acoustic guitar strummed chords. The recording is noisy and in mono. | 2010-05-03T19:03:13Z | rockongoodpeople | http://www.david-lessons.com/egi/beginner_strumming.html Click the link for a free video lesson where you will learn six critical tips to exceptional strumming. You will also learn five amazing strum patterns that can be utilized for countless songs and also receive a killer free eBook from Next Level Guitar. And check out our full on video instructional website at http://www.nextlevelguitar.com - its a full on structured curriculum for all level players and all styles of music - FREE 3-day all access site pass on the home - so check out the site and give it a good test drive - enjoy! Questions? - email us at thenextlevelguitar@yahoo.com Facebook - https://www.facebook.com/pages/Free-Guitar-Lessons-From-Next-Level-Guitar/162335850468702?fref=ts How to play acoustic guitar songs classic rock style with new rhythm patterns lesson super easy! - In this video we teach a very easy beginner chord progression in a classic rock style of many bands from that classic rock era. We also teach some new strum patterns broken down into easily digestible pieces. Its easy, fast and fun - with strum patterns and chord close ups. | ["Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Speech", "Plucked string instrument"] | ["low quality", "noisy", "mono", "flat male vocal", "acoustic guitar strummed chords", "tutorial"] | 4 | 8UhdwnsckJ8 | 922 |
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;