musiccaps_details (view)

1 row where musiccaps_aspects contains "wide mellow high pitched synth pad", musiccaps_author = 4, musiccaps_names contains "Ambient music" 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
梁靜茹[情歌沒有告訴你] 完整官方 HQ MV The Rock song features a wide, mellow, high pitched synth pad swelling into the drop that consists of punchy drums, smooth electric and bass guitars. Right before the "drop", there is a short toms roll. It sounds calming and relaxing, at least until the bass drops. 2010-11-30T09:08:12Z UNIVERSAL MUSIC TAIWAN 環球音樂 情歌的不傳之秘 情歌沒有告訴你的 梁靜茹告訴你 梁靜茹《情歌沒有告訴你》 2010全新專輯 華麗回歸 情歌的不敗天后梁靜茹， 在千呼萬喚之下 即將在2010年底推出籌備一年半的全新國語專輯《情歌沒有告訴你》 12/3 預購 12/24發行 巧妙地從梁靜茹亦師亦父的音樂教父李宗盛經典《夢醒時份》開始， 一方面唱出她與「大哥」李宗盛的淵源（被「大哥」發掘，隻身從鄉村小鎮飛到異鄉台北追尋夢想）， 也唱出每個人聽到喜歡的情歌的微妙心裡反應（「許多細節已湮沒 還記得那副歌」「 聽著那熟悉前奏／回憶逆流成河 淹沒你我」），唱出情歌對華人的特殊意義（「情話被現實反駁 還不如一句情歌／安慰了寂寞 也餵養寂寞」），最後在撫慰之餘不忘提醒，愛與被愛都需要行動力： 「情歌沒有告訴你我／只唱勇氣沒勇氣還是沒結果」！ 在KTV唱梁靜茹只是一個開始，2010我們的情感有了新的動力！ ["Music", "Ambient music"] ["rock", "wide mellow high pitched synth pad", "relaxing", "calming", "toms roll", "intro", "punchy drums", "smooth electric guitar", "smooth bass guitar"] 4 C8Euv69GR3U 1335

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;