musiccaps_details (view)
18 rows where musiccaps_aspects contains "cheerful" and musiccaps_aspects contains "enthusiastic"
This data as json, CSV (advanced)
musiccaps_aspects (array) 221 ✖
- cheerful · 18 ✖
- enthusiastic · 18 ✖
- fast tempo 13
- happy 12
- instrumental 9
- energetic 8
- lively 6
- keyboard harmony 5
- upbeat 5
- fun 4
- male vocalist 4
- peppy 4
- regional music 4
- animated 3
- celebratory 3
- live performance 3
- spirited 3
- youthful 3
- acoustic guitar 2
- acoustic guitar accompaniment 2
- auto harp 2
- banjo 2
- brass band 2
- bright 2
- bright drumming 2
- buoyant 2
- cello 2
- clapping 2
- concert 2
- country folk music 2
- country music 2
- engaging 2
- exciting 2
- festive 2
- folk music 2
- foreign language 2
- high-spirited 2
- infectious drumming 2
- instrumental music 2
- live audience 2
- medium fast tempo 2
- medium tempo 2
- merry 2
- passionate 2
- people talking 2
- perky 2
- poor audio quality 2
- rhythmic acoustic guitar 2
- simple 2
- spanish guitar 2
- sunny 2
- synthesiser arrangements 2
- vibrant 2
- warm 2
- accordion melody 1
- accordion solo 1
- acordion harmony 1
- acoustic guitar strumming 1
- amateur brass band 1
- amateur home recording 1
- amateur recording 1
- ambient noises 1
- amplified harmonica 1
- anthem 1
- backup vocals 1
- band 1
- bells chining 1
- birthday celebration 1
- birthday song 1
- bluegrass 1
- bongos 1
- bouncy 1
- brass 1
- brass quartet 1
- breezy 1
- bustling music 1
- busy 1
- carefree 1
- catchy 1
- celebration 1
- cheering 1
- chirpy 1
- clarinet 1
- classic 1
- classical music 1
- colourful 1
- composer 1
- congas beats 1
- cornets 1
- crowd’s favourite 1
- cymbals 1
- dance music 1
- determination 1
- digital drum 1
- digital drums 1
- digital music 1
- documentary 1
- duet 1
- edm 1
- electro pop 1
- electronic music 1
- electronica 1
- emphatic singing 1
- emphatic solos 1
- emphatic vocals 1
- energetic drumming 1
- energy 1
- enjoyable 1
- entertaining 1
- enthusiastic electric guitar harmony 1
- enthusiastic vocals 1
- exciting journey 1
- female vocals 1
- fervent 1
- fiddle 1
- folk 1
- folk dance 1
- folk song 1
- french horns 1
- funky bass lines 1
- galloping rhythm 1
- gig 1
- groovy bass line 1
- groovy bass lines 1
- hand drums 1
- happy birthday song 1
- harmonica lesson 1
- harmonica solo 1
- high energy 1
- high spirited 1
- home music video 1
- infectious 1
- inferior audio quality 1
- interview 1
- italian foot ball team 1
- italian music 1
- italian song 1
- joyful 1
- jungle bells 1
- latin influence music 1
- latin pop 1
- latin song 1
- lighthearted 1
- lively backup 1
- lively keyboard harmony 1
- lively vocals 1
- loud 1
- loyalty 1
- male vocalists 1
- male voices interaction 1
- mandolin 1
- march like drum beat 1
- march like drumming 1
- melodic spanish guitar 1
- memdium tempo 1
- men talking 1
- movie soundtracks 1
- pandeireta 1
- party music 1
- party song 1
- people cheering 1
- people whistling and clapping 1
- piano accompaniment 1
- playful 1
- pleasant 1
- pop 1
- popular song 1
- positive 1
- promotion 1
- punchy 1
- regional song 1
- remix 1
- review 1
- salsa music 1
- science fiction fans 1
- shakers 1
- simple joys 1
- simple melody 1
- singing along 1
- space travel 1
- spanish 1
- spanish song 1
- spirited paino 1
- sportsmanship 1
- star wars theme 1
- steady bass lines 1
- string harmony 1
- string quartet 1
- string trio 1
- stringed instrument harmony 1
- studio performance 1
- superimposed vocals 1
- syncopated music 1
- synthesiser arrangement 1
- tambourine beats 1
- techno music 1
- techno pop 1
- techno remix 1
- tenor sax 1
- trombone 1
- trumpet 1
- trumpets 1
- tuba 1
- tutorial 1
- ukrainian song 1
- unity 1
- upbeat music 1
- vigorous banjo 1
- vigorous drumming 1
- viola 1
- violin 1
- vivacious 1
- vocalisation 1
- wedding music 1
- western classical 1
- western classical music 1
- wind band repertoire 1
- wind instrument 1
- wind of provence 1
- world music 1
- xylophone 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Українська Весільна Музика 9 (Ukrainian Wedding Music 9) | This song is a lively Ukrainian duet. The tempo is fast and upbeat with a bright keyboard harmony, infectious drumming , groovy bass line and rhythmic acoustic guitar. The music is energetic, enthusiastic, lively, high-spirited , cheerful, happy, warm, buoyant and catchy with a simple melody. This song is a Ukrainian Pop song. | 2009-11-29T18:52:15Z | UAWaveofMusic | Українська Весільна Музика!!!!! ENJOY AND PLEASE SUBSCRIBE!!!!!! | ["Jazz", "Music", "Wedding music", "Rhythm and blues"] | ["duet", "fast tempo", "upbeat", "ukrainian song", "spirited", "enthusiastic", "energetic", "buoyant", "bright", "colourful", "catchy", "simple melody", "cheerful", "high-spirited", "pop", "foreign language", "infectious", "folk", "regional music", "keyboard harmony", "groovy bass lines", "infectious drumming", "galloping rhythm", "rhythmic acoustic guitar"] | 7 | 0ADP-O_V3vA | 129 | |
The Muddy Hill Boys - Bluegrass To Rockin'The Country Jamboree | A group of male vocalists sing this happy, upbeat country /bluegrass song. The tempo is fast with vigorous and animated acoustic guitar, banjo, mandolin and auto harp lead and harmony. The song is a live performance with ambient sounds of clapping, cheering and people talking. This song is a cheerful Country Pop/Bluegrass song. | 2015-04-05T21:37:46Z | chrisdixie1 | https://www.facebook.com/themuddyhillboys?fref=ts Rockin' The Country Jamboree N°1 - à TOURS 37 FRANCE organisé par DiscOldies le 28/03/2015 | ["Banjo", "Country", "Music", "Rock and roll", "Bluegrass"] | ["male vocalists", "fast tempo", "cheerful", "happy", "acoustic guitar", "vigorous banjo", "auto harp", "mandolin", "ambient noises", "clapping", "cheering", "people talking", "live performance", "gig", "concert", "cheering", "country music", "country folk music", "bluegrass", "inferior audio quality", "amateur recording", "lively", "spirited", "enthusiastic", "vivacious", "youthful", "happy", "celebratory", "festive"] | 7 | 0XxinBtKouQ | 179 | |
マーチ「プロヴァンスの風」 パート別Ⅲ 木管中低音域・打楽器 | This music is a lively instrumental. The tempo is fast with a drum beat introduction, saxophone solo, piano solo, followed with lively harmony of the tenor sax and march like drumming. This piece is the song introduction. It is a lively, cheerful, happy, celebratory and youthful Western Classical. | 2015-02-14T15:30:19Z | stbs44 | 本物の演奏ではないので、その点はご了承ください。 マーチ「プロヴァンスの風」の木管楽器中低音域と打楽器のパート別動画です。 ⑪0:00~ アルトクラリネット ⑫3:27~ テナーサックス ⑬6:55~ 木管低音(バスーン・バスクラ・バリサク) ⑭10:22~ ティンパニ・シロフォン・グロッケン ⑮13:50~ 打楽器 ◆全パート、一部箇所にピアノの補助演奏があります。 ◆スネアドラムのrimショットがうまく再現されていません。 コメント等バンバン書きこんでいってください。 | ["Brass instrument", "Saxophone"] | ["instrumental", "fast tempo", "tenor sax", "energetic drumming", "wind of provence", "classical music", "western classical", "lively", "cheerful", "happy", "celebratory", "youthful", "emphatic solos", "piano accompaniment", "march like drum beat", "wind band repertoire", "lively", "energetic", "enthusiastic"] | 7 | 0u4gY1bBUwQ | 220 | |
Puerto Vallarta Jazz Music Restaurant | This music is instrumental. The tempo is fast with an upbeat keyboard harmony, bright drumming, energetic electric guitar and synthesiser and digital drum arrangements. There is an interaction between two men superimposed over the music. The music is lively, cheerful, happy, positive, upbeat, warm and heartening. This is the background score for an Interview or documentary. | 2013-11-01T04:27:06Z | Puerto Vallarta Mexico | https://toursinvallarta.com/ Puerto Vallarta Jazz Music Restaurant. The Smooth Jazz Cruise: The Greatest Party at Sea Puerto Vallarta. As the perennially sold-out sailings of The Smooth Jazz Cruise: The Greatest Party at Sea prepares to launch its 10th anniversary excursions in January 2013, parent company Entertainment Cruise Productions is determined to keep the party going strong by creating a West Coast outing from San Diego to exotic Mexican ports in the fall of 2013 with music hosts Brian Culbertson and Boney James. Grammy winners David Sanborn and Marcus Miller will perform on the new program and continue to serve as the music hosts of the traditional January sailing of The Smooth Jazz Cruise in 2014 that will embark from Fort Lauderdale to Caribbean paradise as it has done for a decade. Both 7-day cruises will be held aboard a luxurious Holland America ship and feature performances by legends, hitmakers and fan favorites. "As we enter the second decade of The Smooth Jazz Cruise, we want to keep things fresh for our loyal family of cruisers that comes back year after year. Thanks in part to their suggestions, we decided to spread the love by creating a sensational West Coast cruise. With a cruise on both coasts, we feel that the hosts should reflect the different personalities of each coast. I cannot imagine a more exciting cruise menu than Brian Culbertson and Boney James hosting a West Coast cruise and David Sanborn and Marcus Miller topping an East Coast cruise. Brian, Boney, David and Marcus will perform on both cruises as will Jonathan Butler and Candy Dulfer. We're going to showcase 22 incredible headliners between the two cruises," said Michael Lazaroff, Executive Director of St. Louis-based Entertainment Cruise Productions. The first-ever left coast departure for The Smooth Jazz Cruise, the West Coast expedition will make its maiden voyage on the m/s Westerdam October 12-19, 2013 from San Diego and visit Cabo San Lucas, Puerto Vallarta and Baja Coast. Joining Culbertson, James, Sanborn, Miller,… | ["Jazz", "Music", "Speech"] | ["instrumental", "fast tempo", "upbeat music", "review", "men talking", "interview", "documentary", "promotion", "keyboard harmony", "bright drumming", "enthusiastic electric guitar harmony", "groovy bass line", "digital drum", "synthesiser arrangements", "male voices interaction", "superimposed vocals", "upbeat", "enthusiastic", "cheerful", "positive", "vibrant", "happy"] | 7 | 3ujGrObyefA | 518 | |
Prieta Linda "Adrian Duran y Fred Mancilla" | This song is a lively instrumental. The tempo is medium fast with an enthusiastic accordion harmony and acoustic guitar accompaniment. The music is spirited, melodious, warm, cheerful, happy, vivacious and colourful. This music is a Folk song instrumental. | 2011-07-20T01:59:52Z | chikiturris1 | para contractiones # (714) 579-9074 Chubbz # (909) 277- 8651 Nanas | ["Accordion"] | ["instrumental", "medium fast tempo", "acordion harmony", "acoustic guitar accompaniment", "lively", "cheerful", "happy", "warm", "enthusiastic", "energetic", "vibrant", "folk music"] | 7 | 6dFCMXNlmzQ | 773 | |
Banda musicale dell'arma dei carabinieri.Italia.Москва.brass band | This music is a lively instrumental. The tempo is fast with an enthusiastic Brass and wind instrument harmony. The vigorous trumpets, trombone and tuba accompaniment, along with clanging cymbals and playful clarinet make for an upbeat, cheerful, happy, energetic and Perky Band Music. | 2012-09-04T16:25:29Z | umo61 | Спасская Башня.Кремль.Красная Площадь.Orchestra Carabineros.Militari orchestra Italia.оркестр Италии.духовые инструменты.winds. | ["Brass instrument", "Clarinet"] | ["instrumental", "fast tempo", "enthusiastic", "brass band", "cheerful", "happy", "bright", "fun", "engaging", "perky", "peppy", "bright", "energetic", "lively", "spirited", "cymbals", "clarinet", "trumpet", "tuba", "trombone", "wind instrument", "brass", "band", "engaging"] | 7 | Aak-VLHtFPM | 1142 | |
SOUL VIBRATION - Frequenza reggae | A male vocalist sings this vivacious latin pop song. The tempo is fast with rhythmic Spanish guitar,keyboard harmony, bright drumming, mandolin harmony, groovy bass line and lively pandeira beats. The song is melodic, simple, happy, cheerful, bouncy, peppy , warm and joyful. | 2010-08-30T17:45:36Z | AstonBarret | SOUL VIBRATION - Frequenza reggae - REGGAE MATERA | ["Music", "Soul music"] | ["male vocalist", "fast tempo", "latin pop", "latin song", "banjo", "spanish guitar", "keyboard harmony", "bright drumming", "world music", "regional music", "happy", "cheerful", "enthusiastic", "warm", "sunny", "upbeat", "pleasant", "funky bass lines", "pandeireta", "rhythmic acoustic guitar"] | 7 | CP3phqztym0 | 1360 | |
Star Wars Theme - BSO French Horns | The song is an instrumental. The song is medium tempo with a brass quartet playing French horns playing a well known movie soundtrack to the crowds cheering, clapping and whistling. The sound quality is bad with ambient crowd noise. | 2015-12-11T18:42:35Z | HelpingUpMission | Getting excited about the new Star Wars movie? Some of our men are... Yesterday, four musicians from the Baltimore Symphony Orchestra gifted us with a beautiful concert of Christmas music on French horns. As they announced their finale, several men called out from the audience, requesting the Star Wars theme... and they performed it on the fly as an encore! Thanks to Jeannie Getz, David Smith, Shona Goldberg-Leopold, and Ken Bell: talented musicians with a good sense of humor. | ["Brass instrument", "French horn"] | ["brass band", "people cheering", "cornets", "enthusiastic", "cheerful", "home music video", "crowd’s favourite", "enjoyable", "exciting", "passionate", "science fiction fans", "exciting journey", "space travel", "french horns", "star wars theme", "brass quartet", "live audience", "people whistling and clapping", "poor audio quality", "amateur brass band", "memdium tempo", "movie soundtracks", "instrumental music"] | 1 | DLDZrtwyY_Y | 1465 | |
watra safi | This music is an energetic instrumental. The tempo is fast with a regional string instrument playing the lead with hand percussion like a small hand drum, tambourine and shaker beats. The music is lively, cheerful, happy, youthful, buoyant, enthusiastic, sunny and celebratory with a peppy dance groove. This music is Folk dance music. | 2011-12-31T18:18:01Z | watrasafi2012 | ["Music of Africa", "Music", "Musical instrument", "Rattle (instrument)"] | ["instrumental", "fast tempo", "tambourine beats", "peppy", "enthusiastic", "happy", "cheerful", "simple", "celebratory", "festive", "simple joys", "sunny", "bouncy", "folk music", "regional music", "folk dance", "stringed instrument harmony", "hand drums", "shakers"] | 7 | FAhfuP_xh5Y | 1620 | ||
Electret Condenser Microphone Wiring | This music is an enthusiastic instrumental. The tempo is fast with an amplified harmonica solo. The music is lively, animated, happy, cheerful, energetic, enthusiastic and peppy. | 2013-08-14T13:45:16Z | John Salmon | Please note I have drawn the capacitor with the wrong polarity marker. The + side should be connected to the resistor before the battery. Watch my other video for a more up to date video using an electret mic. http://youtu.be/B_BDtYSDQ9g | ["Harmonica", "Wind instrument, woodwind instrument"] | ["instrumental", "fast tempo", "harmonica solo", "loud", "playful", "energetic", "peppy", "happy", "animated", "enthusiastic", "cheerful", "amplified harmonica", "harmonica lesson", "tutorial"] | 7 | FYFapDVOFHg | 1648 | |
Jingle Bells - Techno Remix | This music is an upbeat instrumental of the popular Christmas carol, ‘Jingle Bells’. The tempo is fast with electronic arrangements and digital drumming. The music is buoyant, happy, cheerful, festive, perky, enthusiastic,energetic and high spirited. This song is a Techno Remix. | 2011-12-20T16:19:24Z | OX-DEXTER-XO | Remix By: TranceDevotee (From the Old Account) Original song: Jingle Bells (Written by James Lord Pierpont) ***I DO NOT claim ownership of this song as it belongs to its aforementioned owners*** | ["Electronic music", "Jingle (music)", "Music", "Techno"] | ["instrumental", "fast tempo", "electronic music", "digital music", "synthesiser arrangement", "digital drums", "techno music", "electronica", "electro pop", "techno pop", "edm", "jungle bells", "remix", "techno remix", "energetic", "enthusiastic", "punchy", "buoyant", "cheerful", "happy", "merry", "high-spirited"] | 7 | JOkuwbhMxbQ | 2000 | |
Sergio el duende ( y yo le canto al amor...) | A male vocalist sings this energetic song. The tempo is fast emphatic vocals, bright acoustic guitar accompaniment and clap beat. The song is youthful, energetic, popular, cheerful, engaging and happy. The music is minimal with ambient sounds of people clapping, cheering, singing along and keeping beat with claps. The audio is distorted and muffled as it is an amateur home recording. | 2013-07-09T13:09:10Z | Maria Luisa Asencio | ["Singing", "Music", "Musical instrument", "Clapping"] | ["male vocalist", "fast tempo", "acoustic guitar accompaniment", "spanish guitar", "lively", "entertaining", "enthusiastic", "party song", "happy", "joyful", "cheerful", "youthful", "clapping", "singing along", "people talking", "emphatic vocals", "amateur home recording", "spanish song", "popular song"] | 7 | PN3Lx8RutmI | 2529 | ||
HAPPY BIRTHDAY SONG - FELIZ CUMPLEAñOS SALSA MUSIC | A male vocalist sings this cheerful classic Happy Birthday song. The tempo is fast and high spirited with animated trumpets, enthusiastic, syncopated piano accompaniment, energetic congas and bongos beats, spirited drumming, tambourine beats and vocal backup. The music is loud, bustling, hyper, high-energy and a little bit syncopated. It is fun, cheerful, celebratory and happy. | 2009-05-30T03:41:52Z | EL BAILADOR | Happy birthday song- Feliz cumpleaños salsa music . Feliz cumpleaños para la persona especial que tu eres. "Happy Birthday to You", also known more simply as "Happy Birthday", is a traditional song that is sung to celebrate the anniversary of a person's birth. According to the 1998 Guinness Book of World Records, "Happy Birthday to You" is the most well recognized song in the English language, followed by "For He's a Jolly Good Fellow" and "Auld Lang Syne". The song's base lyrics have been translated into at least 18 languages. | ["Music", "Salsa music"] | ["instrumental", "fast tempo", "animated", "trumpets", "classic", "backup vocals", "xylophone", "happy birthday song", "birthday song", "celebration", "birthday celebration", "birthday song", "congas beats", "bongos", "keyboard harmony", "vigorous drumming", "syncopated music", "spirited paino", "latin influence music", "salsa music", "busy", "bustling music", "happy", "cheerful", "enthusiastic"] | 7 | Vx4aO4-nr0c | 3045 | |
My Guinea-pigs ate the Christmas Tree... | A female vocalist sings this cheerful song. The tempo is fast with a peppy keyboard harmony, simple, march like drumming, steady bass line, acoustic guitar and bells chiming. The song is a foreign language but from the sound and vibe of it, it seems like a fun, happy, joyful, cheerful, warm hearted and popular folk song. | 2006-12-20T16:35:29Z | Havshexan | This may happen if you let the guinea pigs loose on a Christmas tree... Next day there was nothing left but some small peices of wood. The tree in the video is a Scandinavian spruce (picea abies) and it's not poisonous. There are other species of evergreens that are poisonous, like for exemple silver spruce. Don't give any branches to your guinea-pigs, if you aren't sure what they are! Even the spruce in the video contains etheric oils which could be harmful in large quantities. Some of the oils evaporate if you keep the brances a few day's before giving them to the piggies. Sadly, all the cute cavies in the video but one have gone to guinea pig heaven. Now there's only Olga left and she just turned 7 years (beginning of December 2011). Fortunatly she now has 3 new compagnions. | ["Music", "Happy music"] | ["female vocals", "fast tempo", "foreign language", "folk song", "regional song", "enthusiastic vocals", "energetic", "emphatic singing", "peppy", "spanish", "keyboard harmony", "bells chining", "steady bass lines", "enthusiastic", "fun", "happy", "cheerful", "upbeat", "enthusiastic", "perky", "march like drumming"] | 7 | ar4YQ_DOcyk | 3578 | |
J.Mouret - Rondeau String Quartet | The song is an instrumental. The song is medium tempo with a violin, viola, cello playing a string harmony accompanied by an acoustic guitar strumming chords. The song is a western classical music piece. | 2012-06-04T17:03:48Z | cellony | ["Cello", "Double bass", "Violin, fiddle", "Bowed string instrument"] | ["violin", "viola", "cello", "acoustic guitar strumming", "poor audio quality", "wedding music", "party music", "string quartet", "string trio", "string harmony", "instrumental music", "western classical music", "live performance", "studio performance", "medium tempo", "exciting", "cheerful", "dance music", "composer", "enthusiastic", "passionate", "exciting"] | 1 | fxznho_kNPY | 3995 | ||
Inno Ufficiale Torino Calcio | This song is a Latin Football team anthem. The song is medium tempo with lively keyboard, flute harmony, synthesiser arrangements , shakers and infectious drumming. The song is youthful, energetic,encouraging, celebratory, cheerful and happy. | 2012-11-30T16:01:45Z | alexone97able | Questo è l'inno a parer mio piu bello del torino | ["Music of Africa", "Music"] | ["male vocalist", "medium tempo", "italian song", "cheerful", "upbeat", "engaging", "high spirited", "italian music", "italian foot ball team", "anthem", "energetic", "enthusiastic", "cheerful", "determination", "unity", "sportsmanship", "energy", "loyalty", "fervent", "melodic spanish guitar", "infectious drumming", "lively keyboard harmony", "synthesiser arrangements"] | 7 | p4T1pddBia0 | 4686 | |
The Seldom Scene - After Midnight | A male vocalist sings this high energy Country Song. The tempo is fast with animated Banjo, fiddle, auto harp, acoustic guitar and cello. The song is cheerful, happy, enthusiastic, fervent, pulsating, buoyant and animated with vocalising and backup. This song is a spirited Country Folk Song. | 2008-01-14T14:52:51Z | BluegrassLibrary | John Duffey, Ben Eldridge, Mike Auldridge, Phil Rosenthal, & Tom Gray | ["Banjo", "Country", "Music", "Musical instrument", "Song", "Bluegrass"] | ["male vocalist", "fast tempo", "country music", "lively vocals", "lively backup", "banjo", "cello", "auto harp", "fiddle", "acoustic guitar", "country music", "country folk music", "vocalisation", "high energy", "fun", "merry", "cheerful", "live performance", "concert", "live audience", "enthusiastic", "animated", "regional music"] | 7 | q-sJu8CoZts | 4750 | |
online 2 battle il-2 video | This music is a simple and pleasing instrumental. The tempo is medium fast with a cheerful accordion harmony. The music is minimalist,simple, cheerful, happy, fun, carefree, jolly and lighthearted. | 2009-07-12T04:42:37Z | Technonoob | short vid of ingame footage | ["Accordion"] | ["instrumental", "medium fast tempo", "lighthearted", "accordion melody", "accordion solo", "lively", "simple", "fun", "breezy", "cheerful", "chirpy", "enthusiastic", "carefree"] | 7 | tDVOUsG52Jw | 5015 |
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;