home / musiccaps

musiccaps_details (view)

2 rows where musiccaps_aspects contains "foreign language", musiccaps_aspects contains "sad", musiccaps_aspects contains "sentimental" and musiccaps_author = 7

✎ 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
Kom Leuk Torosab Ke Pel Nov Kbe Oun RHM CD Vol 471 A female vocalist sings this soft song in a foreign language. The tempo is slow with a soft piano accompaniment and sound of chimes. The vocals are mellow, passionate,emotional, sentimental, nostalgic, melancholic and reflective. This song is a sad classic Pop. 2013-01-16T04:20:07Z BayKdang For more Video go to my Channel Youtube : http://www.youtube.com/subscription_center?add_user=BayKdang ["Music", "Speech", "Sad music"] ["female vocalist", "slow tempo", "foreign language", "emotional", "sentimental", "poignant", "heart break", "melancholic", "piano accompaniment", "soft", "mellow", "melancholic", "sad", "chimes"] 7 91AmOKytRUM 970

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;
Powered by Datasette · Queries took 758.255ms · About: simonw/musiccaps-datasette