musiccaps_details (view)
17 rows where musiccaps_aspects contains "live performance", musiccaps_aspects contains "spirited" and musiccaps_author = 1
This data as json, CSV (advanced)
musiccaps_aspects (array) 208 ✖
- live performance · 17 ✖
- spirited · 17 ✖
- passionate 12
- medium tempo 10
- emotional 9
- live audience 9
- instrumental music 8
- poor audio quality 8
- energetic 6
- male singer 5
- dance rhythm 4
- exciting 4
- groovy music 4
- bad audio quality 3
- groovy bass line 3
- guitar accompaniment 3
- romantic 3
- traditional music 3
- adrenaline rush 2
- ambient crowd noises 2
- ambient room noises 2
- average audio quality 2
- carnatic music 2
- composers 2
- concert hall 2
- conductor 2
- entertaining 2
- excitement 2
- fast tempo 2
- folk singer 2
- guitar rhythm 2
- indian classical music 2
- people cheering 2
- philharmonic orchestra 2
- positive 2
- soloist 2
- virtuoso 2
- western classical music 2
- aboriginal didgeridoo 1
- accordion player 1
- acoustic song 1
- adrenaline junkies 1
- amateur music 1
- amateur quality recording 1
- amateur singing 1
- ambient noise 1
- ambient noises 1
- ancient customs 1
- banjo 1
- banjo player 1
- baroque music 1
- bassoons 1
- beach party 1
- brass section 1
- cameras clicking 1
- carnatic vocals 1
- cellist 1
- cello concerto 1
- cheerful 1
- child performers 1
- clapping percussions 1
- clarinet player 1
- clarinets 1
- conductors 1
- country blue grass 1
- country bluegrass 1
- country dance music 1
- country folk music 1
- country music 1
- crowds cheering 1
- crowds clapping 1
- crowds whistling 1
- cymbals crashing 1
- dance club 1
- dance mix 1
- dealing with depression 1
- deteriorated audio quality 1
- didgeridoo 1
- didgeridoo player 1
- dj 1
- double reed instruments 1
- drone harmony tones 1
- dvorak 1
- electric guitar 1
- emotional music 1
- encouraging crowd 1
- energetic drumming rhythm 1
- enthusiastic 1
- ethnic aboriginal instrument 1
- euro pop 1
- european folk song 1
- family reunion 1
- fast guitar strumming 1
- fast metal drumming 1
- female singer 1
- fiddlers 1
- flamenco guitar 1
- folk music 1
- folk singers 1
- g]adrenaline rush 1
- grand 1
- great composers 1
- great technique 1
- groove to the music 1
- groovy 1
- groovy rhythm 1
- groovy tempo 1
- group singing 1
- guitar amplifiers 1
- guitar demonstration 1
- guitar lessons online 1
- guitar playing rhythm 1
- guitar strumming 1
- guitar strumming rhythm 1
- hand percussions 1
- hard metal music 1
- harpsichord 1
- harpsichord player 1
- harpsichordist 1
- head banging 1
- high pitched melody 1
- hissing sounds 1
- home video 1
- horn section 1
- humour 1
- indian wind instrument 1
- inspiring 1
- instrumentalist 1
- latin singer 1
- lifetime experience 1
- live music 1
- live recording 1
- loneliness 1
- love performance 1
- love video performance 1
- lyrical melody 1
- male and female singer 1
- male vocalist 1
- march rhythm drumming 1
- meditational 1
- medium fast tempo 1
- memories 1
- metal band 1
- mosh pit 1
- motivational 1
- mridangam percussion 1
- music concert 1
- nadaswaram playing 1
- never give up 1
- noisy crowd 1
- noisy crowds 1
- opera hall 1
- passionate music 1
- passionate singing 1
- people clapping 1
- people dancing 1
- people talking 1
- percussive bass line 1
- percussive playing 1
- percussive tap dancing 1
- pomp 1
- prayers 1
- rebellious 1
- reggae band 1
- reggae music 1
- retro metal hits 1
- retro rock hits 1
- rock drumming rhythm 1
- rock music 1
- rock singer 1
- rom 1
- screaming 1
- screaming vocals 1
- sentimental 1
- singing long notes 1
- snares riding fast 1
- social gathering 1
- song cover 1
- spirit connection 1
- spirited singing 1
- steady drumming 1
- street musician 1
- string section 1
- strong bass line 1
- strumming chords 1
- studio recording 1
- syncopated rhythms 1
- tabla 1
- tap dancers 1
- tapping rhythm 1
- the country life 1
- the wild west 1
- timpani bangs loud 1
- traditional folk song 1
- traditional latin music 1
- trumpets 1
- trumpets play percussively 1
- tubas 1
- various percussion hits 1
- vintage metal 1
- violinists 1
- violins playing harmony 1
- virtuously 1
- walking bass line 1
- wind sections 1
- yodelling melody 1
- youthful 1
- youtube music video 1
musiccaps_names (array) 37 ✖
- Music 14
- Musical instrument 5
- Singing 4
- Classical music 3
- Banjo 2
- Bowed string instrument 2
- Carnatic music 2
- Plucked string instrument 2
- Vocal music 2
- Accordion 1
- Afrobeat 1
- Applause 1
- Bluegrass 1
- Brass instrument 1
- Cello 1
- Chant 1
- Chorus effect 1
- Clarinet 1
- Country 1
- Crackle 1
- Didgeridoo 1
- Effects unit 1
- Electric guitar 1
- Flamenco 1
- Guitar 1
- Harpsichord 1
- Keyboard (musical) 1
- Orchestra 1
- Percussion 1
- Rock music 1
- Song 1
- Speech 1
- Tap 1
- Trumpet 1
- Violin, fiddle 1
- Whoop 1
- Yell 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
World Fastest Banjo Player | The song is an instrumental. The song is medium tempo with a groovy rhythm and fast fingers playing this banjo solo. The song is entertaining and exciting. The song is of poor audio quality and a live performance video. | 2009-05-12T15:23:34Z | eriobras | Erio Meili on May 10, 2009, picking the tune "Sunday", at 330 bpm at the Titanic Harbor Stage, 660 notes per minute (10 notes per second) - former record was on June15, 2008 at 320 bpm | ["Banjo", "Music", "Bluegrass"] | ["banjo player", "fast tempo", "groovy music", "love video performance", "instrumental music", "virtuoso", "walking bass line", "entertaining", "love performance", "soloist", "country blue grass", "entertaining", "energetic", "passionate", "spirited", "instrumentalist", "poor audio quality", "live performance"] | 1 | 0HXYdGGKV2k | 141 | |
ジャズコーラスの音色とマーシャルガバナーの威力 | The song is an instrumental. The song is medium tempo with an electric guitar playing chords and strumming rhythm with no other instrumentation. The song is emotional and interesting. The song is probably a demo of a guitar or guitar amplifier. The audio is average quality. | 2011-10-24T16:02:01Z | yskpai81 | ガバナー大好き。 http://mixi.jp/view_diary.pl?id=1786483877&owner_id=11016145 ↑これです。昔は四角い形だったのに、今は流線型のボディになってます。 音は昔の方が良かったような気がします。 | ["Effects unit", "Electric guitar", "Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument"] | ["electric guitar", "strumming chords", "virtuoso", "guitar lessons online", "guitar strumming rhythm", "guitar amplifiers", "guitar demonstration", "live performance", "youtube music video", "average audio quality", "medium tempo", "instrumental music", "emotional", "spirited", "soloist", "ambient room noises"] | 1 | 2xATintzaj4 | 420 | |
Alizee - Sound Of Silence, Moscow, 18-05-2008 | A female singer sings this live cover version of a famous song. The song is medium tempo with guitar accompaniment, crowds cheering and whistling and cameras clicking. The song has a poor audio quality and has a lot of ambient crowd noises, | 2008-05-24T21:54:38Z | mazarakis | Alizee - Sound Of Silence, Moscow, 18-05-2008 thanks to Didevil, ikm, pavel zubarev links to big files is here http://alizeeforum.fastbb.ru/?1-0-0-00001519-000-0-0#028 http://alizeeforum.fastbb.ru/?1-0-0-00001519-000-0-0#029.001 | ["Applause", "Music", "Crackle"] | ["female singer", "live performance", "song cover", "romantic", "loneliness", "dealing with depression", "crowds whistling", "crowds clapping", "poor audio quality", "song cover", "guitar accompaniment", "encouraging crowd", "emotional", "spirited", "passionate", "inspiring", "motivational", "amateur singing", "strong bass line", "home video", "music concert", "cameras clicking"] | 1 | 69oU6LfyQ_4 | 731 | |
Natheswaram Thavil Kachcheri SMT 2015 | The song is an instrumental Indian classical tune. The song is medium tempo with two Indian double reed instruments called nadaswaram playing in a duet. The song is emotional and highly lyrical . The song is amateur quality recording and a classic Carnatic music tune. | 2015-02-11T08:27:22Z | Rasiah Sriravindrarajah | Srilankan Natheswaram and Thavil vidwans played famous songs at an Inisai Kachcheri at the Sydney Murugan Cultural Hall on 10th Feb. 2015. Listed to three songs at the end of the Kachceri. | ["Carnatic music", "Music", "Musical instrument", "Classical music"] | ["carnatic music", "live performance", "nadaswaram playing", "medium tempo", "indian wind instrument", "double reed instruments", "emotional music", "lyrical melody", "ambient noise", "amateur quality recording", "indian classical music", "spirited", "passionate", "drone harmony tones"] | 1 | AjLX_1rBDPM | 1159 | |
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 | |
DR.M.BALAMURALIKRISHNA - THILLANA | A male vocalist sings this traditional Carnatic vocals. The song is medium tempo with a violin accompaniment, tabla and mridangam playing percussion. The song is energetic and passionate and highlights the traditional Carnatic music art form. The audio quality is bad. | 2007-04-17T07:21:47Z | Musique4ever | Dr.M.Balamuralikrishna sings a thillana in Ahir Bhairav. | ["Singing", "Carnatic music", "Music", "Musical instrument", "Classical music", "Percussion"] | ["carnatic music", "male vocalist", "medium tempo", "tabla", "energetic", "passionate", "indian classical music", "bad audio quality", "live performance", "live audience", "passionate", "spirited", "exciting", "mridangam percussion", "carnatic vocals"] | 1 | Emc18GpAeRY | 1588 | |
sleepy man banjo boys vs mountain rhythm | The song is instrumental. The tempo is medium with a prolific fiddler playing melody and a banjo and guitar accompaniment. The song is adventurous and exciting. The song is a classic country instrumental. The song has poor audio quality. | 2011-05-15T21:20:57Z | RubenProducciones | blatle of banjos. read the description: friends can go to this link and give it a like, would help me a lot to back up videos like this :) http://www.youtube.com/watch?v=g1I7seXs6O4 | ["Banjo", "Country", "Music", "Musical instrument", "Plucked string instrument", "Bowed string instrument"] | ["violinists", "country music", "fiddlers", "child performers", "instrumental music", "guitar strumming", "country folk music", "live performance", "groovy rhythm", "country dance music", "the country life", "the wild west", "dance rhythm", "passionate", "emotional", "spirited", "never give up", "cheerful", "positive", "traditional music", "bad audio quality", "country bluegrass", "banjo", "medium tempo"] | 1 | O84YjlJ_Qw4 | 2402 | |
Couperin & Clavecin | The song is an instrumental. The song is medium tempo with a harpsichord belting played with no other instrumentation. The music is emotional, passionate and melancholic. The song audio quality is poor. | 2007-10-14T21:47:21Z | profsha | Eric DEM joue Couperin au clavecin à l'église de Cesson-Sévigné. | ["Harpsichord", "Keyboard (musical)"] | ["harpsichord", "harpsichord player", "harpsichordist", "poor audio quality", "instrumental music", "medium tempo", "composers", "conductors", "live music", "live performance", "live audience", "emotional", "spirited", "romantic", "baroque music", "passionate", "western classical music"] | 1 | S38KjqRR418 | 2737 | |
Immer Kleiner Philips Harmonie | The song is an instrumental. The tempo is medium with a clarinet playing lead supported by a wind section, horn section, brass section and other percussion. The song is exciting and energetic. The song is a western classic tune with bad audio quality issues. | 2010-02-08T15:01:49Z | juudruud | Guido van de Ven speelt 'Immer Kleiner' tijdens het nieuwjaarsconcert 2010 van de Philips Harmonie. dirigent: Matty Cilissen special guest star: Jos de Wit Guido van de Ven plays 'Always Smaller'. Newyearconcert 2010 Philips Harmonie Eindhoven. conductor: Matty Cilissen special guest star: Jos de Wit Bekijk ook het officiële Philips Harmonie Youtube-kanaal https://www.youtube.com/channel/UCD7B2SzauFUtJ58DHheWy4w | ["Brass instrument", "Clarinet", "Trumpet"] | ["clarinet player", "horn section", "brass section", "philharmonic orchestra", "instrumental music", "trumpets", "conductor", "medium tempo", "instrumental music", "concert hall", "high pitched melody", "syncopated rhythms", "grand", "exciting", "pomp", "humour", "energetic", "passionate", "composers", "conductor", "live audience", "live performance", "poor audio quality", "spirited", "tubas", "clarinets", "bassoons"] | 1 | Z-Vb1Ay-zNA | 3333 | |
robzn - Kill the sound boy feat. Karen Firlej | A male singer sings this reggae melody with a live audience. The song is medium tempo with a groovy drum rhythm, trumpet playing rhythmically, guitar playing accompaniment and a groovy bass line. The song is exciting and cheerful. The song is a modern reggae tune and played in both a live audience situation and studio recording quality. | 2015-03-08T15:21:56Z | Das Octagon | Luiggis Finest Kill the sound boy feat. Karen Firlej Karen: https://www.facebook.com/pages/Karen-Firlej/179074595612477 robzn: https://www.facebook.com/robznoffiziellergehtnicht http://robznoffiziell.de/ vrob: https://www.facebook.com/vroboffiziellergehtnicht Luiggis Finest: https://soundcloud.com/luiggisfinest/luiggis-finest-hip-hop-reggaeneration | ["Afrobeat", "Music"] | ["reggae music", "live recording", "reggae band", "exciting", "energetic", "dance rhythm", "spirited", "beach party", "dance club", "dance mix", "excitement", "groove to the music", "people dancing", "studio recording", "dj", "noisy crowds", "people cheering", "guitar playing rhythm", "trumpets play percussively", "steady drumming", "live audience", "live performance", "male singer", "people cheering", "dance rhythm", "groovy bass line"] | 1 | fWypK9RHJJI | 3955 | |
김경호 shout 초반 샤우팅 연도별 모음 | A male singer sings this screaming metal melody. The song is medium fast tempo with a fast metal drumming rhythm, percussive bass line and guitars playing accompaniment. The song is rebellious and highly spirited. The audio quality is very poor and vintage. | 2016-03-01T09:07:30Z | 갓경호 | 김경호 shout 초반 샤우팅 연도별 모음1998/1999/2000/2001/2002/2003/2004/2005/2009/2010/2011/2014 | ["Music", "Whoop"] | ["hard metal music", "male singer", "screaming vocals", "vintage metal", "metal band", "deteriorated audio quality", "head banging", "mosh pit", "retro metal hits", "screaming", "noisy crowd", "live performance", "fast metal drumming", "guitar rhythm", "percussive bass line", "energetic", "adrenaline rush", "poor audio quality", "spirited", "rebellious"] | 1 | g75kz9ffcg0 | 4007 | |
Aboriginal Didgeridoo part 1 | The song is an instrumental. The tempo is medium with an aborigine playing a didgeridoo and a tapping rhythm in a percussive manner. The audio quality is bad with ambient crowd talking sounds. The music is traditional and deeply meditative in nature. | 2007-08-16T23:13:45Z | Jeffrey Siegel | The didgeridoo (or didjeridu) is a wind instrument of the Indigenous Australians of northern Australia. | ["Didgeridoo", "Music", "Speech"] | ["didgeridoo", "aboriginal didgeridoo", "groovy", "ethnic aboriginal instrument", "didgeridoo player", "people talking", "ambient noises", "hand percussions", "medium tempo", "instrumental music", "tapping rhythm", "percussive playing", "meditational", "traditional music", "ancient customs", "emotional", "passionate", "spirited", "spirit connection", "prayers", "live performance"] | 1 | lUp9WnLYetg | 4404 | |
요들송 _ 키스 요들 _ Kuss Jodle _ Kiss Yodel _ 목장주인김원섭 _ 박진아 | A male singer sings with a female backup singer in vocal harmony. The song is medium tempo with a yodelling medley and guitar strumming rhythm and no other instrumentation. The song is exciting and passionate. The song has poor audio quality. | 2010-11-11T11:53:45Z | 목장주인tv | 요들송 _ 키스 요들 _ Kuss Jodle _ Kiss Yodel 2009.5.7. 성남아트센터 김원섭(010-4061-6404)의 '나눔의 열린 음악회'중에서 kmwonseop@hanmail.net | ["Singing", "Chant", "Music", "Vocal music"] | ["male and female singer", "yodelling melody", "poor audio quality", "clapping percussions", "dance rhythm", "spirited", "traditional music", "guitar accompaniment", "acoustic song", "traditional folk song", "folk singers", "live performance", "live audience", "ambient room noises", "hissing sounds", "exciting", "emotional", "medium tempo", "people clapping"] | 1 | m9MQdg0k1t0 | 4448 | |
Tap Dogs I Beams | The song is an instrumental. The song is medium fast tempo with a groovy bass line, energetic drumming, and tap dancers in a percussive groove. The song is entertaining and energetic. | 2009-07-26T17:06:46Z | Tap Dogs Official | ["Music", "Tap"] | ["tap dancers", "percussive tap dancing", "adrenaline junkies", "live audience", "live performance", "instrumental music", "groovy bass line", "people cheering", "energetic drumming rhythm", "medium fast tempo", "various percussion hits", "snares riding fast", "entertaining", "energetic", "positive", "spirited", "youthful", "dance rhythm"] | 1 | oRUdvu3Qo-E | 4628 | ||
Los Mejores Gritos de Axl Rose/Best Cries Of Axl Rose [El Mejor Grito De La Historia] | A male rock singer sings this climatic solo with a long sustained note. The tempo is medium with strong rock drumming, guitar rhythm; guitar lead and a percussive bass line. The song is hard rock with a lot of spirit and excitement. The audio quality is bad with a lot of ambient crowd noises. | 2013-01-27T02:36:43Z | M. Adonis Ortiz | Like Please: http://www.facebook.com/ILoveGunsNRoses1 Únete/Me Gusta Por Favor: http://www.facebook.com/ILoveGunsNRoses1 Lista de gritos de Axl Rose LIVE. Una maravilla de 4 octavas: Axl Rose. Un bajo-barítono que se empuja hacia la 5ª octava. Algunos dicen que Axl suena como una guitarra, y tiene razón! No es un cantante melódico pero hace el trabajo! 01.El pasaje grave hacia el final de ¨Sweet child o' mine¨, la nota más baja es F#2. 02.La armonía grave en el comienzo de ¨Paradise City¨, también F#2. 03.Un sólido D#2 en ¨You ain´t the first¨. 04.La versión en vivo tiene dos D#2 :s. 05.C#2 desde ¨Shackler´s revenge¨ en Chinese Democracy (Que bueno que Axl Por fin lo terminó). 06.Puede Axl bajar más? El está hablando en la parte inferior de su segunda octava acá y canta un C#2 (una vez más) al final del Rockumental de MTV. 07.Axl se desliza hacia abajo para un C2 tambaleante, pero sostenido, al final de ¨Ain´t going down¨ (demo). 08.Un lindo B1 de ¨Don´t cry¨. 09.El B1 también está en esta conocida canción, ¨November rain¨ (¿Voz de fritura?) 10.Esto también suena como B1, una armonía baja (separada de la voz principal) de ¨There was a time¨. 11.La nota más baja de Axl, A1, de ¨Get in the ring con un A2¨. La armonia tiene una línea en B1, una línea en D2, una en A1 y una línea más en B1, luego las repite. 12.Hora de ir hacia arriba. Un C#5 de ¨Paradise City¨. 13.El final clásico de ¨Sweet Child o' mine¨ donde Axl toca D#5 varias veces :s y también un corto E5. 14.D#5 con trinos de ¨Welcome to the jungle¨. 15.Un D#5 de ¨Anything goes¨. 16.F5 de ¨You could be mine¨. 17.Misma nota, pero en vivo. 18.Cantando hasta F#5! y luego manteniendo esa nota, en ¨There was a time¨. Su nota más alta cantada, esto debe ser duro para él en los conciertos. 19.Gran F#5 de ¨I.R.S¨. 20.Un G5 de una versión en vivo de ¨Welcome to the jungle¨. 21.G5 en ¨Chinese democracy¨. 22.Linda cadenza hasta G#5 de ¨Scraped¨ con una armonía de C#2 abajo. 23.Manteniendo un G#5 junto con Sebastian Bach (que tenía y tiene excelent… | ["Singing", "Music", "Rock music", "Yell"] | ["live performance", "bad audio quality", "singing long notes", "rock singer", "male singer", "crowds cheering", "rock music", "rock drumming rhythm", "cymbals crashing", "live audience", "ambient crowd noises", "groovy bass line", "guitar rhythm", "g]adrenaline rush", "lifetime experience", "groovy music", "excitement", "enthusiastic", "adrenaline rush", "passionate", "spirited", "retro rock hits"] | 1 | pHC25Ia8Dxo | 4694 | |
Heligonka archiv Setkání v Lošticích 2007 | A male singer sings this emotional melody. The song is medium tempo with a steady drumming rhythm, accordion accompaniment and people singing together in unison. The song is emotional and sentimental. The song audio quality is poor. | 2011-05-09T16:37:53Z | Vrana1935 | ["Accordion"] | ["male singer", "accordion player", "family reunion", "social gathering", "euro pop", "group singing", "european folk song", "folk singer", "medium tempo", "march rhythm drumming", "live audience", "live performance", "ambient crowd noises", "poor audio quality", "amateur music", "emotional", "sentimental", "rom", "passionate", "spirited", "memories"] | 1 | r4JRDHYukZ4 | 4848 | ||
Dvořák: Cello Concerto / Isserlis · Gilbert · Berliner Philharmoniker | The song is an instrumental. The tempo is medium with a cellist playing a virtuoso solo accompanied by a string section harmony, flutes in harmony and a loud banging timpani. The song is spirited and passionate with poor audio quality. The song is a western classical piece. | 2009-06-19T08:28:26Z | Berliner Philharmoniker | Full-length concert: http://www.digitalconcerthall.com/concert/27/?a=youtube&c=true Antonín Dvořák: Cello Concerto / Steven Isserlis, cello · Alan Gilbert, conductor · Berliner Philharmoniker / Recorded at the Berlin Philharmonie, 19 April 2009. The Berliner Philharmoniker's Digital Concert Hall: http://www.digitalconcerthall.com Subscribe to our newsletter: http://www.digitalconcerthall.com/newsletter Website of the Berliner Philharmoniker: http://www.berliner-philharmoniker.de | ["Cello", "Music", "Musical instrument", "Orchestra", "Violin, fiddle", "Classical music", "Bowed string instrument"] | ["cellist", "string section", "philharmonic orchestra", "cello concerto", "dvorak", "virtuously", "timpani bangs loud", "medium tempo", "wind sections", "violins playing harmony", "groovy music", "western classical music", "great composers", "conductor", "opera hall", "live audience", "live performance", "instrumental music", "passionate", "spirited", "emotional", "great technique", "poor audio quality", "concert hall"] | 1 | yrme-KRBvzk | 5445 |
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;