musiccaps_details (view)
1 row where musiccaps_aspects contains "hard rock", musiccaps_aspects contains "medium tempo", musiccaps_aspects contains "rich" and musiccaps_author = 7
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Fast Legato Rock Technique #1 (Guitar Lesson) How to play | This music is instrumental. The tempo is medium with an electric guitar riff and the voice of a man giving instructions on electric guitar techniques. The music is loud, clear, amplified, vivid, emphatic and powerful. This is a tutorial/ lesson on electric guitar techniques. | 2007-02-02T14:51:50Z | JustinGuitar | In this lesson on Fast Legato Rock Technique #1, we will learn how to develop your speed technique with this series of development exercises starting here with learning the Major Scale with 3 notes on each string. Get this down really well before moving onto part 2. Find the related course notes on the following link: http://justinguitar.com/en/RO-011-Legato1.php Please SUBSCRIBE ►http://bit.ly/jgtr-sub ♥️ Your Support Appreciated! See JustinGuitar.com for over 1500 completely free lessons - not random stuff like you find on YouTube, but well structured courses so you can see your progress. Register on the site (still free) get PDF downloads for many lesson, your own dashboard to keep track of your practice, get help with lessons and make requests. It's nearly all 100% free and card details are not needed to register. You have everything to gain, and nothing to lose! My theory course is the best on the web (and one of the very few paid parts of the site) and it's awesome - if your theory is lacking and you wanna fix it - that's the place to go! At my store, you'll find a huge range of super cool guitar themed t-shirts, all my (paper) books, merch and lots more 🙂 and we got proper fun backing tracks for you to jam along with too! • Website https://www.justinguitar.com • Theory Course http://bit.ly/jgtr-theory • JustinGuitar Beginner Song App https://go.onelink.me/3065804798/jgtryt • Exclusive Guitar T-Shirts: https://bit.ly/jgtr-tees • Jam Tracks http://bit.ly/jgtr-jams • Instagram http://bit.ly/jgtr-instagram • Facebook http://bit.ly/jgtr-facebook • Twitter http://bit.ly/jgtr-twitter • Forum http://bit.ly/jgtr-community • Workshops http://bit.ly/jgtr-workshops • -~-~~-~~~-~~-~- Please watch: "The Justin Guitar Beginner Song Course by FourChords for iOS & Android JustinGuitar Easy Guitar Song" https://www.youtube.com/watch?v=0I2F8CDpqWU -~-~~-~~~-~~-~- | ["Tapping (guitar technique)", "Guitar", "Music", "Musical instrument", "Speech", "Plucked string instrument"] | ["instrumental", "medium tempo", "male voice speaking", "demonstration", "electric guitar", "stringed instrument", "amplified instrument", "loud", "clear", "rich", "deep", "rock", "hard rock", "metal", "heavy metal", "pop", "powerful", "emphatic", "intense", "electric guitar lesson", "electric guitar tutorial", "learning electric guitar", "electric guitar techniques", "vibrations"] | 7 | 4ls_8xIjBzM | 604 |
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;