musiccaps_details (view)

21 rows where search matches "opera" and musiccaps_author = 9

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: musiccaps_names, youtube_published (date)

musiccaps_author 1 ✖

video youtube_link musiccaps_caption youtube_published youtube_channel youtube_description musiccaps_names musiccaps_aspects musiccaps_author youtube_id musiccaps_rowid
Bab Darek / Mohamed-Ali Kammoun feat. Eya Daghnouj This is a Tunisian folk music piece. There is an orchestra playing the main tune with the dominant sound of the strings section and the oud. There is a choir singing in the background. The atmosphere is vibrant and sentimental. This piece could be in the soundtrack of a Middle Eastern/North African soap opera. 2013-08-28T19:45:37Z Mohamed-Ali KAMMOUN EYA DAGHNOUJ - LEAD VOICE HAMDI MAKHLOUF - LUTH & CHORUS VOICE FEAT. ENSEMBLE ORCHESTRAL DE TUNISIE MOHAMED-ALI KAMMOUN ARRANGEMENT & ELECTRONIC LIVE RECORDING : july 12, room 12, Institut Supérieur de Musique - Tunis, By YACINE AZAIEZ HOME STUDIO MIX : MOHAMED-ALI KAMMOUN ["Jazz", "Music"] ["tunisian folk music", "orchestra", "choir", "strings section", "oud", "vibrant", "sentimental", "melancholic", "eastern sounding"] 9 5J6CjNc8Njo 649
Kiralık Aşk - Enstrümantal Fon Müzik 2 || Instrumental Background Music 2 This is an instrumental piece from a soap opera soundtrack. The violin and the acoustic guitar are playing a mellow tune while there is an occasional piano tune in the background. The rhythm is kept by a very quiet acoustic drum beat. The atmosphere is gentle and romantic. This piece could be used in the soundtrack of romance movies where the characters are having a good time in the presence of each other. 2015-12-14T11:19:46Z Kiralık Aşk Soundtrack ABONE OL tuşuna basarak kanalıma abone olmayı unutmayın! Please do not forget to SUBSCRIBE my channel! ["Music", "Sad music"] ["soap opera soundtrack", "instrumental", "violin", "acoustic guitar", "piano", "acoustic drums", "gentle", "emotional", "romantic"] 9 7eZTmLV9gcY 871
Cecilia Bartoli's Operatic Vocal Range (in about a minute!) This piece is a compilation of an opera singer's high-pitched singing that shows how high of a pitch she can reach. For the most part, she is holding a single high note as the strings in the orchestra provide the harmonic background. 2010-12-23T17:05:25Z SsteinwayS US: http://amzn.to/2itVgnr Canada: http://amzn.to/2iRUtNK Cecilia Bartoli’s vocal range: from low E below middle C to high E-flat above soprano high C! ["Singing", "Music", "Opera"] ["opera", "classical", "orchestra", "strings", "female vocal", "high-pitched singing", "compilation", "vocal range"] 9 AElgGuUSSKE 1088
Hüsnü Klarnet - senin olmaya geldim This is the live performance of a Turkish folk music piece with arabesque influences. The clarinet is playing the main melody in the lead at a medium-to-high pitch. A secondary melody is playing the qanun in the background. There are supportive elements in the melodic background such as the saz, the keyboard and the bass guitar. The acoustic drums are playing a mellow beat accompanied by rich percussion. There is a vibrant atmosphere in this piece. This could be playing in the background of a Turkish cuisine restaurant or a hookah place. It could also be used in the soundtrack of a Turkish soap opera. 2008-09-27T11:11:52Z hsenlendirici WWW.HUSNUFAN.ORG ["Clarinet", "Traditional music", "Music"] ["turkish folk", "arabesque", "clarinet", "qanun", "saz", "keyboard", "bass guitar", "acoustic drums", "percussion", "vibrant", "emotional", "heart-touching", "live performance"] 9 BMgYWTTJv3s 1232
MARIA TOLEDO- La loca (en directo desde el Teatro Lope de Vega de Sevilla) This is a flamenco music piece being performed live. There is a female vocalist singing passionately in the Spanish language. The acoustic guitar is playing the melodic background while the rhythmic background is played by the cajon percussion and a group of musicians clapping in a syncopated manner. The atmosphere is vibrant and agitated. This piece could be used in the soundtrack of a soap opera or a romance/drama movie. It could also be playing in the background at a Spanish/Latin American cuisine restaurant. 2011-11-18T17:11:15Z MARÍA TOLEDO Maria Toledo cantó en el teatro Lope de Vega de Sevilla el día 14-10-2011 junto a Jesús de Rosario a la guitarra, Lucky Losada al cajón y Amparo Lagares, Luis Carrasco Juan Diego y Juan Grande al compás. Vestida por Vicky Martín Berrocal Grabación video: Miguel Ángel Cárdaba. ["Singing", "Flamenco", "Music", "Music of Latin America"] ["flamenco", "live performance", "female vocal", "passionate singing", "acoustic guitar", "cajon", "claps", "vibrant", "emotional", "agitated", "spanish"] 9 C8VECv8kicU 1336
Queen - "We Are the Champions" Acapella (Vocals Only) Concert Mash-Up This is an isolated vocal track of a rock opera piece. There are no instruments. A passionate male vocalist is singing melodically in the lead. There is a choir in the background providing medium-to-high pitched back vocals. There is an uplifting atmosphere. This piece could be used in remixes. Vocal samples can be lifted for DJ sets or beat-making. 2015-12-30T08:49:25Z Playback.fm About video: http://playback.fm/blog/queen-we-are-the-champions-acapella/ - Follow us on Facebook: https://www.facebook.com/playbackapp We love Queen and Freddie Mercury, so we've edited 4 concert films including a rare recording session of "We Are The Champions" and synced them all up to the isolated vocals in honor of the late, great, Freddie Mercury. This video showcases his presence and consistency as the ultimate stage man. RIP Freddie. You are a rock god. ["Chant", "Music"] ["rock opera", "vocal track", "no instruments", "male vocal", "passionate singing", "choir", "dramatic", "uplifting", "vibrant"] 9 GF8QWSW0UbY 1701
Ouverture de l'opéra-ballet Pygmalion This is a French opera/opera-ballet music piece. There is no singer in this piece. The only instrument that is being played is a harpsichord. The sound and the tunes are reminiscent of the medieval era. There is a theatrical feel to the piece. This piece could be used in the soundtrack of a historical drama that takes place in the medieval era. It could also be used as an accompaniment piece for a theater play or a ballet dance performance. 2011-07-25T21:59:45Z Jory Vinikour Jean-Philippe Rameau, composer (transcribed by Claude Balbâtre) Jory Vinikour, harpsichord French double harpsichord by Cucchiara and Pierce Recorded April 13, 2011 in Shaker Heights, Ohio USA ["Harpsichord", "Keyboard (musical)"] ["french opera", "opera-ballet", "no singer", "instrumental", "harpsichord", "medieval sounding", "theatrical", "ballet dance"] 9 Iz611KubW70 1957
Sad Music - Emanetin Bende Sakli - Toygar Isikli This is an instrumental music piece that was made for a soap opera soundtrack. The piano and the strings are playing gently in a melancholic manner. The atmosphere of the piece is emotional. This piece could be used in the soundtrack of a drama movie during scenes of hopelessness or heartbreak. 2012-12-02T00:07:15Z Moustafa Hodroj   ["Cello", "Double bass", "Bowed string instrument"] ["soap opera music", "no singer", "instrumental", "piano", "strings", "melancholic", "emotional", "downcast"] 9 P4aTFrJws40 2501
Praying Mantis Eats Cricket This is a rock opera piece. There is a male vocalist singing passionately with a choir of backing vocals. The piano plays the main theme with the electric guitar while a bass guitar plays in the background. The rhythmic background is provided by the acoustic drums playing a simple rock beat. There is an energetic atmosphere to the piece. This piece could be used at sports venues. It could also be playing in the background of a bar. 2008-05-05T19:45:40Z caz50 One of my mantis nymphs munching on a cricket. ["Music", "Punk rock", "Grunge"] ["rock opera", "male vocal", "dramatic singing", "choir", "piano", "electric guitar", "bass guitar", "acoustic drums", "rising pattern", "vibrant", "energetic"] 9 QqRrZzOY2xw 2642
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
Константин Плужников Lullaby Berceuse de la Bretagne This is a Russian lullaby piece with classical music elements. The male vocalist is singing at a medium-to-high pitch in an opera-like manner. The strings and the piano are playing a gentle but crestfallen melody. The atmosphere is haunting. This piece could fit perfectly in the soundtrack of a post-apocalyptic war movie or a video game of similar theme. It could also work well in the soundtrack of a drama movie or an art movie that takes place in Russia or Eastern Europe. It might also be playing in the background at a high-tier Russian cuisine restaurant. 2012-12-24T03:43:59Z Bronisliva Константин Плужников Бретонская колыбельная песня (М.Ипполитов-Иванов - В. Соловьев) Konstantin Pluzhnikov Berceuse de la Bretagne Lullaby (M.Ippolitov-Ivanov - V. Soloviev) Artist - P. de Chavannes ["Music", "Opera", "Lullaby"] ["russian", "lullaby", "classical", "male vocal", "medium-to-high pitch singing", "strings", "piano", "crestfallen", "haunting", "melancholic"] 9 ZKkfCOqLrT0 3363
Jaar Project-dOar tu This is a Romanian pop music piece. There is a male vocalist singing with autotune. The melody is being played by a synth sound. There is a bass guitar playing a simple bass line while the rhythmic background consists of a slow tempo electronic drum beat. The atmosphere is sentimental. This piece could be used in the soundtrack of a Romanian soap opera, especially during romantic scenes. 2009-08-25T17:51:29Z DyeNuZzA1 va place?... ["Christian music", "Music"] ["romanian pop music", "male vocal", "autotune singing", "synth sound", "bass guitar", "electronic drums", "slow tempo", "sentimental"] 9 b2-izZk5_BM 3598
Barbara, Eustaquia, Melquiades, & Juan Primito || Hide & Seek This is a vocal performance from a soap opera soundtrack. There is a female vocalist that is singing with a heavily manipulated voice, most probably through the use of a vocoder. The volume of the track is unnecessarily loud and it peaks frequently. There is an unsettling atmosphere. It could be used in the soundtrack of a horror movie where the protagonist is slowly losing touch with reality. 2010-09-23T16:57:15Z VenusKaMGchannel2 RE-UPLOADED Rights reserved by Telemundo NBC. No Copyright Infringment Intended. Copyright Disclaimer under Section 107 of the Copyright Act 1976, allowance is made for fair use for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favor of fair use. la cancion es "Hide and Seek" de Imogen Heap ["Vocal music"] ["soap opera soundtrack", "female voice", "vocoder", "eerie", "unsettling", "loud", "irritating"] 9 b6hr31Qaemg 3602
The Sound of Music - Musical-sing-a-long (repetitie) This is a rock opera piece that is being sung by a female vocalist in a medium-to-high pitch range. There is an orchestra playing the melody in the background composed of strings, flute and a piano. The atmosphere of the piece is dreamy and sentimental. It could be used in the soundtrack of a fairytale movie. 2014-09-01T19:54:18Z Kindermuziek De cast van The Sound of Music maakt haar opwachting tijdens de Musical-sing-a-long tijdens de Uitmarkt 2014 op het Museumplein in Amsterdam ["Singing", "Music of Asia", "Music", "Sad music"] ["rock opera", "live performance", "female vocal", "medium-to-high pitch singing", "orchestra", "strings", "flute", "piano", "dreamy", "sentimental", "dramatic"] 9 fZjQBgPD1Ys 3960
Cristian Gonzalez y Orquesta La Bohemia - Cuanto Daria (Official Music Video) This is a latin pop music piece with a salsa beat. There is a male vocalist singing melodically in the lead. The melody is being played by an orchestra composed of the trumpet, the piano and the bass guitar. The rhythmic background is provided by a mild acoustic drum beat with heavy use of latin percussive elements. The piece has a sensual atmosphere. This music could go well in a Latin American soap opera soundtrack where there is a hopeless situation for one of the characters. 2011-07-18T21:24:33Z Cristian Gonzalez y Orquesta La Bohemia Disfruta el vídeo oficial del éxito de la salsa romántica "Cuanto Daria" de Cristian Gonzalez y Orquesta La Bohemia, la mejor salsa romántica para bailar gozar y dedicar con amor. 🔔 Activa las notificaciones para mantenerte actualizado con nuevos videos y estrenos! Suscríbete a mi Canal de YouTube: http://Disetti.co/YTCristianGonzalezyOrquestalaBohemia 🎶 Escucha la mejor Playlists de Salsa Romántica y Sensual: http://Disetti.co/SalsaRomanticaySensual ❤️ 🎧 Escucha mi música en tu Plataforma Favorita: http://Disetti.co/CristianGonzalezyOrquestalaBohemia/ Spotify: http://Disetti.co/SpotifyCristianGonzalezyOrquestalaBohemia Apple Music: http://Disetti.co/AppleMusicCristianGonzalezyOrquestalaBohemia Deezer: http://Disetti.co/DeezerCristianGonzalezyOrquestalaBohemia 👉Sígueme en RRSS: https://www.instagram.com/CristianGonzalezyLaBohemia/ https://www.facebook.com/RickyLoveOficial https://www.twitter.com/orqlabohemia Visita: https://www.Disetti.com/ #CuantoDaria #CristianGonzalezyOrquestaLaBohemia #DisettiMusic (C) 2022 Cristian Gonzalez y Orquesta La Bohemia. Todos los derechos reservados ["Music", "Music of Latin America", "Salsa music"] ["latin pop music", "salsa", "male vocal", "melodic singing", "trumpet", "acoustic drums", "piano", "bass guitar", "latin percussion", "sensual", "slow tempo"] 9 hYy0na5oUzE 4118
CAÑA DULCE Y CAÑA BRAVA - EL BUSCAPIÉ (BalconyTV) This is the live performance of a Mexican folk music piece. In the beginning, there is a female voice giving an introductory speech in the Spanish language. Then, the arpa jarocha (which is a Mexican harp) and the ukulele start playing a lively and relaxed tune. The atmosphere is vibrant. This piece could be used in the soundtrack of a Mexican soap opera during scenes of calmer temperament. 2011-02-07T06:44:14Z BALCONY Caña Dulce y Caña Brava perform El Buscapié on BalconyTV. Subscribe to us right now at - http://bit.ly/subscribetoBalconyTV Sigue http://BalconyTV.com.MX en las redes sociales! Facebook http://on.fb.me/ruwZgh Twitter http://t.co/AmbmQvTF PRESENTADO POR LETICIA SERVÍN ENGLISH - http://www.facebook.com/note.php?note_id=150310895026398 Nació como grupo en el año 2008, reuniendo el trabajo de tres mujeres emprendedoras, con una importante trayectoria dentro del arte musical, formando así, una de las pocas agrupaciones femeninas de son jarocho. Caña Dulce y Caña Brava, sembrando alegría y pasión por la música, abriga con frecuencia el decir de trovadores y versadores, enriqueciendo sus presentaciones y mostrándose como una propuesta cálida e innovadora. Actualmente, gracias a su trabajo y a la aceptación del público, han sido invitadas a participar en diversos foros nacionales e internacionales. Adriana Cao Romero, arpista reconocida internacionalmente, ha formado parte de grupos como Zacamandú, y Chuchumbé; asimismo, también ha sido partícipe de presentaciones junto a grandes talentos como El "Negro" Ojeda, don Arcadio Hidalgo, Antonio García de León, y la reconocida gambista, Hille Pearl. Raquel Palacios Vega, viene de una familia sonera por tradición. Nieta de don Andrés Vega Delfín, uno de los requinteros más grandes de Veracruz. Desde los 12 años, acompañada de su voz, la jarana y el zapateado, ha recorrido las llanuras de las regiones bajas de la cuenca del río San Juan; además de haber colaborado con grupos como Los Vega, Teterete y Los Utrera, habiéndose presentado tanto en México como en el extranjero. Norma Carrillo, originaria del Distrito Federal, tuvo su formación musical en la escuela "Vida y Movimiento". Durante 17 años formó parte de La Orquesta Sinfónica Carlos Chávez. También ha incursionado en diferentes géneros musicales como el danzón, la charanga y el son jarocho tradicional. En las siguientes páginas podrán encontrar más información sobre la agrupación de Caña Dulce y Caña Brava.… ["Harp", "Music", "Mandolin", "Musical instrument", "Speech", "Bowed string instrument"] ["mexican folk music", "live performance", "female voice", "introduction", "spanish", "arpa jarocha", "ukulele", "lively", "relaxed", "joyful", "vibrant"] 9 i70a79YhlMk 4161
Bohemian Rhapsody - Acapella Multitrack This is a multitrack acapella cover of a rock opera music piece. The same vocalist is singing different harmonies in separate tracks to create the aura of a magical experience. Usage of multiple tracks creates a vibrant atmosphere. 2009-11-24T08:16:09Z Rob Angus by Freddie Mercury and Queen. SATTBB I'll put this in my "More Balls than Ability" file.... I recorded each of the 6 parts 6 times. Some parts of the bass and soprano were recorded a semitone or two ... 3?...lower or higher and then adjusted. There were some notes in those parts that would not come out of my mouth. It is not pitch corrected.... the sour notes are all me. This project pushes the limits of my laptop. (and far exceeds my ability!) Often the tracks recorded way out of alignment & had to be manually aligned. I assembled the video using Corel Video Studio Pro X2. I had never used it before and had a heck of a time rendering the video to the size and resolution I was looking for. Nonetheless, here it is... such as it is. ["Chant", "Music", "A capella"] ["acapella", "rock opera", "male vocal", "multiharmony", "multitrack", "vibrant", "magical"] 9 mBNdDQamtXA 4453
Iran folk music & opera by soprano, Darya Dadvar This is a Persian folk music piece in the style of an opera. The female vocalist is singing at a high-pitch in a manner that is filled with emotion. There is a piano in the background that occasionally supports the melody. This is a heart-touching piece. This piece could be used in the soundtracks of tragedy/drama movies, especially the ones that take place in the Middle East. It could also be used in a video game to create an aura of suspense and anticipation. 2006-10-18T19:14:45Z darya dadvar A blend of opera and traditional music of Iran,Guilan, Khorasan,... Hotel Negresco, Nice, France, 2003 ["Music", "Opera"] ["persian folk music", "opera", "female vocal", "high-pitch singing", "piano", "emotional", "heart-touching", "goosebumps"] 9 ow7xqVk8Wjs 4668
Ab Tere Bin Hum Bhi Jee Lenge from AURANGZEB This is a soap opera theme music. There is a clarinet playing the main tune with the acoustic guitar and the bass guitar in the backing. There is a melodic pad that can be heard. An acoustic sounding electronic cymbal and wind chimes strokes are playing every now and then. There is a sentimental atmosphere to this piece. 2010-09-16T12:47:18Z AB Shah Ahmad very nice song ["Music", "Sad music"] ["soap opera theme", "acoustic guitar", "clarinet", "bass guitar", "melodic pad", "electronic drums", "chimes", "sentimental", "emotional"] 9 sMNuJy4f4A0 4944
Vagif Bagirov "Segah" This is an Azerbaijani folk music piece. It is an instrumental piece. The only instrument being played is a garmon which has a sound that resembles an accordion. There is a lively atmosphere in the recording. This piece can be played in the soundtrack of a documentary that takes place in the Caucasus region. It could also be used in the soundtrack of an Azerbaijani soap opera. 2008-04-25T07:36:13Z Hal Karim This video was taking by me, Vagif Bagirov one of the proffesional Garmon Maker and he can also play Garmon. ["Traditional music", "Music", "Musical instrument", "Accordion"] ["azerbaijani folk music", "instrumental", "single instrument", "garmon", "lively", "vibrant"] 9 tv14XEQcY0c 5076
Rameau - La Pantomime - Skip Sempé / Olivier Fortin This is a French opera music piece. It is an instrumental piece. There are two harpsichords performing the piece. There is a medieval sound to the piece. It has a dramatic and grandiose feel. This piece could be used in the soundtrack of a movie or a TV series that takes place in the medieval era, especially during scenes of intrigue. 2009-09-30T09:43:52Z Skip Sempé - Capriccio Stravagante - Paradizo Rameau: La Pantomime (1741). Transcribed and arranged for 2 harpsichords by Skip Sempé & Olivier Fortin. Skip Sempé & Olivier Fortin, harpsichords. Harpsichords after 18th century French models by Bruce Kennedy and Patrick Chevalier. Paradizo - From the bonus DVD included with PA0003 (Rameau - La Pantomime) www.paradizo.org International CD and Digital distribution: Outhere Music iTunes: https://itunes.apple.com/fr/album/rameau-la-pantomime/id799190961?l=en ["Harpsichord", "Keyboard (musical)"] ["classical music", "french opera", "instrumental", "harpsichord", "medieval sounding", "dramatic", "grandiose", "intrigue", "fast-paced"] 9 wwbATvWFaLY 5294

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;