musiccaps_details (view)

1 row where musiccaps_aspects contains "fearful", musiccaps_aspects contains "steel pan" and musiccaps_names contains "Music"

✎ 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
12CH Super Fighter BlitzRCWorks | Flight Review (feat. John Asher) | EDF Fighter Jet This music is instrumental. The tempo is fast with atmospheric synthesiser, percussions like a boomy bass drum, enthusiastic steel pan and snare. The music is loud, resounding,intense, sinister, grim, suspenseful, burgeoning and boomy. This is a Percussion Instrumental. 2011-05-01T01:25:59Z Banana Hobby Order now at: http://www.bananahobby.com/12-ch-blitzrcworks-super-fighter-rc-edf-jet-arf.html Hey pilots! I am so excited to bring to you this flight review! Before we get started, I just want to say how disappointed I am to not be able to give you all more flying and more aggressive flying. You all know me for never holding back when it comes to wringing out an aircraft for a review! The winds on this day of the review were so strong, the F18 actually was blown upside down on the runway breaking many parts including the canopy mechanism. From that I did some quick repair and gave you guys and gals the best flying I could do with 30 plus knots of turbulent cross winds. No one was flying, but yours truly flew this for you. Keep an eye out for Part II coming real soon! I love this FA/18 and I can't wait to bring to you the next review! ~ Pete ["Timpani", "Music"] ["instrumental", "intense", "vigorous drumming", "percussion instrumental", "steel pan", "snare", "resounding", "rhythmic percussion", "snare", "minimalist", "boomy bass drum", "steel pan", "synthesiser arrangements", "sinister", "anticipation of danger", "scary", "fearful", "loud", "powerful"] 7 3w4nFQrUQ8k 522

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;