musiccaps_details (view)

1 row where musiccaps_aspects contains "heart break", musiccaps_aspects contains "pensive", musiccaps_aspects contains "sad" 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
戴愛玲Princess Ai 《This Is How a Heart Breaks》Official Music Video A female vocalist sings this melancholic melody in a foreign language.The tempo is slow with a romantic piano accompaniment. The song is soft, mellow, poignant, emotional,sentimental, romantic, melancholic , sad, lonely,and wistful. This song is a Pop/ Love song. 2015-08-31T14:00:00Z 戴愛玲 Princess Ai 以鋼琴開場的心碎，像是在心臟的哀傷悠悠地發出悲鳴；微弱的求救聲，在迴盪。戴愛玲用最細微的嗓音輕唱著心碎的聲音，像下雪的聲音，寧靜卻深深落在心底。歌曲以豐富的編曲層次烘托著愛玲的歌聲，從最小的聲量，到最高亢的吶喊，用獨特的音樂意識形態，呈現出心碎的意象，而名詞人姚若龍的歌詞，更是以充滿詩的文字，描繪出唯美而殘酷，浪漫而痛楚的愛戀心情。 這首是戴愛玲專輯裡最愛的一首歌，更難得的是這首歌的製作人是「對的人」、「千年之戀」的製作人Keith，也是錄音過程耗時最久的一首，當初在北京錄完後，回來台北，因為環境改變、空氣改變，聽了又覺得可以升key再重錄；而這首歌的合聲更是特別以美聲天籟的方式，營造出一種晶瑩剔透、天堂般的感覺，讓戴愛玲非常喜愛，沒有用太多的歌唱技巧，只是很直接的用歌聲表達出情緒，讓戴愛玲錄得很快，也因此錄了很多版本，讓她覺得錄得很過癮！ ●戴愛玲 Princess Ai 官方Facebook● https://www.facebook.com/sonyprincesstai ●戴愛玲 Princess Ai 官方微博● http://www.weibo.com/u/1781184057 線上購買 ◎iTunes https://goo.gl/Ok3AE1 ◎kkbox http://goo.gl/5JBwmp ◎Mymusic http://goo.gl/gXZUjT ◎Omusic http://goo.gl/FhVZTV ●更多活動詳情請上● Sony Music官方網站 http://www.sonymusic.com.tw/main Sony Music Taiwan CPOP-華語粉絲團 https://www.facebook.com/sonymusiccpop 作詞：姚若龍/李華章 作曲：李華章 First you say First you say I love you 我深信不疑 和世界對賭 苦也不肯服輸 加倍付出了全部 看愛的狂徒感動哭 自認選了對的路 This is how a heart breaks 深情的人逃不過落淚 This is how a heart breaks 太過逞強注定會破碎 越愛越頭痛欲裂~ 還想醉~ A second chance A second chance I give you 渴望幸福 不就得執著守護 重溫你擁抱的濃度 最美好的回憶是魔術 讓新謊言 都像諾言 禮物 This is how a heart breaks 天使放膽愛上了魔鬼 This is how a heart breaks 迷信的直覺竟然是錯覺 再浪漫的人 也要面對 愛從來不能 克服一切 Hum… ["Music", "Sad music"] ["female singer", "slow tempo", "soft piano accompaniment", "lonely", "pain", "heart break", "sad", "pop", "dreamy", "love song", "young love", "emotional", "sentimental", "foreign language", "romantic", "lonely", "melancholic", "pensive", "pop"] 7 1IK4OeOqAEo 253

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;