musiccaps_details (view)
1 row where musiccaps_aspects contains "middle eastern", musiccaps_aspects contains "rhythmic keyboard", musiccaps_aspects contains "synthesizer pad" and musiccaps_names contains "Music of Asia"
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
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;