musiccaps_details (view)
1 row where musiccaps_aspects contains "average audio quality", musiccaps_aspects contains "indian percussions" and musiccaps_aspects contains "passionate"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Aye Hip Hopper - ishQ Bector ft Sunidhi Chauhan | Amruta Khanvilkar [OFFICIAL VIDEO] | A female singer sings this passionate melody. The song is a medium tempo with a groovy bass line , steady drumming, keyboard accompaniment, Indian percussion and tambourine accompaniment. The song is playful and romantic. The song is a modern Bollywood pop song with average quality audio. | 2009-12-26T23:05:57Z | ishQ Bector | Starring: IshQ Bector & Amruta Khanvilkar Produced by Sykz Total Fitness Directed by: WildKumar Music: Hanif Shaikh + Chirantan Bhatt Song Produced by IshQ Bector, Chirantan Bhatt & Hanif Shaikh Lyrics: IshQ Bector, Nitin Gupta, Amitabh Bhattachariya, Chirantan Bhatt, & Hanif Shaikh Recorded at the House of IshQ "Aye Hip-Hopper"(Album- Dakku Daddy), is an epic love story between a star Hip-Hopper and his bai (maid)! Will this hot bai be able to sweep IshQ off his feet? ---------------------------------------- ---- Naashta tayaar hai sir. Aur kuch chahiye? Bolo to mein? Yeah. Just gimme some Hip-Hop! Aye Hip-Hopper mujhe pyar to kar Aye Hip-Hopper Mere pyar ke dariya mein, mere laoo (love) ke dariya mein Ek dubki lo na sir! Aye Hip-Hopper! Kya tu bak rahi hai? Aise tak rahi hai Khopdi pak rahi hai Ruk Ruk Ruk Ruk Bakshish bhi diya aur, Bonus bhi diya aur, Chahiye tujko kya? Chal! Phut. Phut. Phut. Phut. Tere ghar me bartan shartan maanjti hun mein barabar. Tu kabhie tho mere dil ke ghar mein pocha kar de aa kar. God she thinks she's hot like Rekha, Maybe but she's not my flavour. Loving her is too much labour. Labour. L-Labour. How can I? I'm a star Hip-Hopper. She's my bai just a part time naukar. Aye aye bhai gotta be high to rock her. Rock her. Rock her. Just gimme some Hip-Hop! Aye Hip-Hopper mujhe pyar to kar Aye Hip-Hopper Mere pyar ke rickshaw ko, mere love ke rickshaw ko. Ek dhakaa do na sir! Aye Hip-Hopper! Ish! Sir.. lo na.. phone.. Meri girlfriend aa rahi hai. Tu kab jah rahi hai? Kyun sataa rahi hai? Ruk Ruk Ruk Ruk Us ko pata joh. Chale to hoga voh. Socha na hoga joh. Phut. Phut. Phut. Phut. Tujko har din khana-vana main khilaati hun pakaa kar. Aaj mere dil ke tave pe, rotiyan tu sekle aa kar. There's no bai I know quite like her. If my girl finds out she'll strike her. But she's the bomb! Dam I wanna light her. Light her. L- Light her. Lock the door bend down lets do it. Mop the floor turn around lets do it. All the bais cook it up get to it. To it. To it. Just gimme some … | ["Singing", "Music", "Telephone bell ringing", "Hip hop music"] | ["telephone ringing", "hindi pop music", "medium tempo", "indian percussions", "tambourine percussions", "female singers", "romantic", "love song", "hindi pop song", "guitar rhythm", "strong bass line", "energetic", "passionate", "bollywood dance music", "average audio quality", "keyboard accompaniment"] | 1 | DCFrCX4HPO8 | 1452 |
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;