musiccaps_details (view)
1 row where musiccaps_aspects contains "calming", musiccaps_aspects contains "smooth electric guitar" and "youtube_published" is on date 2010-11-30
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
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;