musiccaps_details (view)
1 row where musiccaps_aspects contains "harmonium", musiccaps_aspects contains "melodic singing", musiccaps_aspects contains "romantic" and musiccaps_aspects contains "romantic pop"
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 |
---|---|---|---|---|---|---|---|---|---|---|
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
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;