musiccaps_details (view)
1 row where musiccaps_aspects contains "dreamy", musiccaps_aspects contains "pain", musiccaps_author = 7 and musiccaps_names contains "Sad music"
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
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;