musiccaps_details (view)
19 rows where musiccaps_aspects contains "slow tempo" and musiccaps_aspects contains "string section"
This data as json, CSV (advanced)
musiccaps_aspects (array) 78 ✖
- slow tempo · 19 ✖
- string section · 19 ✖
- no voices 7
- instrumental 6
- orchestral 4
- bass 3
- female voice singing 3
- oboes 3
- acoustic piano 2
- amateur recording 2
- cinematic 2
- classical 2
- classical music 2
- dramatic 2
- female voice 2
- horn 2
- horn section 2
- no percussion 2
- orchestra 2
- orchestra music 2
- percussion 2
- romantic theme 2
- soothing 2
- symphonic song 2
- violins 2
- 50s/60s ballad 1
- acoustic guitar 1
- background noise 1
- background whispering 1
- backing vocal harmony 1
- ballad/pop 1
- bells 1
- calming 1
- cello 1
- chainsaw 1
- cinematic/orchestral 1
- classical song 1
- cruel sounding 1
- dark 1
- deep 1
- eerie music 1
- epic mood 1
- fantasy song 1
- flutes 1
- game lobby music 1
- heroic 1
- hissing sound 1
- jazz 1
- keyboard 1
- low percussive hit 1
- low quality recording 1
- male deep voice screaming/crying 1
- melancholic 1
- muted guitar 1
- oboes/flutes 1
- opera song 1
- piano 1
- plucked string instrument 1
- pop 1
- pop song 1
- relaxing song 1
- reverb 1
- sad 1
- sad atmosphere 1
- saxophone 1
- simple percussion 1
- soft and dreamy 1
- soft sounding 1
- sound effects 1
- symphonic 1
- timpani 1
- timpani hit 1
- timpani percussion 1
- trumpet solo 1
- trumpet song 1
- trumpets 1
- upright bass bowed 1
- xylophone 1
musiccaps_names (array) 23 ✖
- Music 13
- Brass instrument 4
- Classical music 3
- French horn 3
- Scary music 3
- Bowed string instrument 2
- Cello 2
- Opera 2
- Tender music 2
- Violin, fiddle 2
- Christian music 1
- Double bass 1
- Jazz 1
- Middle Eastern music 1
- Orchestra 1
- Singing 1
- Soundtrack music 1
- String section 1
- Synthetic singing 1
- Theme music 1
- Thunk 1
- Timpani 1
- Trumpet 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
World of Warcraft Enchanted Forest Music | This song features a female voice singing in opera style using only vocables and no words. This is accompanied by violins playing eighth note patterns that change according to the chords being played. The bass follows the root notes of the chords. A muted guitar or string instrument plays arpeggiated chords. This song can be played in a fantasy game. | 2008-12-21T17:53:08Z | WoWMusicGuru | All credit goes to Blizzard for the making of this music. | ["Music", "Scary music"] | ["opera song", "symphonic", "female voice", "string section", "bass", "muted guitar", "fantasy song", "slow tempo"] | 0 | -r7iz-9v9bA | 91 | |
Hostel 3 Trailer | A cello section is playing a short stroke melody with the bow while other strings, probably violins are playing a one note drone in a high key. Timpani hits and rolls are adding depth to the musical scenario. In the background you can hear sound effects opening up the soundscape for a deeper male voice screaming/crying along to a chainsaw sound. This song may be playing in a movie scene where someone is getting tortured. | 2007-06-13T00:53:54Z | Over The Line Comedy | Over The Line Productions | ["Music", "Scary music"] | ["cinematic", "sound effects", "chainsaw", "male deep voice screaming/crying", "timpani", "string section", "cruel sounding", "slow tempo"] | 6 | 1bSP4wLfMpA | 291 | |
Melodies Of Life (OST Final Fantasy IX) | AMV - Emiko Shiratori | An acoustic guitar is playing single notes of a minor chord progression alongside an acoustic piano playing a melody on itself. Then a string-section comes in for a moment elevating the emotional piece giving it a beauty and soft sadness. The instruments are slightly panned to the left and right side of the speakers. The female voice is softly singing with a little bit of reverb on her voice. This song may be playing at a theater-performance. | 2006-01-25T14:25:37Z | geekster129 | This AMV is dedicated to all Final Fantasy IX and Final Fantasy fans around the world, and to the geniuses behind the Final Fantasy series: Hironobu Sakaguchi, Yoshitaka Amano,Tetsuya Nomura, Yoshinori Kitase, the musical genius, Nobuo Uematsu, and all the members of the Final Fantasy development team who have put their countless efforts on creating such a beautiful masterpiece. And, most of all... To all the viewers of this AMV, thank you very very much for all the kind words on the comments, and all the stories that you share. Thank you again. You can find the karaoke version: https://www.youtube.com/watch?v=u4bqksY_6JM | ["Music", "Tender music"] | ["ballad/pop", "acoustic piano", "acoustic guitar", "string section", "female voice singing", "slow tempo", "soft sounding"] | 6 | 3mNOJpN_qOQ | 499 | |
The Carpenters - You | This pop song starts off with the backing singers singing vocables in harmony. This is backed by percussion playing a simple beat. The bass plays a flourish ending on the root note of the next chord. The string section plays high pitched notes. The piano plays a flourish of ascending notes before the main female voice starts to sing the main melody. This is accompanied by the percussion continuing with the simple beat. The string section fades away. The bass plays a descending walk down and ends on a high note. This song has a romantic feel. This song can be played in a romantic movie. | 2008-06-25T12:52:31Z | sisterlead02 | One of their beautiful songs! From A kind of hush album. | ["Singing", "Christian music", "Music"] | ["pop song", "female voice", "bass", "backing vocal harmony", "simple percussion", "piano", "string section", "slow tempo", "romantic theme"] | 0 | 6QHfXuVLhe0 | 755 | |
Fullmetal Alchemist Brotherhood OST 3 - 20. Violoncello's Lament | This audio contains a string section playing a sad/melancholic piece. A violin/viola is playing the lead melody while celli and upright basses being played with a bow are supporting the melody with chords. The lead melody is panned to the right side of the speakers. This song may be playing in a sad and dramatic movie scene. | 2011-06-23T16:15:06Z | ShinyKyuukon | Disclaimer: I do not own any clips or music of this video. All clips and music belong to their respectful owner(s). This video is for enjoyment purposes only. Artist: Senju Akira. | ["Cello", "Double bass", "Violin, fiddle", "Bowed string instrument"] | ["cinematic", "orchestral", "sad", "dramatic", "dark", "string section", "slow tempo"] | 6 | 8MF6nFj02sM | 915 | |
Jonathan Antoine 19 yrs Last Night of Proms Cliffs Pavilion 30 Nov 2014 | This orchestral song features violins playing the main melody along with trumpets. This is accompanied by the bass being played on a cello. The percussion is played on a timpani. There are no voices in this song. This is an amateur recording. This song can be played in a fairytale animation movie. | 2014-12-10T09:41:28Z | morag grant | Jonathan Antoine, Special Guest performer at the Last Night of the Proms in South Cliffs Pavilion, England UK. Connect with Jonathan through his Official Website: http://www.jonathanantoinemusic.com/ Jonathan Antoine albums available on these links: Tenore: http://amzn.to/2oWQNOk & Believe: http://amzn.to/2uPqeJ7 Facebook: https://www.facebook.com/JonathanStavvyAntoine Twitter: https://twitter.com/JonAntoine Christmas Classic single on this link: https://www.youtube.com/watch?v=2qXSzLF7TUg | ["Music", "Orchestra", "Classical music"] | ["orchestra music", "violins", "no voices", "string section", "low quality recording", "timpani percussion", "slow tempo", "horn section"] | 0 | 8jDanS4ZzRc | 939 | |
Justin Bieber Believe Ft Demi Lovato X Factor Duet Selena Gomez Take You Die In Your Arms Lyrics AGT | This symphonic song features a string section playing the main melody. There are multiple violins playing different parts in harmony. The music starts off with four ascending notes followed by one descending note which is stretched out. This is followed by a descending run. The song has an epic feel and can be played as a grand entrance theme of royalty. | 2010-03-01T05:06:31Z | SelGomezHDXo | Justin Bieber Believe Ft Demi Lovato X Factor 2012 Selena Gomez Break Up Die In Your Arms Lyrics Fall Breakup Break Up As Long "One Love" Feat Drake Take You Lyrics Catching Feelings Ellen Beauty And The Beat Nicki Minaj One Love Be Out Of Town Girl Music Video Official VEVO JustinBieberVEVO kidrauhl DWTS GMA Ellen 2013, 2014, 2015, 2013 2014 2015, Beyonce, Ratchet, Taylor, Swift, Grammys, Awards, Interview, Sexy, Kim, Kardashian, Britney Spears X Factor Demi Lovato UK USA BGT AGT EMA TCA KCA VMA BMA AMA ACM CMA WMA SNL MMVA Lady Gaga Live Katy Perry Taylor Swift One Direction Rihanna Chris Brown Adele Justin Bieber Believe Tracklist Tracklisting Track List All Around The World featuring Ludacris Boyfriend As Long As You Love Me featuring Big Sean Take You Right Here featuring Drake Catching Feelings Fall Die In Your Arms Thought Of You Beauty And The Beat featuring Nicki Minaj One Love Be Alright Believe Out Of Town Girl Duet Up Nicki Minaj Katy Perry Taylor Swift One Direction Shakira Drake Lil Wayne Eminem Beyonce Jay-Z Rihanna Chris Brown Adele Kelly Clarkson Jennifer Lopez Pitbull Bruno Mars Victoria Justice America's Got Howard Stern TalentLMFAO Sorry For Party Rocking Willow Smith Miley Cyrus Jonas Brothers Usher Nick Joe Cody Simpson Disney Jimmy Kimmel David Letterman Carrie Underwood Wiz Khalifa Jessie Latin Grammy Awards 2012 Grammys American Idol The Voice Christina Aguilera Maroon DWTS Dancing With The Stars New Song Blue Ivy Carter Album Tracklist Songs VEVO LadyGagaVEVO JustinBieberVEVO JennaMarbles Jenna Marbles One Direction The Wanted Big Time Rush Victoria Justice Jason Derulo Steven Tyler Paula Abdul National Anthem Super Bowl Halftime Concert Live Performance Taio Cruz Rascal Flatts Tim McGraw Faith Hill Country Hip Hop Rap Freestyle Hot Sexy Boobs Cute Funny Kitten Puppy Dog Cat Shane Dawnson sxephil Ryan Seacrest Cover Fan Covers Preview Susan Boyle Remix Track List Tracklist Craig Ferguson Conan O'Brien "X Factor" Born This Way Ball Concert Cypher Birdman Good Morning America To… | ["Music", "Tender music"] | ["symphonic song", "string section", "instrumental", "no voices", "no percussion", "slow tempo", "orchestra", "epic mood"] | 0 | FscE_AHEmFk | 1668 | |
La Vie En Rose - The Classic Crooner Selection | This jazz song features a trumpet playing the main melody. This is accompanied by a string section. There are long pauses in between lines where the backing instruments pause while the trumpet solo is played. Percussion is played along with the string section. There are no voices in this song. This is an instrumental song. This song can be played in a silent movie. | 2009-10-20T17:53:04Z | rhumbustification | A video about a classic song, with classic singers...enjoy (no copyright violation intended, of course) | ["Jazz", "Music", "Classical music"] | ["jazz", "trumpet solo", "string section", "percussion", "bass", "no voices", "instrumental", "slow tempo"] | 0 | HXwX9f9ugZ4 | 1812 | |
Harry Potter and the Sorcerer's Stone Game Music - Stealth Sneak | This game music is an orchestral song with no lyrics. It starts off with low pitched instruments playing an eerie melody. A percussion instrument plays in the background. After the first four counts, a hissing sound is played. This song has no voices. This is a slow tempo song. It can be used in the game lobby of a game involving wizards. | 2014-11-08T07:56:39Z | RingsOfGeonosis | Harry Potter 1 Game Soundtrack Harry Potter 1 Video Game Soundtrack Harry Potter Philosopher's Stone Game OST Harry Potter Sorcerer's Stone Game Music Theme Song Composer(s): Jeremy Soule | ["Timpani", "Theme music", "Music", "Scary music"] | ["game lobby music", "orchestra music", "no voices", "instrumental", "slow tempo", "hissing sound", "string section", "eerie music", "percussion"] | 0 | Js_3Aa214xY | 2041 | |
The Sound of Music Soundtrack - 15 - Climb Ev'ry Mountain | A female voice is singing with a slight opera feeling to it. A string section is playing along with her melody. An upright-bass is played with a bow providing the bassline. This song may be playing at a musical. | 2011-03-15T02:03:19Z | xosoundtrackloverxo | ["Music", "Opera", "Soundtrack music"] | ["50s/60s ballad", "string section", "keyboard", "upright bass bowed", "female voice singing", "slow tempo"] | 6 | UtCRBs5p4EQ | 2951 | ||
The Elder Scrolls Online - Heavy Armor Preview (All Races) | This composition contains a horn playing a melody with reverb on it. Then a string section comes in playing a soothing melody rising and falling in pitch. You can hear some digital clicking sounds that seem not to belong to the musical composition. This song may be playing in a fantasy adventure video-game. | 2014-02-15T20:53:40Z | Birds | The Elder Scrolls Online Beta Armor Preview. All Races! Medium Armor: http://www.youtube.com/watch?v=yUVXHEYBeBk Light Armor: http://www.youtube.com/watch?v=M32D9Ai5uKk | ["Brass instrument", "French horn"] | ["orchestral", "string section", "horn", "soothing", "slow tempo"] | 6 | WKL40jfQD3g | 3086 | |
Lana Del Rey - Terrence Loves You (Official Audio) | The song sounds orchestrated. There is a string section playing swells and rising tremolos along to an acoustic piano playing minor chords. A cello is playing long low notes on top of that a saxophone is playing two notes to end the phrase. A deep and far percussive hit comes in every fourth count. The female singer's voice sounds sensitive and melancholic. There are female backing voices singing along. The whole composition is full of big reverb. This song may be playing at the end of a sad movie. | 2015-08-21T07:00:00Z | LanaDelReyVEVO | Lana Del Rey - Terrence Loves You (Official Audio) Sign up for updates: http://smarturl.it/LanaDelRey.News Follow Lana Del Rey: http://www.instagram.com/lanadelrey http://www.facebook.com/lanadelrey http://www.twitter.com/lanadelrey http://lanadelrey.tumblr.com http://www.lanadelrey.com Lana Del Rey - Terrence Loves You (Lyrics) You are what you are I don't matter to anyone But Hollywood legends Will never grow old And all of what's hidden Well, it will never grow cold But I lost myself when I lost you But I still got jazz when I've got those blues And I lost myself when I lost you And I still get trashed, darling, when I hear your tunes But you are who you are I won't change you for anything For when you are crazy I'll let you be bad I'll never dare change thee To what you are not But I lost myself when I lost you But I still got jazz when I've got those blues I lost myself and I lost you too And I still get trashed, baby, when I hear your tunes I put the radio on, hold you tight in my mind Isn’t strange that you’re not here with me I’m putting all the lights on and the television Trying to transmit, can you hear me? Ground control to Major Tom Can you hear me all night long? Ground control to Major Tom Well, I lost myself when I lost you But I still got jazz when I've got the blues I lost myself and I lost you too And I still get trashed, honey, when I hear your tunes Mmmm-mmm-mmm-mmm Mmmm-mmm-mmm-mmm Mmmm Mmmm-mmm-mmm-mmm Mmmm | ["Music", "Synthetic singing"] | ["pop", "string section", "female voice singing", "reverb", "acoustic piano", "deep", "low percussive hit", "saxophone", "slow tempo", "melancholic"] | 6 | emDU4QvdwVk | 3896 | |
Jamais plus je ne volerai - Buzz l'éclair | A full orchestra is playing a descending melody with a string section, a horn section and oboes. Then you can hear something falling to the ground and breaking. This may be playing in a sad disnemovie scene. | 2011-12-06T14:03:28Z | Soulouz | Extrait du film d'animation ToyStory sorti en 1995, réalisé par les studios Pixar. | ["Music", "Thunk"] | ["cinematic/orchestral", "string section", "horn section", "oboes", "background noise", "sad atmosphere", "slow tempo"] | 6 | lDsQWSf1h3I | 4385 | |
شاهد الفخامة والشياكة فى قصر النجمة هيفاء وهبى من الداخل والخارج | This song contains an orchestra playing a melody in the mid to high range with a string section decreasing in volume.Oboes/flutes are playing another melody on top with a low timpani hit in the background. This song may be playing at the end of an emotional adventure movie. | 2013-08-24T14:32:55Z | أخبار النجوم | إضغط هنا لترى أجمل 50 امرأة على مر التاريخ بالأسماء والصور...برأيكم من هى أجملهن ؟ https://www.youtube.com/watch?v=eDe8MMaxinA&index=1&list=PL8WHyaccuEkPIKBbF7YSM1TlfNYnm4y8- إضغط هنا لترى فنانات جميلات ومشهورات إكتشفن خيانة أزواجهن ولم بحرجن من البوح بها https://www.youtube.com/watch?v=-nJuvAIBSYc&list=PL8WHyaccuEkMdCYn4mqt2HOAX5gx4DzQg&index=1 إضغط هنا لترى 16 فنان بهدلهم الفقر...أحدهم كان يتسول فى الشارع...ورقم 16 سيذهلكم https://www.youtube.com/watch?v=JcAfl34Fq6w&index=1&list=PLFUUhRdSN8wk_-WrGn3K_uh7JdZ1Uu6lY إضغط هنا لترى أسرار زيجات نورا وحظها السئ فى الزواج وقصة حجابها وإعتزالها https://www.youtube.com/watch?v=WPmzwbTuDNw&index=1&list=PLFUUhRdSN8wkWTOuaUDfuwCiL3qjaiRiJ إضغط هنا لتعرف أسرار الزواج الثانى بحياة الرؤساء والملوك العرب...فهل كانت نزوات ؟ https://www.youtube.com/watch?v=bk8jNBtyq1c&list=PLeGeiVXDned_3lTvJpK5ADsC5UGvqsvWw&index=1 إضغط هنا لترى فنانات مشهورات وافقن على الزواج من رجال متزوجين...مفاجأة https://www.youtube.com/watch?v=O6LCmiR9_FE&list=PL8WHyaccuEkONsjQ5YDCUr3Zk3ttiRkZ4&index=1 إضغط هنا لترى نجمات وفنانات وجميلات دخلن السجن ومنهن ملكة جمال https://www.youtube.com/watch?v=eEfVXBOOK9g&index=1&list=PL8WHyaccuEkMdCYn4mqt2HOAX5gx4DzQg إضغط هنا لترى أسرار الملياردير المصرى محمد الفايد وزوجاته وأبناؤه وبداية حياته عتال https://www.youtube.com/watch?v=E-m2CGU_F5M&list=PL8WHyaccuEkONsjQ5YDCUr3Zk3ttiRkZ4&index=1 مطرب عراقى لحن جميع أغانيه وحصل على ثلاثة جنسيات وتزوج مرة واحدة فقط فهل تعرفه ؟ https://www.youtube.com/watch?v=NzIS4wnb4xo&list=PLFUUhRdSN8wmYG4aGVdlg0VMYlrCIAgdl&index=181 إضغط هنا لترى أجمل إطلالات النجوم والنجمات في مهرجان القاهرة السينمائي 37...برأيكم من الأجمل ؟ https://www.youtube.com/watch?v=cLQw2WmghRA&index=1&list=PL8WHyaccuEkPIKBbF7YSM1TlfNYnm4y8- إضغط هنا لترى زوجة شاروخان وقصة زواجه الرومانسية وقصره الفاخر وسياراته https://www.youtube.com/watch?v=VFmg5LwmbPY&index=5&list=PLeGeiVXDned-tUFWCUuilqzo0wB0I0qLC إضغط هنا لترى نجمات تعرضن للضرب والعنف الجسدى على يد أزواجهن https://www.youtube.com/watch?v=XUeFbnIjWvE&list=PL8WHyaccuEkMdCYn4mqt2HOAX5gx4DzQg&index=1 اذا اعجب… | ["Music", "Middle Eastern music"] | ["classical", "orchestral", "string section", "oboes", "timpani hit", "calming", "heroic", "slow tempo"] | 6 | oUp-acoLyvU | 4636 | |
The hills are alive ( Julie Andrews-The Sound of Music) | This classical song features the main melody played by trumpets. This is accompanied by violins playing two note trills. A xylophone plays notes in the background. Church bells are played in the background. There is no percussion in this song. This is an instrumental song. There are no voices in this song. The mood of this song is relaxing. This song can be played in a magical scene in a movie. | 2012-05-04T04:18:50Z | scarletttarleton | Premier chant de Maria dans "The Sound of Music" (La Mélodie du bonheur) The hills are alive with the sound of music With songs they have sung for a thousand years The hills fill my heart with the sound of music My heart wants to sing every song it heard My heart wants to beat like the wings of the birds that rise from the lake to the trees My heart wants to sigh like the chime that flies from a church on a breeze To laugh like a brook when it trips and falls over stones on its way To sing through the night like a lark who is learning to pray I go to the hills when my heart is lonely I know I will hear what I've heard before My heart will be blessed with the sound of music And I'll sing once more. | ["Brass instrument", "French horn"] | ["classical music", "no voices", "string section", "bells", "trumpets", "instrumental", "relaxing song", "slow tempo", "xylophone"] | 0 | p_-lKpxLK3g | 4722 | |
Mara Galeazzi & Edward Watson in Romeo & Juliet. | A full orchestra is playing a slow dramatic, emotional and soft composition. In the background whispering can be heard. This is an amateur recording. This song may be playing at a theater dancing ballet. | 2013-09-24T15:32:40Z | Approximatesonata | Balcony scene pas de deux. Cor. Kenneth Mac Millan. | ["Music", "Opera", "Classical music"] | ["classical music", "orchestra", "flutes", "string section", "oboes", "slow tempo", "dramatic", "background whispering", "soft and dreamy", "amateur recording"] | 6 | q9zAlMM-A9I | 4759 | |
R Strauss Horn Concerto No 1 - 2 Barry Tuckwell 1987 | This composition contains someone playing a solo melody on a horn in the mid to higher register. A string section, flutes and oboes are supported with a short rising harmony. This song may be playing live while listening to an orchestra. | 2009-05-24T20:19:57Z | hkakita | With NHK Symphony Orchestra, Japan | ["Brass instrument", "French horn"] | ["classical", "orchestral", "horn", "string section", "oboes/flutes", "soothing", "slow tempo"] | 6 | t3-xANiQrho | 4999 | |
Tchaikovsky: Variations on a Rococo Theme / Justus Grimm (Cello) | This symphonic song features a melody played on a cello. This is accompanied by violins playing in the background. It starts off as a slow tempo song. After a brief pause, the instruments play staccato notes at a faster tempo. There is no percussion in this song. There are no voices in this song. This is a classical instrumental piece. This song can be played in a luxury watch advertisement. | 2012-12-25T15:51:17Z | RussianRusalka | PYOTR ILYICH TCHAIKOVSKY Variations on a Rococo Theme op.33 JUSTUS GRIMM (Cello) Symfonieorkest van De Munt / Carlo Rizzi (Conductor) 14/02/2012 | ["Cello", "String section", "Violin, fiddle", "Bowed string instrument"] | ["symphonic song", "string section", "cello", "violins", "classical song", "no voices", "instrumental", "slow tempo"] | 0 | x9bcsYF_by8 | 5307 | |
Trumpet Solo ~ My Heart Will Go On, theme from Titanic | This amateur recording features a trumpet playing the main melody. The song starts with a string section playing a chord and fading away. The trumpet starts to play the melody. This is backed by a stringed instrument plucking chords. This sounds like a harp or an acoustic guitar. The mood of this song is romantic. This song can be played in a romantic movie. | 2009-01-18T09:26:46Z | TPBOY | Book from " Take the Lead " | ["Brass instrument", "Trumpet"] | ["amateur recording", "trumpet song", "romantic theme", "string section", "plucked string instrument", "no percussion", "slow tempo", "no voices", "instrumental"] | 0 | xZukWGb52BI | 5341 |
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;