musiccaps_details (view)
1 row where musiccaps_aspects contains "buddhism", musiccaps_aspects contains "reverence" and musiccaps_author = 7
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Touzani & Maher (PSV) | This music is instrumental . The tempo is medium fast with the sound of a conch shell or shell trumpet playing a victorious drone. The music is loud, clear, deep and is often used in religious and sacred rituals in Hinduism and Buddhism. There are sounds of phone dealing and ringing. This music is superimposed on the sound of male talking and children cheering in unison. | 2014-09-25T17:56:01Z | TOUZANI TV | Touzani & Maher (PSV) ► Bedankt voor het abonneren! - https://bit.ly/2PkZoGC 🔔 Belletje aan is zo gedaan. Mis geen 1 video! 🎒 Touzani Shop - https://www.touzani.shop/kids ►Meld je aan voor de Touzani Training - https://touzanitraining.com/ 👨🏻💻 Bekijk de nieuwste video's! - https://bit.ly/2JtNu9H Volg mij op Instagram 🙋🏻♂️ http://Instagram.com/TouzaniTV 🙋🏻♂️ https://www.instagram.com/touzani.sho... 🙋🏻♂️ https://www.instagram.com/touzanischo... TouzaniTV bestaat uit verschillende voetbal video's! Video's met de beste voetballers ter wereld, maar ook met de grootste talenten.Wij gaan ook langs verschillende voetbalclubs! Touzani gaat ook challenges aan die door de fans worden bedacht! Wij proberen ook altijd een prijs weg te geven aan onze trouwe kijkers. Dat kan een shirt of voetbalschoen zijn van een profvoetballer of Touzani trainingspakken. Heel veel kijkplezier en welkom bij TOUZANI TV ! Business of Media contact: info@touzanifc.com Alle video's worden geproduceerd door TouzaniFC B.V. http://www.touzanifc.com/ Touzani heeft ook een eigen stichting https://www.touzanifoundation.nl/ Adam Maher(PSV) was most talented player in 2012. Watch the report with Soufiane Touzani on a brand new channel, here on you tube. CRUYFF COURT TV | ["Wind instrument, woodwind instrument", "Shofar"] | ["instrumental", "slow tempo", "phone dial tone", "celebration", "reverence", "puja", "meditation", "phone ringing", "conch shell sound", "celebr", "victory", "announcement", "shell trumpet", "wind instrument", "conical bore", "sacred", "hinduism", "buddhism", "exaltation", "worship", "male voice talking", "children cheering in unison"] | 7 | nn2TnOGCHDI | 4575 |
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;