musiccaps_details (view)

3 rows where musiccaps_aspects contains "poor audio quality" and musiccaps_names contains "Piano"

✎ View and edit SQL

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
Kurzweil Artis vs Nord Stage vs Yamaha Motif XF8 vs Korg Kronos The song is an instrumental. The song is medium tempo with chord changes played on different keyboards to check subtle differences in tonality. The song track is a comparison video playing funk jazz accompaniment. 2014-01-09T20:53:42Z Hit Space Hangszer- és Stúdiótechnikai Szaküzlet Egy kis ízelítő pár népszerű billentyűs hangszerből. Mivel a hangszerek mindegyike rendelkezik valamiféle extrával a másikhoz képest, érdemes őket személyesen kipróbálni. A Hit Space-ben található Magyarország legszélesebb szintetizátor választéka, ahol minden érdeklődőt szeretettel látunk! ["Electric piano", "Keyboard (musical)", "Piano"] ["keyboard comparison video", "medium tempo", "jazz music", "groovy rhythm", "music store", "music demonstration", "home music video", "instrumental music", "funk jazz", "chord changes", "poor audio quality", "live performance", "groovy music", "exciting", "tonal differences", "keyboard accompaniment"] 1 M1ds6tRFxhs 2236
Keyboard: Booker T. Jones - "Hang'em High" The song is an instrumental. The song is slow tempo with an organist playing a tune on a church organ and sounds of switches being turned on and off. The song is emotional and sounds devotional in nature. The audio quality is poor with ambient room sounds. 2009-04-09T19:38:11Z MusicPlayerNetwork To see the rest of the interview, head over to http://www.keyboardmag.tv ["Organ", "Hammond organ", "Keyboard (musical)", "Piano"] ["organist", "church organ", "organ legends", "old school players", "legendary musicians", "passionate", "spiritual", "switch sounds", "slow tempo", "instrumental music", "key sounds", "ambient room sounds", "keyboard", "emotional", "devotional music", "documentary", "poor audio quality"] 1 d9r_kYpOvW8 3766
The Legend Of Zelda - MEDLEY - Piano and Violin cover The song is an instrumental. The song is medium tempo with a violin playing a solo with a piano accompaniment. The song is emotional and positive. The song is a classic western hit and has poor audio quality in general. 2010-07-23T16:32:17Z Furyxx Violin ZELDA MEDLEY on Piano and violin ! Hey guys ! Thx you everybody for your support ! Don't forget to share and suscribe if you liked it :) Here is our new video after a long time !! (this time it's the real one !) Music from Zelda, koji Kondo Enjoy! ;) ps: We know that we need a little hair cut :p ["Music", "Musical instrument", "Piano", "Violin, fiddle", "Classical music"] ["piano accompaniment", "violin solo", "instrumental music", "music rehearsal", "classical duet", "medium tempo", "western classical music", "studio chamber echo", "instrumental music", "memdium tempo", "emotional", "dance groove", "cheerful", "spirited", "nostalgia", "good day", "poor audio quality", "home video quality", "entertaining", "classical dance", "composers"] 1 hkWcUtga1lw 4135

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;