musiccaps_details (view)
1 row where musiccaps_aspects contains "groovy hi hats", musiccaps_aspects contains "heartfelt", musiccaps_aspects contains "romantic", musiccaps_aspects contains "smooth bass" and musiccaps_author = 4
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 |
---|---|---|---|---|---|---|---|---|---|---|
Famous paintings of wedding and marriage (Music: I dream of you/Sha la la love song) | The ballad song features a mellow female vocal singing over a mellow organ keys melody, groovy hi hats, soft snare and kick hits and smooth bass. It sounds emotional, heartfelt and romantic - like something you would hear at a wedding. | 2011-05-05T16:33:05Z | isisip | Famous paintings of wedding and marriage in the history of art. Artists include: John Henry Frederick Bacon, Tuxen Laurits, Pierre-Auguste Renoir, Firs Sergeevich Zhuravlev, Edmund Blair Leighton, Harrison Fisher. If you are interested in knowing the titles of the paintings, please visit http://weddingdressmarriage.blogspot.com/ Song: I dream of you Words and Music by: Isisip Performed by :Isisip (C) 2008-2011 Isisip MP3 available at http://www.pianomusicdownload.blogspot.com See also: Sad beauty piano solo in 3 keys https://www.youtube.com/watch?v=IE95p3edfIg Top 10 piano songs https://www.youtube.com/watch?v=fKxmSe5s9_s Piano music playlist https://www.youtube.com/watch?v=K0mXJ-QYIRw The unfinished story piano performance https://www.youtube.com/watch?v=N06aA_vjZPA Moonlight piano performance https://www.youtube.com/watch?v=NFcPR5WgeQA Sad beauty piano performance https://www.youtube.com/watch?v=DgbdWyTtWco Ask the sky without words piano performance https://www.youtube.com/watch?v=EnJSIOaPxp0 Please buy the music or make a donation: http://pianodiscography.blogspot.com Sheet music: http://isisippianosheetmusic.blogspot.com | ["Singing", "Music of Asia", "Music", "Wedding music", "Song", "Classical music"] | ["ballad", "mellow organ keys melody", "groovy hi hats", "soft kick hits", "soft snare hits", "smooth bass", "mellow female vocal", "emotional", "heartfelt", "romantic"] | 4 | g0scnRzoo9M | 4003 |
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;