musiccaps_details (view)

2 rows where search matches "opera" and musiccaps_names contains "Middle Eastern music"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: youtube_published (date)

musiccaps_names (array) 4 ✖

musiccaps_author 2 ✖

video youtube_link musiccaps_caption youtube_published youtube_channel youtube_description musiccaps_names musiccaps_aspects musiccaps_author youtube_id musiccaps_rowid
XV MARIELA VALS This is an opera song that's recorded at a very low quality. The vocal audio is distorted and creates some fuzzy sounds, and the string instruments are muffled. The song is an uplifting, emotional song. 2011-06-11T07:33:39Z ✅ FOTOGRAFIA Y VIDEO EN GDL ✅ POR COMENTARIOS FALTOS DE CRITERIO E INSULTANTES NO MAS COMENTARIOS. ["Music", "Middle Eastern music"] ["low quality recording", "opera music", "inspiring", "emotional", "uplifting", "distorted recording", "string instruments"] 3 8zCZzzAaC4I 964
Ahmad Zahir - Maihan Hai Maihan - Vol 1 This is an Afghan romantic pop piece. There is a male vocalist singing melodically in the lead. A harmonium is playing the main tune, at times simultaneously with the vocal. The rhythmic background is composed of the tabla percussion. There is an emotional feel to this piece. This piece could be used in the soundtrack of a soap opera taking place in Afghanistan. It could also be used in romantic social media content. 2012-01-16T07:02:50Z Ahmad Zahir 🙏 PLEASE SUBSCRIBE OUR CHANNEL ✅ FOLLOW US: 🇦🇫 @dmin Fraydoon Hakimi ► Facebook: https://www.facebook.com/afghanlatests ►Instagram: https://www.instagram.com/afghanlatest ► Twitter: https://twitter.com/afghanlatest Ahmad Zahir King of Afghanistan Music Ahmad Zahir 2020 Ahmad Zaher 2020 Ahmad Zahir 2019 Ahmad Zaher 2019 Ahmad Zahir 2018 Ahmad Zaher 2018 A * Ahmad Zahir * Ahmad Wali * Aryana Sayeed * Abdul Rahim Sarban * Amir Jan Sabori * Awalmir * Asad Badie * Aziz Herawi B * Bakht Zamina * Beltoon * Burka Band D * Dawood Sarkhosh E * Ehsan Aman * Elaha Soroor F * Farhad Darya * Farid Rastagar * Faiz Karizi * Farid Zaland * Fereshta Samah H * Hangama * Haidar Salim I * Jalil Zaland K * Khyal Muhammad L * Latif Nangarhari M * Mohammad Din Zakhil * Mozhdah Jamalzadah * Mohammad Hussain Sarahang * Mahwash * Mohammad Hashem Cheshti * Miri Maftun * Mangal * Mariam Wafa * Mohammad Din Zakhil N * Nasrat Parsa * Naghma * Nashenas * Naim Popal * Nainawaz * Nasrat Sharqi P * Parasto Q * Qamar Gula * Qader Eshpari R * Rafiq Shinwari * Rahim Mehryar * Rahim Bakhsh * Rezwan Munawar * Rishad Zahir S * Sardar Ali Takkar * Shah Wali * Soosan Firooz * Shakeeb Hamdard * Seeta Qasemi * Soheila Zaland * Saifo * Seema Tarana T * Tahir Shubab * Tawab Arash U * Ubaidullah Jan V * Vahid Soroor W * Wajiha Rastagar * Wahed Wafa Z * Zahir Howaida Ahmad Zahir Farhad Darya jawd sharif new qataghani 2012 jawid sharif yak qadam pesh Jawid Sharif Yak Qadam Pesh yak qandam pesh Yak Qadam Pesh jawid sharif Raminmansour production new qataghani jawid sharif new qataghani 2012 yak qadam pesh jawid sharif jawid sharif new song 2012 Jawid Sharif Unknown gunmen shot dead famous Pushto singer Ghazala Javed along with her father in the provincial capital of Khyber-Pukhtunkhwa Jawid Sharif new Qataghani 2012 Jawid Sharif new song 2012 Jawid Sharif Jawid Sharif Yak Qadam Pesh New Qataghani 2012 Jawid Sharif - Yak Qadam Pesh Fayaz Hamid-Dard e Dil New Song-Nov 2011 720p HD Mp4 Singer : Fayaz Hamid Song : Dard E Dil Lyrics By : Qahar Aasi Compo… ["Carnatic music", "Music", "Middle Eastern music", "Song"] ["afghan", "romantic pop", "male vocal", "melodic singing", "harmonium", "tabla", "emotional", "heart-touching", "romantic", "medium tempo"] 9 T6iv9GFIVyU 2809

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;