musiccaps_details (view)

1 row where musiccaps_aspects contains "guitar solo", musiccaps_aspects contains "medium tempo", musiccaps_names contains "Camera" 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
【華燈市】市政店精品吊扇展示中心 The song is an instrumental. The song is medium tempo with a guitar playing solo, steady drum rhythm, groovy bass line and steady bass line. The song is funky and groovy in nature. The song is an ad jingle. 2015-05-18T10:07:19Z 華燈市燈飾 吊扇 光源 設計 官網－https://www.waldens-lighting.com/ 免費到府勘查－ https://www.waldens-lighting.com/cont... 華燈市提供您全省安裝服務，自有工班提供您專業的燈具安裝、吊扇安裝、照明燈具、安裝維修、五星級安裝，產品有保固，購買燈具有保障，一年保固終身保修 ------------------------------------------------------------------------------------------------------------------------------------------------------------------ 華燈市為全國最大的精品吊扇展示中心，吊扇種類最多，針對不同的需求，提供您最佳的吊扇 選擇，從 #Fanaway、 #Fanscool、 #ModernFan、到 #Vento…，無論是國際精品品牌，或者是台灣之光，您都可以透過店內實品展示的體驗，實際感受及體驗這些精品吊扇的魅力 #燈的事就交給華燈市 #全省安裝 #精品吊扇 ["Music", "Camera"] ["instrumental music", "cash register click", "passionate", "spirited", "exciting", "medium tempo", "groovy rhythm", "romantic", "energetic", "youthful", "jazz music influences", "dreamy", "enterprising", "guitar solo", "groovy bass line", "steady drumming rhythm", "ad jingle", "soundtrack", "funk jazz music", "shakers percussions", "groovy", "soul music", "medium tempo"] 1 D2w3qHmJrdU 1429

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;