musiccaps_details (view)
1 row where musiccaps_aspects contains "effected trumpet", musiccaps_aspects contains "glissando" and musiccaps_names contains "Wind instrument, woodwind instrument"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Maa Jagdambe Chowki - 3rd March, 2013 | A solo trumpet playing an energetic staccato melody with dramatic glissandi. The trumpet has been processed to add a stereo delay effect and reverb. The tone is very bright. | 2013-03-22T12:15:10Z | Shri Radhe Maa | Maa Jagdambe Chowki in Radhe Maa's sannidhya for more details visit - http://goo.gl/WyEgh To know more about Shri Radhe Maa visit - radhemaa.com or contact Talli Baba ji - +91 982 096 9020 Basic facts about Mamtamai Shri Radhe Guru Maa 1) Mamtamai Shri Radhe Guru Maa is a devotee of Lord Shiva and Maa Durga 2) She considers herself a sevika of God 3) Her darshans have always been free and are open to all without exception 4) She is a guru who guides her followers to pray to Maa Durga and Lord Shiva and has never claimed to be an avatar or Goddess 5) She is not a 'new' guru. Her oldest devotees have been in her service for the last 25 years If you have any doubts/questions/ queries? 1) Visit her website www.radhemaa.com 2) Visit her facebookpage and discuss Shri Radhe Guru Maa with her devotees 3) Call sevadars who offer free service to Guru Maa and discuss what she is about 4) Visit Guru Maa's bhavan in Mumbai and take her darshan. It is free and open to all without exception PS : Info about her facebook page, name and contact numbers of her sevadars and darshan dates are all updated regularly on www.radhemaa.com. Call sevadar on 9820969020 / 9820969020 to know more Copyright All titles in the film & video collection are copyrighted. Unauthorized use or duplication of the content of the video in any manner is strictly prohibited without the prior written permission of its owner. (c) 2012. All Rights Reserved. Sanjeev Gupta | e-mail : sanjeev@globaladvertisers.in | Fax: +91 22 2893 9404 | ["Wind instrument, woodwind instrument", "Shofar"] | ["effected trumpet", "processed", "reverb", "delay", "bright", "energetic", "solo trumpet", "glissando", "stacatto", "dramatic"] | 8 | mBG-st0VUXs | 4452 |
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;