musiccaps_details (view)

1 row where musiccaps_aspects contains "k-pop", musiccaps_aspects contains "percussive bass line", musiccaps_aspects contains "vocal harmony" and musiccaps_names contains "Music of Asia"

✎ 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
KARA - 「マンマミーア！」Music　Video A female singer sings this cool pop melody. The song is medium with a steady drumming rhythm, percussive bass line, keyboard accompaniment and various percussion hits. The song is modern K-pop. The song is romantic and cheerful. 2014-08-18T19:00:08Z KARAJAPANChannel 遂にベールを脱いだ新生KARAが放つ、超最新ダンスチューン！ New Single 2014.08.27 Release!! 「マンマミーア！」 予約はこちらから： http://umusic.ly/kara_umstore 初回封入特典:2014年全国ツアーチケット先行抽選受け付けシリアルナンバー 応募期間:2014年8月26(火)18:00〜2014年9月3(水)23:00 初回限定盤ASG+DVDUMCK-9696 ￥1,886(税抜)＋税 ＜CD＞ 1. マンマミーア！ 2. ソー・グッド 3. マンマミーア！(Instrumental) 4. ソー・グッド(Instrumental) ＜DVD＞ マンマミーア！(Music Video Clip) マンマミーア！(Dance Shot Ver.) マンマミーア！(Music Video Clip オフショット) 初回限定盤BSG+フォトブックUMCK-9697 ￥1,600(税抜価格)＋税 ＜CD＞ 1. マンマミーア！ 2. ソー・グッド 3. マンマミーア！(Instrumental) 4. ソー・グッド(Instrumental) ＜フォトブック＞ 28Pスペシャルフォトブック 初回限定盤CSG+ボーナストラックUMCK-9698 ￥1,200(税抜価格)＋税 ＜CD＞ 1. マンマミーア！ 2. ソー・グッド 3. マンマミーア！(Instrumental) 4. ソー・グッド(Instrumental) 5. Don’t Hurry (Bonus Track) ＊初回盤Cが終了次第、通常盤SGのみ（UMCK-5494 ￥1,000＋税）に移行します ◆UM JAPAN KARA オフィシャルサイト http://umusic.ly/um_kara ["Music of Asia", "Music"] ["k-pop", "korean pop", "percussive bass line", "medium tempo", "backup singers", "vocal harmony", "steady drumming rhythm", "keyboard accompaniment", "various percussion hits", "pop hits", "pop diva", "romantic", "love song", "emotional", "female singer", "cheerful positive", "love me", "electric guitar strumming"] 1 EQSv7DIJJtw 1555

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;