musiccaps_details (view)

1 row where musiccaps_author = 6, musiccaps_names = "["Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"]" and musiccaps_names contains "Acoustic guitar"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: youtube_published (date), musiccaps_names (array), musiccaps_aspects (array)

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

CSV options: 

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;