musiccaps_details (view)
1 row where musiccaps_names contains "Guitar" and "youtube_published" is on date 2012-02-14
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| W. A. Mozart - Rondo alla Turca (Turkish March), solo classical guitar | This audio contains someone playing a classical melody on an acoustic guitar using fingerstyle. This audio is full of reverb. This song may be playing at a talent show. | 2012-02-14T18:40:10Z | Los Angeles Guitar Academy | In Mozart's time, the Ottoman Empire still ruled Turkey (Anatolia). Their military bands, called Janissary bands, were quite popular, even in Europe. Mozart borrowed from their sound and rhythm to produce this work, which became one of the big hits of Mozart's day. Its popularity has rarely waned since then. The final movement of the sonata, Rondo Alla Turca, captures the military bands' brassy sound. In its whirling feel, it can evoke another aspect of Turkish culture which has captivated Westerners--the whirling motion of the Sufi dervishes as they perform their ancient ritual of peace and wholeness, though the Rondo whirls at light speed, in contrast to the gentle movement of the Mevlevi. Arranged and performed by Emre Sabuncuoglu. Copyright © 2012 Los Angeles Guitar Academy Publishing. All rights reserved. 𝄞 Purchase sheet music and tabs: https://onlineguitaracademy.net/classical-guitar-sheet-music 🔔 Subscribe for more great pieces and tutorials: https://www.youtube.com/user/LAGuitarAcademy?sub_confirmation=1 🐢 Slow walkthrough videos available on our online lesson program: https://onlineguitaracademy.net/online-classical-guitar-lessons 🍀 Free trial for online programs: https://onlineguitaracademy.net/register/laga-free-trial https://onlineguitaracademy.net/pricing-comparison ❤️ Love our work? Join our Patreon community and access dozens of patron-only posts and exclusive releases: https://www.patreon.com/LAGuitarAcademy ❤️ Or join our channel: https://www.youtube.com/channel/UC3eQeaR786C8HCGFMqtCUSw/join Recommended videos: ✔️ Complete list of our Mozart arrangements: https://www.youtube.com/playlist?list=PL18tTu-0TnfqPbL8O1OFBXEWx5j1QAdkj ✔️ Spring (the Four Seasons) for solo guitar: https://www.youtube.com/watch?v=fENuHRAPEmA ✔️ Maple Leaf Rag by Scott Joplin on solo guitar: https://www.youtube.com/watch?v=xRjXafdabzc ✔️ Eine kleine Nachtmusik for solo guitar: https://www.youtube.com/watch?v=_fxyXLZ65gw | ["Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["amateur recording", "classical", "fingerstile acoustic guitar", "fast tempo"] | 6 | 26HLgXWF-Co | 332 |
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;