musiccaps_details (view)

1 row where musiccaps_aspects contains "jazz influenced" and musiccaps_aspects contains "middle eastern"

✎ 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
DEIVAM THANTHA by Super Singer KRISHNAMURTHY in GANESH KIRUPA Best Light Music Orchestra in Chennai Middle eastern or south Asian jazz influenced music of a male singer singing a free melody, accompanied by syncopated upright bass, shaker, steady drums. There is also a synthesizer pad and a rhythmic keyboard playing. 2012-02-27T16:03:07Z Ganesh Kirupa Song : DEIVAM THANTHA VEEDU Ganesh Kirupa Best Tamil Light Music orchestra in Chennai(FEFSI Sun TV Show, D40 Sun TV Show,MSV's NINAITHALE INIKKUM & Endrendum SPB Fame Live Performance Live Concert) has done more than 4,000 shows in India and Abroad also. An Unique orchestra in which 100 Playback Singers have performed and 40 Eminent Music Directors have participated including Legends like Sri.MSV, Ilayaraja, A.R.Rahman, K.J.Yesudas, S.P.B, T.M.S, P.suseela, K.S.Chitra ,etc. Recently performed FEFSI -SUN TV STAR NITE and D-40 SUN TV STAR NITE with 70 Piece Orchestra.A Grand 100 Piece Orchestra Support and Conducted by GANESH KIRUPA for M.S.V's NINAITHALE INIKKUM for JAYA TV 14th Anniversary. For More Information Visit http://ganeshkirupa.blogspot.com CONTACT: +91 98410 89555, +91 44 2486 6993 Email: ganeshkirupamusic@gmail.com ["Music of Asia", "Music"] ["jazz influenced", "syncopated upright bass", "male singer", "free melody", "shaker", "synthesizer pad", "rhythmic keyboard", "steady drums", "middle eastern", "south asian"] 8 WEVBqGarEIY 3077

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;