musiccaps_details (view)
3 rows where musiccaps_aspects contains "emotional", musiccaps_aspects contains "lonely", musiccaps_aspects contains "sad" and musiccaps_author = 7
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 | |
CAKE - Never There (Official HD Video) | A male vocalist sings this quirky Rock melody. The tempo is medium fast with groovy electric guitar harmony, funky, intense bass lines, infectious drumming, keyboard accompaniment and vocal backup. The song is catchy, rhythmic, emotional, incessant, sentimental, melancholic, lonely, romantic , unconventional, quirky and upbeat. This song is classic rock. | 2011-03-18T00:20:30Z | CakeVEVO | ”Never There” by CAKE in HD Listen to CAKE: https://Cake.lnk.to/listenYD Watch more videos by CAKE: https://Cake.lnk.to/listenYD/youtube Subscribe to the official CAKE YouTube channel: https://Cake.lnk.to/subscribeYD Follow CAKE Facebook: https://Cake.lnk.to/followFI Instagram: https://Cake.lnk.to/followII Twitter: https://Cake.lnk.to/followTI Website: https://Cake.lnk.to/followWI Spotify: https://Cake.lnk.to/followSI YouTube: https://Cake.lnk.to/subscribeYD Ask your voice device to play CAKE! Lyrics: Never there You're never there You're never ever, ever, ever there Hey! #CAKE #NeverThere #OfficialHDVideo #HD #Remastered #ProlongingTheMagic #Rock | ["Funk", "Music"] | ["male vocalist", "medium fast tempo", "vocal backup", "funky bass lines", "groovy electric guitar lead", "keyboard accompaniment", "infectious drumming", "passionate", "emotional", "sentimental", "love song", "alternative rock", "funk rock", "alternative dance", "rhythmic", "melancholic", "sad", "lonely", "repetitive", "incessant", "breakup", "heart break", "classic rock", "quirky music", "engaging", "youthful", "enthusiastic"] | 7 | FRZzUh9hcTo | 1642 | |
harry & eggsy | all i want | A male vocalist sings this sad melody. The tempo is slow with an acoustic guitar accompaniment and a droning keyboard harmony. The song is soft ,mellow, sad, emotional, sentimental, regretful , lonely and poignant. This song is an Alternative Rock/Indie. | 2015-08-20T05:52:36Z | stoleyourmateria | HARTWIN WEEK: Day 5: angst ----------------------------------------------------------------- (PLEASE WATCH IN HD) this is kind of a companion piece to my hartwin "love love love" fanvid. i had a lot of fun editing this. hope you enjoy the angst! :D ----------------------------------------------------------------- • fandom: kingsman • pairing: harry hart & eggsy unwin • song: "all i want" by kodaline ---------------------------------------------------------------- Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for "fair use" for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favor of fair use. | ["Music", "Theremin"] | ["male singer", "slow tempo", "acoustic guitar", "atmospheric", "poignant", "dream pop", "lonely", "pop rock", "longing", "sombre", "breakup song", "passionate", "sad", "wistful", "emotional", "sentimental", "regretful", "wistful", "movie soundtrack", "droning keyboard harmony"] | 7 | gTX4SG70cEY | 4032 |
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;