musiccaps_details (view)

1 row where musiccaps_aspects contains "indian classical", musiccaps_aspects contains "male vocalist" and musiccaps_aspects contains "mantras"

✎ 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
Ganesh Puja Aarambh A male vocalist sings this gentle Puja song. The tempo is slow with atmospheric synthesiser, chimes, keyboard harmony and electronic arrangements to give an intense, ethereal, celestial vibe. The song is a Sanskrit chant, melodious prayer, and devotion song. It is soothing, calming, meditative, prayerful, reflective and pensive. 2009-08-06T18:23:59Z sacredverses Shlokas from complete Ganesh Puja performed by Pundit Rajendra Kimothi, Ph.D. Track: Puja Aarambh Artist: Pt. Rajendra Prasad Kimothi, Ph.D. Album: Ganesh Puja Download links: http://www.amazon.com/Ganesh-Puja/dp/B00A14SHAK/ http://www.amazon.co.uk/Ganesh-Puja/dp/B00A13LXFM/ http://music.ovi.com/in/en/pc/Product/Pandit-Rajendra-Prasad-Kimothi/Ganesh-Puja/15277030 Buy CD: http://www.flipkart.com/ganesh-puja-music/p/itmd7vh9u5yfsyzc Just as Om is the Vedic mantra which is added to the beginning of every shloka, similarly, one must do the puja of Lord Ganesh before one does the puja of any other God. This is a boon granted to Lord Ganesh by Lord Shiva himself! The names used to refer to Lord Ganesh include the following: Vakratunda - one with a twisted trunk. Mahakaya- one with a huge body. Koti Surya Samaprabham - one who shines like ten million stars. Vighnaharta - one who removes all the obstacles. Riddhidayak - one who has the ability to grant great wealth. Siddhidayak - one who has the ability to grant all wishes. According to Narad Puran, "...those students who desire knowledge, or those people who desire wealth, or those who have no progeny but desire children, will have their wishes and desires granted by doing the puja of Lord Ganesh." "OM GAN GANPATAYE NAMAH." ["Carnatic music", "Mantra", "Music"] ["male vocalist", "slow", "pensive", "contemplative", "reflective", "devotional", "reverence", "tempo", "ethereal", "celestial", "indian morning prayer", "hindu prayer", "festivals", "indian festival", "hindu festivals", "mantras", "atmospheric synthesiser", "auto tune", "electronic instrumentation", "chant", "indian classical", "worship", "devotion", "sanskrit", "sanskrit chant", "ambient", "meditative", "prayerful", "chimes", "surround sound", "keyboard hamony", "puja"] 7 AzWIKyRnhG8 1188

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;