musiccaps_details (view)

1 row where musiccaps_aspects contains "progressive", musiccaps_aspects contains "vocal backup" and musiccaps_names contains "Middle Eastern music"

✎ 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
Narcy featuring Shadia Mansour "Hamdulillah" Official Music Video A male vocalist sings this Rap. The tempo is slow with enthusiastic drumming, syncopated piano harmony, digital beats ,keyboard arrangements with vocal backup and a catchy vocal riff. The rap is catchy, youthful, insightful, enthusiastic, intense, passionate, emotional and persuasive. This song is contemporary Rap/Hip-Hop. 2010-09-14T17:43:13Z IRAQ-A-FELLA Available on iTunes, Shazam, Rdio, Anghami and AmazonMP3 Follow The Narcicyst Facebook: https://www.facebook.com/Narcicyst Twitter: http://www.twitter.com/TheNarcicyst Insta: http://www.instagram.com/narcynarce http://www.thenarcicyst.com The Narcicyst featuring Shadia Mansour - "Hamdulillah" (Official Music Video) Directed and Edited by Ridwan Adhami Written by Yassin Alsalman and Shadia Mansour Original Track produced by SandhiLL Piano by Stefan Christoff Additional production and arrangement by Doctor Dinar and The Narcicyst To say 'Hamdulillah' is to be grateful for what one has. The images of the past decades have cast a veil on our identity as a people. We, as international brothers and sisters, are now witness to injustice in real time. We watch our Wars in HD. It is time for us to claim our faces back. This video is a global collaborative effort by 10 photographers- from London to Lebanon, Cairo To Canada, Abu Dhabi to America- to create a portrait of the New Global Citizens. They are DJs, MCs, poets, architects, teachers, doctors, parents and children. Most of all they are people. Thank you to everyone that was involved. We are blessed to have each other. LYRICS Bismillah, like the feeling when I miss Falah, then wish to God in clouds to lift us all Hamdulilah, wonder if Bibi can ever see me, and if I back to Basrah will it ever receive me, Bismillah, homies that have the time to talk, Now I wish to stars that angel find Nawaf. Hamdulillah, I stand awed at the strength of my sister Kiss her and thank God our mission is planned for us. Bismillah, mamati inti hayati, moms the best one, hold her close to heart like my left lung Hamdulillah, for the truth in a being as beaming the moon queen you blessed my future to be with Bismillah, for the souls anguish, love, and the moment my brothers programmed these drums, Hamdulillah, We put the truth to the test, proof that we're blessed students of this music at best. Bismillah, Before I spit this bar, way Before Militants tried to split t… ["Music", "Pop music", "Middle Eastern music"] ["male vocalist", "slow tempo", "hip-hop", "rap", "progressive", "vocal backup", "youthful", "funky snare drumming", "digital beats", "syncopated piano accompaniment", "groovy bass line", "synthesiser arrangements", "persuasive", "story telling", "rhythmic patter", "rhythmic speech", "intense", "passionate", "emotional", "intense", "vocal riff"] 7 0ISHZQJdeSw 142

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;