musiccaps_details (view)

20 rows where musiccaps_aspects contains "passionate" and musiccaps_names contains "Song"

✎ 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
Bella's Lullaby (with lyrics) A female vocalist sings this pleasant melody. The tempo is slow with a melodic piano accompaniment. There is minimal instrumentation with emphasis on vocals. The song is soft, mellow, soothing, calming, mellifluous, pleasant, and dreamy. This song is a love song, children’s song or a lullaby. 2008-11-30T03:54:32Z Camille Chen Song: Bella's Lullaby Artist: the BELLA CULLEN PROJECT ["Music", "Song", "Lullaby"] ["female vocalist", "slow tempo", "vocal choral harmony", "love song", "children’s song", "calm", "soothing", "gentle", "sound of static", "dreamy", "lullaby", "melodic piano accompaniment", "amplified keyboard", "no percussions", "vocal treat", "synchronous singing", "pleasant", "mellifluous", "romantic", "passionate", "sentimental", "melodic", "simple"] 7 1rhsnmWLeGw 314
VERY POPULAR OLD PAKISTANI PUNJABI SONG SINGER MADAM NOOR JAHAN YouTube The low quality recording features a traditional song that consists of passionate female vocal singing over sustained string melody, wobble bass, wooden percussive elements and shimmering shakers. It is a bit noisy, in mono and it sounds vintage, passionate, emotional and soulful. 2013-06-19T20:26:26Z KHALIQ Husson   ["Singing", "Carnatic music", "Music", "Middle Eastern music", "Song", "Music of Bollywood"] ["wobble bass", "wooden percussive elements", "shimmering shakers", "passionate female vocal", "sustained strings melody", "traditional", "vintage", "noisy", "low quality", "passionate", "emotional", "soulful", "mono"] 4 7_Sr2zv1sQc 862
Chemong ding chu - Janglal Khongsai The Soul song features a passionate male vocal singing over shimmering hi hats and shakers, groovy bass, widely spread wooden percussions, punchy kick and snare hits, wide sustained strings melody and mellow piano melody. It sounds emotional and passionate. 2015-11-12T17:56:14Z Bombiel Media Senorita 3: Thadou-Kuki Visual Album M.Lien Thugs Production ["Music of Asia", "Christian music", "Music", "Song"] ["soul", "passionate male vocal", "wide wooden percussions", "punchy kick", "groovy bass", "wide sustained strings melody", "mellow piano melody", "shimmering hi hats", "punchy snare", "emotional", "passionate"] 4 BiQik0xsWxk 1279
Flamenco en la calle. Cáceres A male singer sings this spirited Latin vocal. The song is fast tempo with slick guitar strumming and percussive guitar accompaniment. The song is romantic and steeped in rich Latin classical music traditions. The song is about a Latin street musician playing folk music. The recording is of average quality. 2016-01-22T12:08:16Z Antonio Lara Arco En pleno casco antiguo de la ciudad... ["Singing", "Flamenco", "Music", "Song", "Vocal music"] ["male singer", "latin singer", "average audio quality", "fast tempo", "groovy tempo", "fast guitar strumming", "guitar accompaniment", "groovy music", "romantic", "emotional", "passionate", "spirited", "passionate singing", "spirited singing", "flamenco guitar", "live performance", "street musician", "passionate music", "traditional latin music", "folk singer", "folk music"] 1 Bx726MYz6Uo 1306
Surrey Harmony - Bohemian Rhapsody The low quality recording features a cover of a rock song sung by harmonizing female choir vocals. The recording is noisy, in mono and it sounds emotional and passionate. 2008-07-02T11:24:33Z Emma Riley Surrey Harmony's Barbershop version of Bohemian Rhapsody, sung in the Sweet Adelines Region 31 Showcase, May 2008. ["Singing", "Song", "Choir", "A capella"] ["low quality", "harmonizing female choir vocals", "emotional", "passionate", "noisy", "mono", "cover", "rock"] 4 FHC7gN3NnX8 1633
The very best of Black Gospel - Hallelujah The low quality recording features a very interactive live performance of a gospel song that consists of crowd harmonized singing and clapping, alongside passionate male vocals and shimmering hi hats which gives it a subtle rhythm. It sounds passionate, energetic and soulful. 2009-12-27T00:04:33Z SissyParker 13.12.2009 The very Best of Black Gospel live at the St. Michael Church in Schweinfurt. Last year it was already awsome but this year it was even greater. A night filled with lots of Feelings and Emotion ["Singing", "Gospel music", "Music", "Song"] ["low quality", "live performance", "passionate male vocal", "crowd harmonized singing", "crowd clapping", "shimmering hi hats", "soulful", "energetic", "passionate", "gospel"] 4 Fg8yzA7zifw 1659
Rhythm of Life - GMEA Honor Chorus The low quality recording features a mixed harmonizing vocals singing over shimmering bells and groovy piano melody. It sounds passionate and euphoric. The recording is noisy. 2008-02-10T22:21:33Z ElleForrest Rhythm of life preformed by the Georgia 11/12 Mixed 6 Honors Chorus. No Copyright intended ["Chant", "Music", "Song", "Choir"] ["low quality", "noisy", "shimmering bells melody", "groovy piano melody", "mixed harmonizing choir", "passionate", "euphoric"] 4 G-5UYGccne4 1683
Demi lovato head voice and whistle register The low quality recording features a compilation of pop songs. The first song features an echoing female vocal sining, alongside wide harmonizing female vocals, over arpeggiated solo electric guitar melody, sustained strings progression, smooth bass, soft kick hits, punchy snare, simple hi hats and shimmering open hat. At the very end of the loop, there is a short snippet of the second song that consists of flat female vocals singing over claps, synth keys melody and punchy kick. It sounds emotional and passionate, even though the mix is bad. 2014-03-08T13:11:42Z Richard Cross Demi lovato head voice whistle register and exclamations. The last one is an F7 not an F8. Follow me on Twitter @Richardtcross ["Singing", "Music", "Song", "Zing"] ["low quality", "pop", "echoing female vocal", "punchy snare", "shimmering open hat", "simple hi hats", "wide harmonizing female vocals", "smooth bass", "arpeggiated electric guitar solo melody", "sustained strings progression", "soft kick", "compilation", "claps", "punchy kick", "flat female vocal", "synth keys melody", "emotional", "passionate", "uplifting"] 4 GHQlBD-6rkA 1707
Céline Dion - Where Does My Heart Beat Now (Official Video) The Pop song features an echoing synth keys melody that consists of a passionate female vocal singing over punchy kick, synth bells melody, echoing synth keys melody and shimmering hi hats. It sounds emotional and passionate. 2013-02-09T22:35:05Z CelineDionVEVO Celine Dion - Where Does My Heart Beat Now (Official Video) Listen on Spotify: http://smarturl.it/Celine_Spotify_EN Listen on Apple Music: http://smarturl.it/Celine_AM_EN Amazon: http://smarturl.it/Celine_Amazon_EN Listen on Deezer: http://smarturl.it/Celine_Deezer Listen on YouTube Music: http://smarturl.it/Celine_YTM Facebook: https://www.facebook.com/celinedion Twitter: https://twitter.com/celinedion Instagram: https://www.instagram.com/celinedion TikTok: https://smarturl.it/CelineDionOnTikTok Lyrics: So much to believe in, we were lost in time Everything I needed I feel in your eyes Always thought of keeping Your heart next to mine But now that seems so far away Don't know how love could leave Without a trace Where do silent hearts go Where does my heart beat now? Where is the sound That only echoes through the night? Where does my heart beat now? I can't live without Without feeling it inside Where do all the lonely hearts go? Candle in the water, drifting helplessly Hiding from the thunder Come and rescue me Driven by hunger Of the endless dream I'm searching for the hand that I can hold I'm reaching for the arms that let me know Where do silent hearts go Where does my heart beat now? Where is the sound That only echoes through the night? Where does my heart beat now? I can't live without Without feeling it inside Where do all the lonely hearts go? Then one touch overcomes the silence Love still survives Two hearts needing one another Give me wings to fly Where does my heart beat now? Where is the sound That only echoes through the night? Where does my heart beat now? I can't live without Without feeling it inside Where do all the lonely hearts go? I've got someone to give my heart to Feel it getting stronger and stronger And stronger And I feel inside Hearts are made to last Until the end of time ["Music", "Song", "Speech", "Soul music"] ["pop", "echoing synth keys melody", "shimmering hi hats", "passionate female vocal", "punchy kick", "synth bells melody", "emotional", "passionate"] 4 Hij_QxDkIJI 1829
Budha Kavacha Stotram | Powerful Navagraha Stotram | Navagraha Mantra The low quality recording features a passionate reverberant female vocal singing over quiet resonating sound. The recording is noisy and it sounds passionate, soulful and cultural. 2011-02-23T08:27:42Z Shemaroo Bhakti Budha Kavacha Stotram | Powerful Navagraha Stotram | Navagraha Mantra The study of NavGraha is made through the planetary influences in Horoscope . The weak graha indicate weak position of various aspects of life like health profession relationships and spiritual journey. The strong planets indicate good progress of the significations ruled by these planets. Some of the NavGraha that is Nine planets act as unfavorable planets for each individual. The influence of unfavorable malefic Graha on other Graha and bhavas houses causes loss to the significations of the houses or Graha. To ease various challenges in life caused by the influence of unfavorable Graha - Graha Shanti measures are suggested. #GayatriMantra #NavagrahaMantra #BudhaKavacha #Stotram #Mantra #Budha #kavach #Mantra #Bhajan #Aarti #devotionalsongs #bhaktisongs #shivmantra #ganeshmantra #hanumanchalisa #saibabasongs #diwali #diwali #diwalisongs #diwalifestival #diwalivideo #festivaloflights #festivalsofindia For popular Mantras, Bhajans, Aartis, Devotional Songs and Darshan SUBSCRIBE to: http://www.youtube.com/user/bhaktison... Sai Devotees can now watch Exclusive Sai Baba videos, Aartis, Bhajans & Chants SUBSCRIBE to - https://www.youtube.com/user/saibhakt... For more Indian Devotional Videos, Click here Divine India: https://www.youtube.com/user/TheDivin... Gurbani: https://www.youtube.com/user/gurbani Like, Comment and Share this video with everyone you love. Connect with us on:- Facebook: https://www.facebook.com/ShemarooBhakti/ Twitter - https://twitter.com/BhaktiDeShakti Pinterest - https://in.pinterest.com/shemaroo/ Google+ - https://plus.google.com/+shemaroo , Sign up for Free and get daily updates on New Videos, exclusive Web Shows, contests & much more http://youtube.shemaroo.com/default.aspx Send us your feedback and suggestions at : connect@shemaroo.com Download ShemarooMe APP for more devotional songs and share it with your friends and Family: https://shemaroome.app.link/eiEEAzHk3W Give a missed call on 18002665151 … ["Bell", "Music", "Song"] ["traditional", "passionate reverberant female vocal", "quiet resonating sound", "noisy", "low quality", "shimmering bells", "passionate", "soulful", "cultural"] 4 JUrYWttZJBM 2012
Chuck Berry and Etta James - Rock N Roll Music The low quality recording features a live performance of a rock & roll song performed by passionate female vocal and male vocal ad libs, followed by groovy piano melody, funky electric guitar melody, groovy bass guitar, shimmering hi hats, punchy snare and soft kick hits. It is a bit noisy and there are some subtle microphone feedback sounds in the middle of the performance. It sounds energetic, vintage and passionate. 2012-03-10T00:09:38Z John1948ThreeA Chuck Berry (Charles Edward Anderson Berry - born Oct. 18, 1926, St. Louis, Mo., U.S.) singer, songwriter, and guitarist who was one of the most popular and influential performers in rhythm-and-blues and rock-and-roll music in the 1950s, '60s, and '70s. Raised in a working-class African-American neighbourhood on the north side of the highly segregated city of St. Louis, Berry grew up in a family proud of its African-American and Native-American ancestry. He gained early exposure to music through his family's participation in the choir of the Antioch Baptist Church, through the blues and country-western music he heard on the radio, and through music classes, especially at Sumner High School. Berry was still attending high school when he was sent to serve three years for armed robbery at a Missouri prison for young offenders. After his release and return to St. Louis, he worked at an auto plant, studied hairdressing, and played music in small nightclubs. Berry traveled to Chicago in search of a recording contract; Muddy Waters directed him to the Chess brothers. Leonard and Phil Chess signed him for their Chess label, and in 1955 his first recording session produced Maybellene (a country-and-western-influenced song that Berry had originally titled Ida Red), which stayed on the pop charts for 11 weeks, cresting at number five. Berry followed this success with extensive tours and hit after hit, including Roll Over Beethoven (1956), School Day (1957), Rock and Roll Music (1957), Sweet Little Sixteen (1958), Johnny B. Goode (1958), and Reelin' and Rockin' (1958). His vivid descriptions of consumer culture and teenage life, the distinctive sounds he coaxed from his guitar, and the rhythmic and melodic virtuosity of his piano player (Johnny Johnson) made Berry's songs staples in the repertoire of almost every rock-and-roll band. At the peak of his popularity, federal authorities prosecuted Berry for violating the Mann Act, alleging that he transported an underage female across state lines for immoral purposes. After tw… ["Singing", "Music", "Pop music", "Rock music", "Ska", "Song", "Rock and roll"] ["low quality", "male vocal ad libs", "passionate female vocal", "shimmering hi hats", "punchy snare", "soft kick", "groovy bass guitar", "funky electric guitar melody", "groovy piano melody", "rock & roll", "live performance", "subtle microphone feedback", "noisy", "energetic", "passionate", "vintage"] 4 QZoclbefgak 2628
Pig Rock - อ่าง (SD Version) A male singer sings this melodic pop song. The tempo is fast with an acoustic guitar accompaniment, keyboard harmony, enthusiastic electric guitar melody and intense drumming. The vocals are emphatic and the song is pleasant, catchy, melodious, youthful, buoyant and fresh. This song is Soft Rock/ Pop. 2010-02-07T21:32:43Z PigRockBand PIG ROCK - Arng : The first official music video of new Thais rock band named PIG ROCK. Their first album will be launched in March, 2010. For more info please visit www.sabarnrecords.com Music Video Director / Cinematographer : Sornpat Prakaranunt ["Music", "Punk rock", "Independent music", "Song"] ["male vocalist", "bright electric guitar", "buoyant", "soft rock", "teen pop", "pop hit", "youtube video", "melodious acoustic guitar rhythm", "keyboard accompaniment", "pleasant", "teen pop", "love song", "passionate", "emotional", "enthusiastic vocals", "energetic drumming"] 7 QutCXtWmzIs 2649
Chiquilla. Interpretacion GRUPO FREE SOUNDS de Ensenada, BC The low quality recording features a live performance of a regional Mexican song and it consists of passionate male vocal singing over groovy bass guitar, mellow synth keys melody and electric guitar melody, followed by shimmering tambourine, hi hats and punchy kick. It sounds passionate, emotional and soulful - like something you would hear at family gathering events. 2012-04-20T18:44:22Z victor lopez PRESENTACION EN EL PROGRAMA LA VELADA DE SINTESIS TELEVISION TIJUANA (DERECHOS RESERVADOS) DEL GRUPO MUSICAL FREE SOUNDS DE ENSENADA, BC ["Christmas music", "Gospel music", "Music", "Song"] ["low quality", "live performance", "regional mexican", "passionate male vocal", "groovy bass guitar", "soft synth keys melody", "shimmering tambourine", "punchy kick", "electric guitar melody", "noisy", "passionate", "emotional", "soulful", "shimmering hi hats"] 4 RNwiEsjrhiQ 2694
Dale Maraca - ABS in Zumba Dance Class with ART ( Mo Betta ) A male singer sings this Latin dance tune. The song is medium tempo with trumpets, latin percussions; medium drumming rhythm, keyboard harmony and guitar accompaniment. The song is exciting and groovy. The audio quality is poor and is played for work out exercise. 2009-12-21T09:41:49Z 19mobetta06 Great song for ab work. Pull stomach in and use your hips in circular motion not so much work with the shoulders. www.CardioAssassin.com ["Music", "Song", "Maraca"] ["ambient room noise", "poor audio quality", "gym music", "zumba dance hits", "trumpets", "guitar accompaniment", "latin percussion", "strong bass line", "latin dance hits", "workout playlist", "passionate", "spirited", "adrenaline rush", "male singer", "latin dance music", "exercise class", "zumba music", "medium tempo", "groovy music"] 1 Sj5MQtqDw8Y 2783
Solomon Burke performs Rock and Roll Hall of Fame Inductions 2001 The low quality recording features a live performance of a rock song and it consists of passionate male vocal singing over energetic drums, funky bass guitar, electric guitar melody and solo brass melody. At the end of the loop, there is a short snippet of choir singing in harmony. Overall it sounds funky, energetic, soulful and passionate - as a live performance should sound. 2010-12-07T18:15:11Z Rock & Roll Hall of Fame Solomon Burke performs Rock and Roll Hall of Fame Inductions 2001 Visit us! http://rockhall.com/ Subscribe to RockHall : http://www.youtube.com/subscription_center?add_user=rockhall Facebook: http://www.facebook.com/rockandrollhalloffame Twitter: http://twitter.com/rock_hall Google +: http://plus.google.com/u/0/115412030406922618012 Check out all the inductees: http://rockhall.com/inductees/ Upcoming events: http://rockhall.com/events/ ["Singing", "Music", "Rock music", "Song", "Rock and roll", "Yell"] ["rock", "low quality", "live performance", "passionate male vocal", "choir", "solo brass melody", "funky bass guitar", "energetic drums", "electric guitar melody", "energetic", "soulful", "passionate", "funky"] 4 VfARCp38XtA 3018
Top 30 Indie Folk and Acoustic (Playlist #5) The low quality recording features an indie folk song that consists of wide harmonizing male vocals and acoustic rhythm guitar. In the second half of the loop, the lead female vocal appears, creating a perfect harmony with the previously mentioned male vocals. It sounds passionate, emotional and sad. 2014-02-28T23:48:23Z Indie & Folky Me Indie Folk Playlist of march 2014 by the Indie and Folky Me Team Website: http://IndieFolkyMe.tk Follow us on twitter : @IndieFolkyMe Join us on facebook : https://www.facebook.com/IndieFolkyMe Photo by Antsa Rvl (Fickr) : http://www.flickr.com/people/10663187... Go here to watch the EXCLUSIVE Top 20 Indie Pop Charts : http://t.co/Isqtvo2FQ5 TRACKLIST Fall At Your Feet - Boy & Bear Just For Now - Cloud Control Where We Gonna Go From Here - Mat Kearney More Than Life - Whitley Message - Xavier Rudd Big Black Car - Gregory Alan Isakov Wolves - The Accidental Something Better - Ecclectic Approach Horses - The Be Good Tanyas Follow Fires - Matthew & The Atlas Move mountains - Roo Panes Without You - Keith Urban Night Bus - Lucy Rose David - Noah Gundersen The Romance Of Wolves - Roma Di Luna Send Me On My Way - Rusted Root Stereo Heart - Collin Mcloughlin Willow Tree March - THe Paper Kites Where Is My Mind - Tramped By Turtles Girl - Lovedrug Riverbanks - Charlie Simpson Sunday best - Augustana The Story I Heard - Blind Pilot Karen O - The Moon Song People - Sharon Nutzati Hidden Edelweiss - Spark Alaska Always Remember Me - Ry Cuming ft Sara Bareilles Worry - Rhodes Rosemary - Ghost & Gale Sons & Daughters - Allman Brown ft Liz Lawrence Bonus: I Lived - One Republic * 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." ["Folk music", "Acoustic guitar", "Music", "Independent music", "Song", "Strum", "Plucked string instrument"] ["low quality", "wide harmonizing male vocals", "indie folk", "acoustic rhythm guitar", "lead female vocal", "passionate", "emotional", "sad"] 4 hTlIqICkbW8 4110
Jakes List Jun 2012 Top 10 Independent Music Video Uploads Male and female singers sing this vocal harmony. The song is medium tempo with a groovy bass-line, keyboard accompaniment, guitar rhythm and a steady drumming rhythm with clapping percussions. The song is exciting and groovy. The song is a classic pop hit cover with an average quality sound. 2012-06-30T22:34:02Z Jake Niall Foster The top 10 music video uploads for the month of June 2012 (with a cut-off date of 22 Jun) for Independent and Unsigned artists. ["Singing", "Music", "Independent music", "Pop music", "Song"] ["male singer", "backup singers", "female singers", "clapping percussions", "groovy bass line", "medium tempo", "guitar accompaniment", "keybiard accompaniment", "song cover", "home studio", "average audio quality", "hissing vocals", "spirited", "passionate", "dance rhythm", "groovy rhythm", "life lessons", "motivational", "inspiring", "retro pop hits"] 1 lR8am4rK7qQ 4395
UNAM Choir - Ba Nyorilweng (Song of Prayer) The low quality recording features passionate harmonizing choir vocals, alongside fruity male vocals. It sounds passionate, traditional and joyful. The recording is noisy and in mono. 2011-12-02T23:42:18Z GT Choir Ongwediva The UNAM (University of Namibia) Choir performing at the UNAM Northern Campus during the October 2011 Northern Namibia Choral Extravaganza. ["Gospel music", "Music", "Song", "Choir", "A capella"] ["low quality", "mono", "noisy", "passionate harmonizing choir vocals", "fruity male vocal", "traditional", "joyful", "passionate"] 4 rizanOQM61k 4897
Ghadoli Bhar Aayee Aan | Geet Shagna De | Punjabi Marriage Ceremony Songs | Popular Wedding Music The low quality recording features a traditional song sung by harmonizing female vocals and followed by wooden percussion, short flute licks and mellow piano chords. It sounds addictive and passionate. 2012-03-18T14:50:28Z Catrack Entertainment This Song/Boliyan represents the Rich Punjabi Culture and Music and is Part of Rituals in every Traditional Punjabi Wedding Ceremony whether it takes place in a Village of Punjab (India) or Anywhere in the World. These Folk / Marriage Songs are integral part of Punjabi Culture and have various forms of Song & Dance like Tappe, Bolian, Gidha, Bhangra and Sithniyan. These are also called Shagna De Geet. . All Punjabi Songs / Punjabi Music By Catrack is Available On I-Tunes, Spotify, Rhapsody, Nokia, emusic, Google Music, Amazon & Sound Cloud. Subscribe to Catrack's Youtube Channel http://www.youtube.com/subscription_center?add_user=catrackentertainment Join Us On Facebook http://www.facebook.com/CatrackOfficial Twitter https://twitter.com/catrack Google+ https://plus.google.com/112539272523400923462/ For Any Content, Advertising, or Marketing Related Queries for All our Platforms, including Heeroz OTT, Kindly Visit: http://www.catrack.com ["Singing", "Folk music", "Music", "Wedding music", "Middle Eastern music", "Song"] ["low quality", "traditional", "harmonizing female vocals", "wooden percussions", "short flute licks", "addictive", "mellow piano chords", "passionate"] 4 ucSF9NIxK8A 5128
La Maraca A male Latin singer sings this energetic vocal with male backup singers in vocal harmony. The song is fast tempo with quick Latin percussions, groovy bass line, keyboard accompaniment and trumpets blaring. The song is energetic and passionate. The song has poor audio quality. 2008-04-10T19:01:41Z adonismasgozadera AdonisGozadera.com ["Music", "Song", "Salsa music", "Maraca"] ["male latin singer", "backup singers", "screaming vocals", "rapping vocals", "street music", "fast tempo", "poor audio quality", "piano accompaniment", "latin percussions", "percussive bass line", "fast drumming rhythm", "energetic", "youthful", "romantic", "love performance", "brass band", "trumpets blaring", "groovy", "passionate", "latin dancers", "latin dance rhythm"] 1 zNSV9GkpRfM 5468

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;