musiccaps_details (view)
17 rows where musiccaps_aspects contains "ambient sounds" and musiccaps_aspects contains "live performance"
This data as json, CSV (advanced)
musiccaps_aspects (array) 209 ✖
- ambient sounds · 17 ✖
- live performance · 17 ✖
- live audience 10
- instrumental 9
- amateur recording 7
- fast tempo 6
- medium tempo 6
- clapping 5
- lively 5
- classical 4
- emotional 4
- inferior audio quality 4
- people talking 4
- spirited 4
- concert 3
- keyboard harmony 3
- loud 3
- passionate 3
- youthful 3
- acoustic guitar accompaniment 2
- bagpiper 2
- buoyant 2
- cheering 2
- dj 2
- dj mixer 2
- energetic 2
- engaging 2
- enthusiastic 2
- fans cheering 2
- folk music 2
- folk song 2
- foreign language 2
- high notes 2
- hysteria 2
- indian classical 2
- male vocalist 2
- medium fast tempo 2
- minimalist 2
- muffled audio 2
- outdoor performance 2
- poor audio quality 2
- rhythmic acoustic guitar 2
- slow tempo 2
- techno music 2
- violin harmony 2
- acordian harmony 1
- acordion harmony 1
- acoustic 1
- afghan music 1
- afghan song 1
- alternative metal 1
- alternative rock 1
- audience clapping 1
- audience singing along 1
- auditorium acoustics 1
- bass drum 1
- bellows 1
- bellows-blown bagpipe 1
- birds singing 1
- booming 1
- boomy 1
- brass band 1
- calming 1
- catchy vocal riff 1
- chamber instrument 1
- charming 1
- cheerful 1
- christmas carols 1
- christmas concert 1
- christmas song 1
- christmas songs 1
- christmas time 1
- club music 1
- congas beat 1
- country rock 1
- country song 1
- crowd cheering 1
- dance 1
- devotional song 1
- dhol 1
- dixie chicks concert 1
- double reed instrument 1
- drone pipes 1
- droning 1
- electric guitar harmony 1
- electro music 1
- electro pop 1
- electronic drum 1
- electronic music 1
- emphatic vocals 1
- emphatic vocals 1
- entertaining 1
- female singer 1
- female vocalist 1
- female vocalists 1
- female vocals 1
- folk 1
- fourth world music 1
- french horn harmony 1
- futuristic 1
- ghungaroos sound 1
- gig 1
- girl band 1
- groovy 1
- groovy dance beat 1
- happy 1
- hard hitting drums 1
- harmonium melody 1
- haunting 1
- haunting melody 1
- heavily synthesised music 1
- heavy reverb 1
- high pitch 1
- high-spirited 1
- hindi movie song 1
- hindi song 1
- hindu devotion music 1
- hip-hop 1
- humming melody 1
- hypnotic 1
- incoherent music 1
- incoherent sound 1
- indian devotion music 1
- indian music 1
- indian percussion instrument 1
- keyboard 1
- keyboard accompaniment 1
- lilting 1
- lilting melody 1
- lively spanish guitar 1
- lively tabla rhythm 1
- lively trumpets 1
- love song 1
- male harmony 1
- male singer 1
- male singers 1
- melody pie 1
- mesmerising 1
- middle eastern influences 1
- middle eastern music 1
- minimal 1
- modern 1
- muffled sounds 1
- new age music 1
- outdoors 1
- passionate singing 1
- people cheering 1
- people singing 1
- percussive instruments 1
- percussive sounds 1
- piano 1
- piper 1
- pop 1
- popular folk music 1
- powerful vocals 1
- psychedelic 1
- pulsating 1
- raga 1
- rap 1
- regional music 1
- relaxing 1
- resonating 1
- reverb 1
- rhythmic 1
- rhythmic foot tapping 1
- rhythmic oud 1
- rich 1
- robotic sounds 1
- rock 1
- romantic 1
- scratching 1
- sentimental 1
- shakers 1
- sharp sounds 1
- simple 1
- sing introduction 1
- sleep 1
- small pipe harmony 1
- song interlude 1
- song introduction 1
- soothing 1
- spanish 1
- spanish song 1
- sruti 1
- static 1
- steady drumming 1
- synth pop 1
- tabla 1
- tambourine 1
- tambourine beats 1
- tanpura 1
- teen singer 1
- three part harmony 1
- thumping drum beat 1
- trance 1
- trumpet symphony 1
- turn table 1
- turntablist 1
- upbeat 1
- vibrations 1
- vinyl record scratching 1
- vivacious 1
- vocal backup 1
- vocalisation 1
- vocals 1
- western classical music 1
- wind instrument 1
- woodwind 1
- world music 1
musiccaps_names (array) 31 ✖
- Music 13
- Singing 4
- Musical instrument 3
- Bagpipes 2
- Traditional music 2
- Wind instrument, woodwind instrument 2
- Accordion 1
- Bang 1
- Blues 1
- Brass instrument 1
- Choir 1
- Christmas music 1
- Disco 1
- Drum 1
- Electronic music 1
- Exciting music 1
- Flamenco 1
- Hip hop music 1
- Music of Asia 1
- Music of Latin America 1
- Orchestra 1
- Percussion 1
- Rattle (instrument) 1
- Scratching (performance technique) 1
- Synthetic singing 1
- Tabla 1
- Tambourine 1
- Trombone 1
- Trumpet 1
- Wedding music 1
- Yodeling 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
เปียโน สำหรับการนอนหลับ Music for Sleeping by พัชร iHearBand | This is an instrumental classical music performance. There is a gentle tune being played with the piano sound. Ambient sounds such as birds singing can be heard in the recording. The atmosphere is soothing and relaxing. This is a perfect piece for a sleep music playlist. It could also work well as an advertisement jingle. It could be playing in the background at a nursery. | 2011-04-01T05:51:35Z | Pat Kerdsiri | *สำหรับผู้ต้องการบริจาคสนับสนุน หรือต้องการ mp3 ดูด้านล่างสุดของ description ครับ คลิปทำเพื่อผู้ต้องการการผ่อนคลายก่อนนอนครับ ผมเล่นในช่วงดวงอาทิตย์ตกและมืดตอนจบคลิปพอดี เปิดทิ้งไว้ได้เลย 45 นาทีครับ ( อ้อ มีสุนัขเดินผ่านไปๆมาๆเป็นระยะนะครับ :) ก่อนจะเล่นได้ลองศึกษาจาก Wikipedia ว่าเสียงที่จะทำให้ง่วงได้จะมีความซ้ำกันในห้วงของเวลาจึงทำให้เกิดการรวมความคิด และระดับเสียง ( pitch ) ไม่ต่างกันมาก รวมทั้งเลือกใช้คอร์ดที่ทำให้ฟังแล้วสดชื่นไม่ลอยและไม่หลอนเกินจนอาจทำให้ฝันร้าย นอกจากนั้นตลอดคลิปยังมีความดังของเสียงที่เบาลงเรื่อยๆจนจบครับ พัชร เกิดศิริ (ติดต่อวงดนตรีได้ที่ http://www.bit.ly/iHearBand 0868965900 ) สำหรับผู้ที่ต้องการ mp3 สามารถซื้อได้ที่เว็บนี้ https://gumroad.com/l/piano_sleeping ราคา 60บาท คุ้มค่า 45นาที แต่ถ้าไม่สะดวกซื้อบนเว็บ หรืออยากได้ฟรี รบกวนส่งเมล์มาที่ ipattt@ihearband.com ได้ครับ และสำหรับผู้ที่อยากสนับสนุนเปิดหมวก สามารถโอนเงินสิบยี่สิบบาทมาได้ที่ KBANK Patchara Kerdsiri เลขบัญชี 006-2-48915-4 SCB Patchara Kerdsiri เลขบัญชี 329-2-35513-8 ขอขอบพระคุณสำหรับผู้สนับสนุนทุกท่านนะครับ ^_^ | ["Music", "Wedding music"] | ["classical", "instrumental", "piano", "live performance", "ambient sounds", "birds singing", "soothing", "relaxing", "calming", "sleep"] | 9 | 2MpzHv5KNZU | 359 | |
Dada Life - Just BLEEP Me | This music is an upbeat instrumental. The tempo is fast with vigorous digital drumming, synthesiser arrangements and DJ mixer effects. The music is electrifying, pulsating, buoyant, punchy, groovy, youthful and high-spirited. This music is an outdoor live performance with ambient sounds. There are sounds of hysterical fans cheering, clapping and singing along. This music is Futuritic Electronic Pop/ Techno Pop. | 2011-07-19T03:10:45Z | janjubear | Dada Life @ EBC 7.17.11 | ["Disco", "Music"] | ["instrumental", "fast tempo", "dj", "dj mixer", "futuristic", "fourth world music", "psychedelic", "hypnotic", "vocalisation", "catchy vocal riff", "techno music", "hysteria", "live performance", "live audience", "outdoor performance", "ambient sounds", "people singing", "fans cheering", "clapping", "muffled audio", "amateur recording", "heavily synthesised music", "electro pop", "synth pop", "trance"] | 7 | 3zT0aiN2E70 | 526 | |
Afghan song Pashto music Zarsanga beautiful song | A female vocalist sings this lilting Folk song in a foreign language. The tempo is slow with an Oud accompaniment, violin harmony, tabla and dhol rhythm. The performance is live with ambient sounds. The song is simple, sweet, charming and lilting. | 2009-01-14T16:53:16Z | Muhammad Bashir | دوى څومره زوره وردي هريو کاريې دى په وس کې ياران له ما بهتر دي ځکه ښکار يې دى په وس کې ها ښکلې جادوګره کرشمې لري منګول کې اقرار يې دى په لاس کې او انکاريې دى په وس کې رمې رمې ښکلا يې په سازونو کې ده نغښتې شپونکى يار مې اتل دى يکه زار يې دى په وس کې څپې د سين به سپيني وي خو داترې کمه نه ده څارونکى بختور دى چې دا څار يې دى په وس کې Baby girl just look at me And then you'll see How much you mean to me I want only you BooBee... I dream that i could hold you now I would do anything but i dunno how I hope that you'll be mine again Cuz i wanna erase forever that pain. Its too bad that you cant see In spite of everything i tell you How i need you next to me And how much i love you | ["Traditional music", "Music"] | ["female vocalist", "slow tempo", "foreign language", "live performance", "ambient sounds", "lilting melody", "afghan song", "afghan music", "simple", "percussive instruments", "dhol", "tabla", "rhythmic oud", "violin harmony", "classical", "folk song", "folk music", "middle eastern music", "middle eastern influences", "charming"] | 7 | 5FbQu7QTme0 | 647 | |
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 | |
Rashid Jahangir (zamanai poak na hum dum) | This music is an instrumental.the tempo is fast with a harmonium melody and tabla accompaniment. The performance is live with ambient sounds of people talking, sound of glass bangles and a woman’s voice. This music is Indian Classical. | 2008-10-30T22:02:58Z | u297777 | Rashid Jahangir from doda city (J&K) | ["Tabla", "Drum", "Percussion"] | ["instrumental", "fast tempo", "harmonium melody", "indian classical", "raga", "sruti", "classical", "indian percussion instrument", "lively tabla rhythm", "live performance", "live audience", "ambient sounds", "people talking", "ghungaroos sound", "people talking", "lively", "spirited", "song interlude", "sing introduction"] | 7 | EnewI6fNhVA | 1590 | |
nitin chakrdhari katra ( jk ) satyam shivam | A female vocalist sings this Hindi Devotion song. The tempo is slow with keyboard harmony,tambourine beats, violin melody and rhythmic tanpura accompaniment. This clip is the song introduction with slow chants like singing. The song is a Hindu Devotion song to the God Shiva. It is emotional, sentimental, devotional, prayerful praise and worship. There are ambient sounds of people talking and cheering, indicating that this is a live performance. | 2012-03-20T04:43:45Z | NCRC STUDIO | nitin chakrdhari enterainmant perfomer | ["Music of Asia", "Music", "Synthetic singing"] | ["female vocals", "slow tempo", "high pitch", "high notes", "tambourine", "indian classical", "indian devotion music", "hindu devotion music", "indian music", "keyboard harmony", "hindi song", "hindi movie song", "devotional song", "song introduction", "amateur recording", "inferior audio quality", "live performance", "people cheering", "violin harmony", "keyboard", "shakers", "tanpura", "ambient sounds"] | 7 | HdRPdh-cSTw | 1821 | |
Fred Morrison | This music is instrumental. The tempo is fast with a spirited small pipe harmony with rhythmic foot tapping. The music is upbeat, engaging, sharp, humming, haunting, droning and cheerful. This a live performance with ambient sounds of people talking and static as this is an amateur recording. | 2010-02-12T22:46:03Z | Doug Henkle | Recorded on February 6, 2010 using a Flip Video camcorder. | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["instrumental", "fast tempo", "small pipe harmony", "droning", "haunting", "emotional", "passionate", "loud", "humming melody", "amateur recording", "rhythmic foot tapping", "live performance", "live audience", "static", "ambient sounds", "people talking", "bellows-blown bagpipe", "bagpiper", "woodwind", "chamber instrument"] | 7 | IbD0zpcimgM | 1921 | |
Gordon Walker 4 - Glenfiddich Ceilidh 2003 | This music is a lively Bagpiper instrumental. The tempo is fast with a piper playing a cheerful harmony on the bagpiper with an enthusiastic acoustic guitar accompaniment. The music is vibrant, vivacious, vigorous, engaging, cheerful and merry. The performance is live with a live audience and ambient sounds. | 2007-06-29T17:30:17Z | Chris Eyre | The last of 4 clips of Gordon Walker giving a wonderful and entertaining display during the ceilidh at the New Scotland Hotel in Pitlochry on the evening following the Glenfiddich competition at Blair Castle. | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["instrumental", "fast tempo", "bagpiper", "acoustic guitar accompaniment", "live performance", "live audience", "ambient sounds", "lively", "spirited", "rich", "drone pipes", "melody pie", "bellows", "double reed instrument", "piper", "passionate", "spirited", "emotional", "high-spirited", "engaging", "mesmerising", "sharp sounds", "high notes"] | 7 | JjF1G5wgcvY | 2028 | |
Chicas Roland's - Cumbia - El Hijo De Tuta | A female vocalist sings this Spanish melody. The tempo is medium with keyboard harmony, tambourine beats, rhythmic congas and acoustic guitar. The song is upbeat, buoyant, groovy, lively, spirited,youthful and engaging. This is an outdoor live performance as there are ambient sounds like gentle wind, people talking, clapping and cheering. This song is a lively Spanish Pop song. | 2008-06-13T21:36:48Z | Palmeras Disco | Video "del Baul De Los Recuerdos" de Las Chicas Roland's interpretando la cumbia "El Hijo De Tuta" en Junio del 2002. Espero les guste... | ["Singing", "Music", "Rattle (instrument)"] | ["female singer", "medium tempo", "pop", "spirited", "lively", "buoyant", "engaging", "vivacious", "spanish", "amateur recording", "muffled audio", "acordion harmony", "congas beat", "keyboard accompaniment", "rhythmic acoustic guitar", "live performance", "outdoors", "ambient sounds", "people talking", "cheering", "clapping", "inferior audio quality", "groovy dance beat", "buoyant", "youthful", "tambourine beats"] | 7 | Py8Vd0-qxYU | 2583 | |
Cel ce legi rani care dor-grup burla&horodnic | A group of male vocalists sing this charming melody in a foreign language. The tempo is fast with accordion lead music and acoustic guitar accompaniment. The song is lively, happy, light , warm, cheerful and charming . The audio quality is inferior as it seems to be an amateur home recording with ambient sounds. This Song is a Folk song. | 2011-11-13T02:38:31Z | dorin juravle | Dorin Gach, Dorin Medrihan, Valy Motac, Florin Motac, Danut Covali, Cornel Mihalescu | ["Traditional music", "Music", "Musical instrument", "Accordion"] | ["male singers", "male harmony", "fast tempo", "rhythmic acoustic guitar", "acordian harmony", "lively", "loud", "folk music", "emotional", "passionate singing", "three part harmony", "live performance", "ambient sounds", "inferior audio quality", "cheerful", "upbeat", "happy", "foreign language"] | 7 | QHCHK-NPO_U | 2607 | |
DJ Q-Bert "Method Man" scratch 2009 | This music is instrumental. The tempo is medium fast with boomy bass, turntable scratching and digitally arranged music. The music is muffled as the audio quality is inferior but the beats are punchy, buoyant, bouncy, youthful, groovy and energetic. This music is a turntable scratching technique. | 2009-09-16T00:20:26Z | Trikpah | DJ Q-Bert live 2009 | ["Scratching (performance technique)", "Music", "Musical instrument", "Hip hop music"] | ["instrumental", "medium fast tempo", "boomy", "live performance", "live audience", "ambient sounds", "reverb", "resonating", "robotic sounds", "turn table", "scratching", "dj", "dj mixer", "club music", "pulsating", "vibrations", "booming", "vinyl record scratching", "youthful", "new age music", "techno music", "electro music", "percussive sounds", "rhythmic", "turntablist", "hip-hop", "rap"] | 7 | YJKZVSvz1Bk | 3274 | |
Justin Bieber singing Christmas songs in Washington 2011 (perfoming for Obama!).mp4 | A male vocalist sings this Christmas song. The tempo is medium with minimal instruments like keyboard harmony and steady drumming. The audio quality is inferior so the music is incoherent. This is a live performance with ambient sounds of people clapping and cheering. This is a contemporary Christmas Song. | 2012-03-17T20:04:17Z | virgi92dT | Yeeeee!!! 1. Mistletoe 2. Away in a manger 3. a classic Christmas song featuring with Obama | ["Christmas music", "Singing", "Music", "Choir"] | ["male singer", "teen singer", "medium tempo", "vocal backup", "keyboard harmony", "steady drumming", "poor audio quality", "incoherent music", "emphatic vocals", "live performance", "ambient sounds", "clapping", "christmas song", "christmas time", "christmas concert", "live performance", "live audience", "heavy reverb"] | 7 | ZNGJN30LCwM | 3369 | |
Juan Fernando canta fandangos de Huelva en Amsterdam | A male vocalist sings this powerful solo in a foreign language. The tempo is medium with a spanish guitar accompaniment. The song has minimalist music with captivating, lilting and almost haunting vocals. This is a live performance with ambient sounds of people talking. The audio quality is inferior as it is an amateur recording. This song is a Latin/Spanish Folk song. | 2010-08-06T14:25:01Z | coroflamenco | Juan Fernando en un concierta del cuadro de cante de la Peña Flamenca de Huelva y del coro flamenco Calle Real en Amsterdam. Toque Antonio Dovao, Ramón Jesús Díaz. Baile: Teresa Jaldón, Director de cine: Stijn van der Loo, studio BBH | ["Singing", "Yodeling", "Flamenco", "Music", "Music of Latin America"] | ["male vocalist", "medium tempo", "spanish song", "minimalist", "folk song", "regional music", "popular folk music", "lively spanish guitar", "emphatic vocals", "powerful vocals", "live performance", "live audience", "ambient sounds", "people talking", "lilting", "haunting melody", "vocals"] | 7 | _zQTlTCqMzs | 3508 | |
Dixie Chicks Taking the Long Way Live | A girl band sings this lively song. The tempo is medium with vibrant music. The audio quality is inferior so the music and vocals are incoherent. This is a live performance with ambient sounds of fans cheering, clapping and singing along. This song is a hit Country Rock. | 2006-08-02T22:04:41Z | Susanne Goldstone Rosenhouse | Live from Madison Square Garden. Natalie's introduction to New York fans then Taking the Long Way Live. Oh, and a little bit of me singing along and cheering. Didn't know my camera would pick that up. :) Hope y'all enjoy! | ["Singing", "Electronic music", "Music", "Bang"] | ["female vocalists", "medium tempo", "live performance", "country rock", "folk", "world music", "acoustic", "country song", "youthful", "enthusiastic", "energetic", "entertaining", "folk", "concert", "incoherent sound", "amateur recording", "live audience", "girl band", "dixie chicks concert", "ambient sounds", "fans cheering", "clapping", "hysteria"] | 7 | aGMdcxeF6Ak | 3524 | |
Alpenblech - Baritone in der Nacht | This music is a lively instrumental. The tempo is fast with bright trumpet harmony of French horns, trumpets accompaniment and a steady, punchy bass drum rhythm. The music is upbeat, punchy, buoyant, spirited, lively and vivacious. The audio quality is an amateur recording. This music is a live performance with ambient sounds of people clapping and cheering . | 2008-09-21T04:23:44Z | polkasignorina | Blasmusik vom Feinsten! Solisten: Markus Mikusch und Peter Seitz Infos auf www.alpenblech.de | ["Brass instrument", "Music", "Musical instrument", "Tambourine", "Trombone", "Trumpet"] | ["instrumental", "fast tempo", "brass band", "classical", "western classical music", "trumpet symphony", "live performance", "concert", "live audience", "clapping", "cheering", "ambient sounds", "gig", "inferior audio quality", "amateur recording", "lively trumpets", "thumping drum beat", "bass drum", "lively", "spirited", "energetic", "enthusiastic", "buoyant", "french horn harmony", "wind instrument"] | 7 | br4A2uNud50 | 3660 | |
Trans-Siberian Orchestra (Finale!) LIVE in Denver 2012 | This music is instrumental. The tempo is fast with a loud, lively keyboard , hard hitting drums and electric guitar melody. The audio is muffled so it is hard to hear the other instruments. This performance is live with ambient sounds of audience cheering, clapping and singing along. This music is a Christmas Carol instrumental. | 2012-11-19T21:53:46Z | Ryan Keith | This is the finale of the Trans-Siberian Orchestra at Pepsi Center in Denver, CO 11/18/2012. So epic! I recorded this but the music does not belong to me! | ["Orchestra"] | ["instrumental", "medium fast tempo", "poor audio quality", "amateur recording", "hard hitting drums", "keyboard harmony", "loud", "muffled sounds", "christmas songs", "christmas carols", "concert", "live performance", "ambient sounds", "crowd cheering", "audience clapping", "outdoor performance", "live audience", "electric guitar harmony", "audience singing along"] | 7 | jPBg5cR8XeA | 4250 | |
London Music Submarine: Ben See - Moment.Sound.Blur. | This is a live recording of an instrumental electronic music beat. The rhythmic foundation of the beat consists of a simple medium tempo electronic drum beat. There are sounds coming from the background resembling a restaurant. It is a minimal-sounding groovy beat that is also danceable. With the removal of ambient sounds and a clean mix, this track could be used in the soundtrack of a TV show with an urban setting. | 2012-02-13T14:11:20Z | LondonMusicSubmarine | London musician/vocalist Ben See performs an intimate collection of songs for the LMS Showcase. A small crowd gathers in a warm room in North London. Here are some snippets from Moment.Sound.Blur. All rights owned by London Music Submarine & Ben See © 2012 | ["Music", "Exciting music"] | ["live performance", "instrumental", "electronic music", "electronic drum", "medium tempo", "groovy", "dance", "modern", "minimal", "ambient sounds"] | 9 | qwOLhVbuhpM | 4836 |
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;