musiccaps_details (view)
17 rows where search matches "guitar", musiccaps_aspects contains "emotional", musiccaps_aspects contains "romantic" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 179 ✖
- emotional · 17 ✖
- romantic · 17 ✖
- sentimental 11
- medium tempo 8
- slow tempo 8
- mellow 7
- passionate 7
- acoustic guitar 6
- love song 6
- groovy bass line 5
- keyboard harmony 5
- male singer 5
- male vocalist 5
- soft 5
- country pop 4
- melancholic 4
- melodious 4
- fiddle 3
- instrumental 3
- keyboard accompaniment 3
- mandolin 3
- pop 3
- regional pop 3
- rhythmic acoustic guitar 3
- simple melody 3
- steady drumming 3
- acoustic guitar accompaniment 2
- auto harp 2
- bass guitar 2
- calm 2
- cello 2
- country hits 2
- country song 2
- dreamy 2
- duet 2
- dulcet 2
- electric guitar 2
- fingers snapping 2
- first love 2
- folk music 2
- foreign language 2
- intense drumming 2
- live performance 2
- mellifluous 2
- melodic 2
- minimalist 2
- nostalgic 2
- pleasant 2
- poignant 2
- r&b 2
- soft pop 2
- violin harmony 2
- acousitc guitar 1
- acoustic 1
- acoustic guitar melody 1
- african 1
- alternative metal 1
- alternative rock 1
- amateur recording 1
- ambient music 1
- ambient sounds 1
- atmospheric 1
- auditorium acoustics 1
- banjo 1
- bass guitar accompaniment 1
- beautiful 1
- blues 1
- blues lessons 1
- bongos 1
- buskers 1
- busking 1
- cajun percussion 1
- captivating 1
- charming 1
- classic pop 1
- classical 1
- colourful 1
- congas 1
- contrast song fade 1
- country folk song 1
- country love song 1
- country music 1
- country song hits 1
- crowd chatter 1
- dance groove 1
- dance music 1
- dissonant harmony 1
- dissonant tambourine beats 1
- dobro 1
- earnest 1
- electric guitar lead 1
- electric guitar lesson 1
- electric guitar rhythm 1
- elvis presley 1
- energetic drumming 1
- enthusiastic 1
- euphonious 1
- female backup 1
- female singer 1
- female vocalisation 1
- female vocalist 1
- fog horn 1
- folk pop 1
- gentle 1
- groovy 1
- guitar lead 1
- guitar solo 1
- indonesian pop 1
- inferior sound quality 1
- jazz 1
- k-pop 1
- k-pop hits 1
- keyboard accomapniment 1
- korean pop 1
- male voice speaking 1
- medium fast tempo 1
- mellow acoustic guitar 1
- mellow guitar 1
- mesmerising 1
- muffled sounds 1
- muffled vocals 1
- nostalgia 1
- peaceful 1
- pensive 1
- performance 1
- pleasant melody 1
- pop hits 1
- proposal song 1
- reggae 1
- resonator 1
- rock 1
- sad 1
- salsa music 1
- sentimental nostalgic 1
- serene 1
- simple 1
- simple groove 1
- soft acoustic guitar accompaniment 1
- soft keyboard harmony 1
- soft melodious 1
- somber 1
- song climax 1
- song cover 1
- song fade 1
- soothing 1
- soul 1
- sound of horn 1
- story telling 1
- straight bass lines 1
- straight drumming 1
- string harmony 1
- string instrument 1
- string instruments 1
- string orchestra 1
- subtle bass line 1
- super imposed male voice 1
- sweet 1
- synth arrangement 1
- synth arrangements 1
- synthesiser 1
- synthesiser arrangements 1
- synthesiser articulation 1
- tambourine 1
- tambourine beats 1
- ukelele 1
- unplugged 1
- vigorous introduction 1
- viola 1
- violin 1
- violins 1
- vivacious 1
- vivid 1
- vocalisation 1
- warm 1
- wedding song 1
- western classical 1
- wistful 1
- world music 1
- youthful 1
musiccaps_names (array) 25 ✖
- Music 17
- Singing 4
- Soul music 3
- Blues 2
- Guitar 2
- Musical instrument 2
- Plucked string instrument 2
- Reggae 2
- Sad music 2
- Wedding music 2
- /t/dd00004 1
- Christmas music 1
- Country 1
- Exciting music 1
- Funk 1
- Grunge 1
- Happy music 1
- Mandolin 1
- Music of Africa 1
- Rhythm and blues 1
- Song 1
- Strum 1
- Tender music 1
- Tick 1
- Ukulele 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Pumped up Kicks Jazz Style | A male vocalist sings this mellow country song. The tempo is medium with fiddle, cello and viola harmony with acoustic guitar rhythm.The song is mellow, soft, dulcet,emotional , melancholic and nostalgic . This song is Country Pop. | 2013-07-10T00:12:19Z | Red Soda Band | A jazz style cover of Pumped up Kicks by Foster the People. This is quite a controversial tune but has been very popular for a long time which is why we recorded a cover version of it. Pumped Up Kicks Lyrics (Foster the People) Robert's got a quick hand. He'll look around the room, he won't tell you his plan. He's got a rolled cigarette hanging out his mouth, he's a cowboy kid. Yeah, he found a six shooter gun in his dad's closet hidden with a box of fun things. And I don't even know what but he's coming for you, yeah, he's coming for you. [Chorus 2x:] All the other kids with the pumped up kicks you better run, better run, outrun my gun. All the other kids with the pumped up kicks you better run, better run faster than my bullet. Dad -- he works a long day. He'll be coming home late, he's coming home late. And he's bringing me a dark surprise. 'Cause dinner's in the kitchen and it's packed in ice. I've waited for a long time. Yeah, the sleight of my hand is now a quick-pull trigger. I reason with my cigarette And say, "Your hair's on fire, you must have lost your wits, yeah." [Chorus 2x:] All the other kids with the pumped up kicks you better run, better run, outrun my gun. All the other kids with the pumped up kicks you better run, better run faster than my bullet. Ru-ru-run, run, run, run [4x] [Whistling] [Chorus 4x:] All the other kids with the pumped up kicks you better run, better run, outrun my gun. All the other kids with the pumped up kicks you better run, better run faster than my bullet. Live Wedding Band: https://redsoda.com Wedding Entertainment: https://www.facebook.com/RedSodaBand/ Wedding Singers: https://www.instagram.com/redsodaband/ Sydney Wedding Band: https://www.google.com/maps/place/Red+Soda+Band+Sydney/@-33.9118834,151.1329694,15z/data=!4m2!3m1!1s0x0:0xb2508b5ae82a53cf?sa=X&ved=2ahUKEwjuvcT3pbbwAhXpwjgGHVUtCfMQ_BIwGHoECCMQBQ Phone: 02 8006 2234 | ["Music", "Wedding music"] | ["male singer", "medium tempo", "violin", "country music", "sentimental", "melancholic", "string orchestra", "string harmony", "country folk song", "country hits", "country pop", "regional pop", "fiddle", "cello", "viola", "acoustic guitar", "dulcet", "mellifluous", "mellow", "emotional", "romantic", "dreamy", "sentimental nostalgic", "story telling", "performance"] | 7 | 40xkia7fwEM | 534 | |
Kim Jaejoong MUSIC QUIZ | A male vocalist sings this mellow pop. The tempo is slow in contrast to the enthusiastic introductory bit in this section. The song is soft, mellow, emotional, repetitive, melancholic, nostalgic and passionate with a soft acoustic guitar accompaniment. This could be a song fade. This song is a Korean Pop/K-Pop song. | 2016-03-30T01:17:32Z | JaejoongArabFansC3 | Website: http://jaejoongarabfans.com/ Facebook: https://www.facebook.com/JaejoongArabFans Twitter: https://twitter.com/JaejoongArabFan | ["Music", "Tender music"] | ["male vocalist", "slow tempo", "vigorous introduction", "synthesiser arrangements", "contrast song fade", "soft acoustic guitar accompaniment", "korean pop", "k-pop", "k-pop hits", "mellow guitar", "song fade", "love song", "romantic", "emotional", "passionate", "mellow", "soft", "calm"] | 7 | 4i1aizhCnfg | 596 | |
Breaking Benjamin Burnley GIVE ME A SIGN House of Blues Atlantic City, NJ 7/10/10 | A male vocalist sings this passionate song. The tempo is slow with emphatic vocals and an acoustic guitar accompaniment. The song is melodic, emotional,sentimental, passionate,pensive, reflective and deep. This song is Alternative Rock. | 2010-07-11T17:28:56Z | Christopher Kline | Ben Burnley of Breaking Benjamin performed a solo acoustic show at The House of Blues in Atlantic City, NJ on July 10th. Joining him onstage playing guitar and providing backup vocals was Aaron Bruch of Ourafter. | ["Blues", "Music"] | ["male vocalist", "medium tempo", "rock", "alternative rock", "alternative metal", "acoustic guitar accompaniment", "minimalist", "live performance", "ambient sounds", "auditorium acoustics", "romantic", "love song", "passionate", "emotional", "sentimental"] | 7 | 9ogEGxsJcSY | 1043 | |
Country Top 10 Wedding Slow Songs - Twin Cities Wedding DJs MN | This song is a romantic duet. The tempo is medium with a plethora of instruments like the auto harp, fiddle, acoustic guitar, electric guitar, bass guitar, banjo,intense drumming, cello, violin harmony and vocal harmony. The song is a romantic, charming,emotional, passionate love song. The instrumentation style and music decibels indicate that this is the climax of a country love song. | 2011-07-01T05:49:25Z | TwinCities WeddingDJs | Top Ten Country slow songs. Twin Cities Wedding DJs MN. http://www.twincitiesweddingdjs.com These are the Top Ten Country slow songs for wedding receptions and company parties. *** The edited material is briefly referenced for educational purposes *** | ["Singing", "Country", "Music"] | ["duet", "medium tempo", "country song", "fiddle", "auto harp", "song climax", "country love song", "first love", "wedding song", "proposal song", "banjo", "mandolin", "acoustic guitar", "intense drumming", "keyboard harmony", "cello", "violins", "electric guitar", "bass guitar", "love song", "romantic", "passionate", "emotional", "country song hits", "country pop", "folk music"] | 7 | AagemOzvoZE | 1141 | |
Michael ofori ogyegyentwie ghana gospel music | A male vocalist sings this sweet melody in a foreign language. The tempo is medium with keyboard accompaniment, steady drumming, synthesiser arrangement and acoustic guitar. The song has a simple, easy melody. It is earnest, emotional, calm and soothing. This song is a Regional Pop song. | 2009-04-20T09:40:57Z | gimwhp | Michael Ofori, Ghanaian born live in the United States. Singer of Gospel music. | ["Music of Africa", "Funk", "Music", "Reggae", "Rhythm and blues", "Soul music", "Exciting music"] | ["male singer", "medium tempo", "foreign language", "world music", "keyboard accompaniment", "steady drumming", "straight bass lines", "synth arrangements", "african", "melodic", "calm", "simple groove", "acoustic guitar", "romantic", "emotional", "peaceful", "serene"] | 7 | D3FyfFIKLVc | 1430 | |
"And I love You So" - ( Elvis Presley and Gigliola Cinquetti ) | A female vocalist sings this romantic love song. The tempo is slow with a melodic violin harmony, groovy bass line, rhythmic acoustic guitar and keyboard accompaniment. The song is soft, mellow, romantic, emotional, sentimental, melancholic and gentle. This. The song is a cover of a Classic Elvis Presley song. | 2012-06-11T17:01:57Z | LeCommedieDellArte | "And I love You So" - ( Elvis Presley and Gigliola Cinquetti ) (Songwriters: MCLEAN, DON ) And I love you so, The people ask me how, How I've lived till now I tell them I don't know I guess they understand How lonely life has been Life began again The day you took my hand And yes I know how lonely life can be The shadows follow me And the night won't set me free But I don't let the evening get me down Now that you're around me And you love me too Your thoughts are just for me You set my spirit free I'm happy that you do The book of life is brief Once the page is read All but love is dead This is my belief And yes I know how lonely life can be The shadows follow me And the night won't set me free But I don't let the evening get me down Now that you're around me | ["Music", "Sad music"] | ["female singer", "slow tempo", "violin harmony", "song cover", "elvis presley", "love song", "sentimental", "emotional", "melancholic", "melodious", "groovy bass line", "keyboard accomapniment", "romantic", "passionate", "rhythmic acoustic guitar"] | 7 | Inuq5W98ktA | 1942 | |
Dan Nguyen va Cat Tien hat Loi To Tinh De Thuong | A male vocalist sings this pop song. The tempo is medium with keyboard accompaniment ,steady drumming, groovy bass, congas and bongos percussion and acoustic guitar accompaniment with vocal backup. The sound quality of the audio is inferior and there is the sound of chatter in the background .The song is fresh, simple, breezy, romantic, passionate, sentimental and youthful with a dance groove. This song is Regional Pop. | 2015-07-28T01:31:19Z | Oanh Nguyen | ["Singing", "Music", "Wedding music"] | ["male vocalist", "medium tempo", "female backup", "soft pop", "dance groove", "dance music", "muffled sounds", "crowd chatter", "salsa music", "keyboard harmony", "congas", "bongos", "bass guitar", "intense drumming", "acousitc guitar", "muffled vocals", "inferior sound quality", "foreign language", "regional pop", "passionate", "emotional", "romantic", "enthusiastic"] | 7 | JWNWCKdfpzM | 2015 | ||
Blues Guitar Lesson Larry Carlton @ Videoguitarlessons.com | This music is instrumental , the tempo is slow with an electric guitar lead and a strong bass guitar accompaniment. The music is assertive and emphatic but sounds sad, melancholic,nostalgic, romantic , wistful and sentimental. This music is Blues Harmony. | 2008-03-20T18:05:26Z | eikohtiek | This is a blues jam that Larry did for my favorite website. A little taste of what kinds of things you can learn from his course. Larry is a master of Blues, Jazz, and fusion. He's played on some of your favorite Rock and Roll tracks too such as Steely Dan's, "Kid Charlemagne," He has shared studios and stages with the like of The Crusaders, Joni Mitchell, Sammy Davis Jr., Quincy Jones, John Lennon, Jerry Garcia, Michael Jackson, Stanley Clark, Billy Cobham, Bobby Bland, and many more. He also plays in the group Fouplay with Nathan East, Bob James, and Harvey Macon. I have taken these lessons and they really show you how to phrase well and make every note count. | ["Blues", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["instrumental", "slow tempo", "electric guitar lead", "melancholic", "nostalgia", "sad", "wistful", "romantic", "sentimental", "emotional", "bass guitar accompaniment", "groovy", "blues", "r&b", "jazz", "dissonant harmony", "melancholic", "somber", "blues lessons", "electric guitar lesson", "simple melody"] | 7 | NlUf1ppoSG4 | 2359 | |
Walking On Cars - Tick Tock (acoustic) 4.2.16 | A male vocalist sings this soft pop. The tempo is slow with a simple piano accompaniment, mellow acoustic guitar and rhythmic Cajun beats. The song is a simple, unaffected, romantic, melodic, sentimental, emotional and pensive Pop. | 2016-02-05T11:40:49Z | Kerri Loughney | Walking On Cars performing an acoustic version of Tick Tock from their new album Everything This Way. Performed in Banquet Records, Kingston for the album release on the 4th of February 2016. Enjoy! Check out my other videos from the Walking On Cars acoustic in-store show at Banquet Records: Always Be With You - https://www.youtube.com/watch?v=FG-wYSnmEwo Hand In Hand - https://www.youtube.com/watch?v=oaEMyV_dOXw Flying High Falling Low - https://www.youtube.com/watch?v=6M6AcVAQJMI Catch Me If You Can - https://www.youtube.com/watch?v=6nhEE5NpglQ Speeding Cars - https://www.youtube.com/watch?v=1YDNRlYRahs Plus check out Banquet's videos from the night! In-store - https://www.youtube.com/watch?v=aid6nk5I5Bw New Slang - https://www.youtube.com/watch?v=e-WkwnHWUJE | ["Music", "Tick"] | ["male vocalist", "slow tempo", "acoustic", "minimalist", "busking", "buskers", "simple", "earnest", "emotional", "sentimental", "keyboard accompaniment", "mellow acoustic guitar", "cajun percussion", "soft", "melancholic", "romantic", "pensive", "unplugged", "amateur recording"] | 7 | UDN11Q90Fa4 | 2895 | |
MAYA AND SIR CHIEF'S LOVE STORY PART 2 August 2012 Episodes | This music is instrumental. The tempo is slow with an emphatic violin harmony, keyboard accompaniment and rhythmic acoustic guitar with female vocalisation. The song is romantic, sentimental, emotional, nostalgic, poignant, charming, dreamy and soft. | 2012-12-16T04:10:01Z | yean Sagala | ["Music", "Sad music"] | ["instrumental", "slow tempo", "vocalisation", "female vocalisation", "charming", "dreamy", "poignant", "colourful", "warm", "keyboard accompaniment", "violin harmony", "acoustic guitar", "mellow", "soft", "romantic", "emotional", "sentimental"] | 7 | WNmAlKrAPjQ | 3089 | ||
Lie To Me opening theme - Music - Ryan Star - Brand New Day | A male vocalist sings this melodic pop song.The tempo is medium with energetic drumming, keyboard harmony, groovy bass lines, electric guitar harmony, acoustic guitar rhythm and dissonant tambourine beats. The is soft, calming, mellow, sentimental, emotional and nostalgic. This song is Pop Rock/Soft Rock. | 2009-04-17T03:37:09Z | Ricardo Miranda | Clipe da musica de abertura do seriado Lie To Me (Ryan Star - Brand New Day) Hello to all the video was made is not official Fan to Fan Olá a todos o video não é oficial foi feito de Fã para fã Os gráficos são baixos o vídeo foi feito com vários outros vídeos disponíveis no YT | ["Music", "Grunge"] | ["male vocalist", "medium tempo", "energetic drumming", "groovy bass line", "synth arrangement", "keyboard harmony", "electric guitar rhythm", "dissonant tambourine beats", "sweet", "melodious", "mellow", "romantic", "emotional", "sentimental", "nostalgic", "poignant", "acoustic guitar accompaniment"] | 7 | l9vYSBR9nio | 4377 | |
Missing from YouTube | A male vocalist sings this soft melody. The tempo is medium with smooth guitar, keyboard harmony, steady bass slide and synthesiser arrangements. The song is mellow, romantic, emotional, soothing; ambient. There is a hooting sound like a fog horn with a male voice talking over the song. This song is a R&B/Soul song. | ["Music", "Reggae", "Song"] | ["male singer", "slow tempo", "sound of horn", "fog horn", "super imposed male voice", "romantic", "emotional", "soothing", "pleasant", "r&b", "soul", "acoustic guitar", "keyboard harmony", "synthesiser articulation", "fingers snapping", "groovy bass line", "male voice speaking", "reggae", "soft melodious"] | 7 | 4427 | |||||
Viggo Mortensen - Breathe A Sigh | A male vocalist sings this dulcet melody. The tempo is soft with acoustic guitar, resonator, fiddle, mandolin, banjo, dobro and auto harp accompaniment, steady drumming, tambourine beats , fingers snapping and funky bass lines. The song is soft, mellow, dulcet, emotional, sentimental, soothing , pleasant and simple. The song is Country Pop. | 2007-07-08T11:59:56Z | athelas51 | Again with my favorite Def Leppard's song. | ["Music", "Soul music"] | ["male singer", "slow tempo", "groovy bass line", "dulcet", "fingers snapping", "tambourine", "simple melody", "auto harp", "fiddle", "resonator", "dobro", "mandolin", "steady drumming", "soft", "mellow", "love song", "romantic", "passionate", "sentimental", "emotional", "country song", "country pop", "regional pop", "mellow", "pleasant melody"] | 7 | mJuJfKbcJcw | 4459 | |
Mandolin Orange - Wake Me @Pickathon 2014 On The Farm | This song is a pleasant love song duet. The tempo is medium with acoustic guitar and ukulele accompaniment.the song is mellow, soft, emotional, romantic, nostalgic. This song is Country/Folk pop. | 2015-01-29T23:15:41Z | Pickathon | http://pickathon.com/ Presents Mandolin Orange live at Pendarvis Farm. Filmed on August 2, 2014 Channel Host: http://Grist.org Song: Wake Me Record Label: http://www.redeyeusa.com/ Producer: Ryan Stiles Executive Producer: Zale Schoenborn Associate Producer: Eric Schoenborn, Terry Groves, Ned Failing, John MacArthur Production Manager: Seth Chandler Production Coordinator: Alisha Flaumenbaum Editor: Stephanie Manzo Camera: Emilee Booher Audio/Co-Producer: Dylan McNab http://www.mandolinorange.com/ http://pickathon.com | ["Singing", "Music", "Mandolin", "Ukulele"] | ["duet", "medium tempo", "ukelele", "folk pop", "folk music", "mellifluous", "simple melody", "country pop", "country hits", "string instruments", "folk music", "acoustic guitar", "mandolin", "melodious", "pop", "country pop", "mellifluous", "romantic", "emotional", "sentimental", "soft", "mellow"] | 7 | n1fY-23ffl0 | 4513 | |
Fur Elise on classical guitar performed by Eddie Blatt | This music is instrumental. The tempo is slow with a melodic acoustic guitar solo. The music is soft, euphonious, dreamy, romantic , warm ,ambient and soothing. This is a Classical acoustic instrumental. | 2007-01-23T06:40:15Z | Eddie Blatt | Eddie Blatt plays Fur Elise on classical guitar live at the Byron Bay Community Centre. | ["Guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["instrumental", "slow tempo", "acoustic guitar melody", "western classical", "classical", "beautiful", "mellow", "euphonious", "captivating", "mesmerising", "guitar solo", "guitar lead", "string instrument", "live performance", "gentle", "emotional", "atmospheric", "ambient music", "romantic"] | 7 | p2sXdmex3xQ | 4683 | |
Arnel Pineda in AMO, 1988, singing "Lights" by Journey | A male vocalist sings this soft melody. The tempo is slow with a mellow keyboard harmony, steady drumming, subtle bass line and acoustic guitar accompaniment. The song is soft, romantic, melodic, emotional , sentimental, melancholic and pleasant. This song is classic Soft Rock. | 2008-03-22T11:10:43Z | ArnelPinedaFan | Audio only. Arnel Pineda with AMO, performing live "Lights" (originally by Journey) in 1998, almost 20 years before he became Journey's lead singer. Photos from Arnel's "journey" accompany the video. NOTE: Sorry I can't approve non-English comments because I don't understand them. | ["Singing", "Music", "Soul music", "/t/dd00004"] | ["male singer", "medium tempo", "soft keyboard harmony", "steady drumming", "subtle bass line", "rhythmic acoustic guitar", "romantic", "pleasant", "soft pop", "pop", "pop hits", "romantic", "sentimental", "emotional", "nostalgic", "melodic"] | 7 | thHSYzhoLo4 | 5057 | |
Ten2Five - My World Is Full With You | A female vocalist sings this beautiful pop melody. The tempo is medium fast with rhythmic acoustic guitar, keyboard harmony, electric guitar melody, straight drumming;steady bass and tambourine beats. The song is mellow, sweet, passionate,emotional, youthful, romantic, simple and tender. This song is a hit Indonesian Pop. | 2012-10-13T23:03:56Z | Xily Gina | Indonesian indie band | ["Christmas music", "Music", "Happy music"] | ["female vocalist", "medium fast tempo", "pop", "straight drumming", "classic pop", "passionate", "emotional", "romantic", "first love", "indonesian pop", "melodious", "rhythmic acoustic guitar", "electric guitar", "groovy bass line", "keyboard harmony", "tambourine beats", "synthesiser", "vivid", "vivacious", "youthful", "love song", "emotional", "sentimental"] | 7 | zTtZH-Q61Ik | 5480 |
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;