musiccaps_details (view)

26 rows where musiccaps_aspects contains "low quality" and musiccaps_names contains "Folk music"

✎ View and edit SQL

This data as json, CSV (advanced)

video youtube_link musiccaps_caption youtube_published youtube_channel youtube_description musiccaps_names musiccaps_aspects musiccaps_author youtube_id musiccaps_rowid
: Pavana el Todesco : Renaissance italian music : The low quality recording features a renaissance music that consists of soft wooden percussion and mellow, harmonized flute melody playing on top of it. The recording is a bit noisy, but it also sounds soulful, mellow, passionate, emotional and vintage - It really puts the listener in a period of renaissance. 2008-04-04T02:38:02Z Coui0112358 Renaissance music ["Theme music", "Folk music", "Music"] ["low quality", "noisy", "renaissance music", "soft wooden percussions", "mellow harmonized flute melody", "mellow", "soulful", "passionate", "emotional", "vintage"] 4 -7wUQP6G5EQ 18
Arany Zoltán & World Music Syndicate - La molinera The low quality recording features a live performance that consists of fruity male vocal singing over accordion melody, acoustic rhythm guitar chords and shimmering bells. It sounds emotional and hopeful. The recording is a bit noisy and in mono, as it was probably recorded with a phone. 2013-12-20T09:55:03Z Arany Zoltán https://www.facebook.com/Arany-Zolt%C3%A1n-Music-274856225999515/ http://aranyzoltan.hu/ Arany Zoltán - fiddle Gonda Szabolcs - guitar Gonda "Sikh" Zoltán - bass Huszti László - percussion Mangu Róbert - percussion Made by Kilincsfilm ["Folk music", "Acoustic guitar", "Music", "Middle Eastern music"] ["low quality", "live performance", "fruity male vocal", "accordion melody", "acoustic rhythm guitar", "shimmering bells", "emotional", "hopeful", "mono", "noisy"] 4 -nlkWWphiaM 85
Ghunghroo Toot Ga'ay...!!! The low quality recording features a harmonizing throaty male vocal singing over dissonant strings melody in the background. It sounds traditional and hopeful. 2010-01-10T15:12:56Z ساقی حسن Maqbool Sabri ["Carnatic music", "Mantra", "Folk music", "Music", "Middle Eastern music", "Sitar"] ["harmonizing throaty male vocal", "strings dissonant background melody", "low quality", "traditional", "hopeful"] 4 3tbFP_JKzXw 514
bajarangi dar pe hum tere roz ayenge The low quality recording features a traditional song that consists of a passionate male vocal singing over breathy flute melody, shimmering tambourine, claps, wooden percussion and strings melody. It sounds passionate and emotional. 2011-06-30T03:54:31Z hanumanmaharaj karne vandan charno mein bajarangi dar pe hum tere roz ayenge - hanuman bhajan by gulshan kumar taken from album hanuman chalisa ["Folk music"] ["low quality", "traditional", "passionate male vocal", "breathy flute melody", "strings melody", "wooden percussions", "shimmering tambourine", "claps", "passionate", "emotional"] 4 5AdeNHlPnvs 639
Upgrade Music vs. Jeon - Ataniro & Ritmo - Amor Cruel The low quality recording features a latin urban song that consists of a passionate male vocal, alongside wide harmonizing vocals, singing over punchy kick and snare hits, shimmering cymbals, funky electric guitar melody, synth pad chords, groovy bass and synth keys melody. It sounds energetic and addictive. 2014-05-19T23:20:11Z Javier' Abreu Upgrade Music Aruba - Amor Cruel ["Folk music", "Music", "Rhythm and blues"] ["low quality", "latin urban", "passionate male vocal", "punchy kick", "punchy snare", "shimmering cymbals", "funky electric guitar melody", "synth pad chords", "groovy bass", "wide harmonizing vocals", "synth keys melody", "energetic", "addictive"] 4 8OsmFmhNjoA 920
Jorge Luis Cabrera - Se Acabaron Las Caricias The low quality recording features a regional Mexican song that consists of a passionate male vocal singing over groovy trombone and short brass melody. It sounds passionate and emotional, even though the recording is noisy. 2012-05-24T23:15:53Z Jorge Luis Cabrera Official Hola amigos, su amigo Jorge Luis Cabrera saludandolos desde Culiacan Sinaloa. Este canal lo diseñe para compartir mi vida personal y musical al igual que mi musica y mis canciones. Espero les guste. Gracias por su apoyo en toda mi carrera artistica. Saludos. Sigueme en Instagram: https://www.instagram.com/jorgeluiscabreraoficial/?hl=en #JorgeLuisCabrera #BandaSinaloense #Culiacan #Norteno #MusicaRomantica #LaChicadeMisSuenos #Compositor ["Folk music", "Music"] ["low quality", "regional mexican", "groovy trombone", "short brass melody", "passionate reverberant male vocal", "passionate", "emotional", "noisy"] 4 8Z5xnSxUmGE 929
Super Mario 64 Music - Bowser's Road EXTENDED The low quality recording features a hypnotic mellow synth lead melody, low percussive elements, sustained synth strings and some hollow snare hits. It sounds noisy, resonating, but also nostalgic and sentimental, as it gives off an old console game soundtracks. 2010-08-29T02:13:40Z SledgeBro64 10 minute long version of the theme that plays when you are in the "Bowser in the [Dark World/Fire Sea/Sky]" stages. ["Folk music", "Jazz", "Music"] ["low quality", "sustained synth strings", "hollow snare", "low percussive elements", "hypnotic mellow synth lead melody", "noisy", "resonating", "nostalgic", "sentimental"] 4 AJj6GGLaIfI 1104
macanita (1er parte) en jerez 2007 The low quality recording features a live performance of an aggressively strummed Spanish guitar and passionate female vocal singing on top of it. It is very noisy, but it sounds passionate and emotional. 2007-04-22T17:43:07Z Emilio Ancel macanita (1er parte) en jerez 2007 ["Singing", "Folk music", "Acoustic guitar", "Music", "Steel guitar, slide guitar"] ["low quality", "aggressive spanish guitar chord progression", "noisy", "live performance", "passionate female vocal", "passionate", "emotional"] 4 DVuWm53IlVw 1485
Briana Babineaux - Power In The House & Fill Me Up The low quality recording features a live performance that consists of shimmering hi hats, claps, groovy bass, groovy piano melody, brass melody and punchy snare. In the second half of the loop, there is a boomy microphone feedback, which makes a happy and fun atmosphere a bit suspenseful. 2015-07-28T01:06:29Z Joshua Moody Briana Babineaux singing "Power In The House" and "Fill Me Up" ["Folk music", "Music"] ["low quality", "live performance", "microphone boomy feedback", "clapping", "shimmering hi hats", "groovy bass", "brass melody", "groovy piano melody", "punchy snare", "happy", "fun", "suspenseful"] 4 DXeiJpZXVAI 1490
Ram Prasad Khanal's nepali folk song Tihar ko deusi bhailo-2 The low quality recording features a traditional song that consists of a flat male vocal, alongside monotone female vocal, singing over sustained strings melody, wooden percussion, shimmering shakers and some claps. It sounds passionate and the recording is in mono and noisy. 2007-09-26T01:04:39Z Ram Prasad Khanal Ram Prasad Khanal's nepali folk song Tihar ko deusi bhailo-2 ["Folk music", "Music"] ["low quality", "noisy", "mono", "clapping", "flat male vocal", "monotone female vocal", "wooden percussions", "shimmering shakers", "traditional", "sustained strings melody", "passionate"] 4 FKBryvLMTY4 1635
Hungarian music from the 17th century The low quality recording features a traditional song that consists of a distant woodwinds melody playing over wooden low percussion and strummed strings melody. It sounds soulful and passionate. 2009-04-12T19:15:56Z Arany Zoltán #hungary #music #aranyzoltan https://www.facebook.com/Arany-Zolt%C3%A1n-Music-274856225999515/ http://aranyzoltan.hu/ ["Folk music", "Music"] ["low quality", "traditional", "distant woodwinds melody", "wooden low percussions", "strummed strings melody", "soulful", "passionate"] 4 I2yA-F-_A2E 1867
Sri Sri Chandi Path (1 of 22) Part 1 ..(Chapter-1) The low quality recording features a traditional song that consists of a flat male vocal singing over pad chords. The recording is very noisy and it sounds passionate. 2010-08-22T09:44:39Z Kanchanmoni Sri Sri Chandi path Glory of the divine Mother. The Devi Mahatmya or the Durga Saptasati. Sri Sri Chandi path is a compilation of 700 slokas or verses in which the whole universal facts are embedded. Durga Saptashati or Chandi Path consists of 3 sections which are further divided into 13 chapters, due to large file size I have to split in to 22 parts. Path by Mr P. Roy ["Folk music", "Music"] ["low quality", "traditional", "pad chords", "flat male vocal", "noisy", "passionate"] 4 NZYDLDIyZr8 2346
Gajde cocek 2014 The low quality recording features a folk song that consists of a digital synth melody played, after which there is an exciting male vocal. It sounds energetic and exciting. The recording is noisy and in mono. 2014-01-17T07:10:40Z Nikola Mladenovic   ["Folk music", "Music"] ["low quality", "mono", "noisy", "exciting male vocal", "digital synth melody", "energetic", "exciting", "folk"] 4 T0tyLNN7SKA 2804
Kjarkas - Mi gran amor The low quality recording features a passionate, reverberant male vocal singing over a wide arpeggiated acoustic guitar melody and acoustic guitar solo melody, followed by a simple bass. It sounds emotional and passionate. 2012-11-07T23:29:37Z Erick Salazar Mi amor, mi gran amor, mi mas bella ilusión, mejor canción, los ojos de mi alma a quien cuide, la tierna ilusión que alimente... ["Folk music", "Music"] ["low quality", "passionate reverberant male vocal", "acoustic guitar solo melody", "wide arpeggiated acoustic guitar melody", "simple bass", "emotional", "passionate"] 4 TWV3YLscSaw 2839
Dance Music - Instrumental | Chandni | Sridevi | Shiv-Hari The low quality recording features a shimmering tambourine, wooden percussive elements, followed by arpeggiated harp which serves as a transition to the second part of the loop where plucked string melody appears. It sounds groovy and traditional. 2009-04-22T18:33:43Z YRF Sridevi's dance moves on the instrumental dance tack from the film 'Chandni' will leave you awe struck! Each move radiates grace & elegance. ► Subscribe Now: https://goo.gl/xs3mrY 🔔 Stay updated! ► YRF New Releases: https://www.youtube.com/playlist?list=PLCB05E03DA939D484 Stay in the filmy loop: ► Like us on Facebook: Facebook/yrf ► Follow us on Twitter: Twitter/yrf ► Follow us on Instagram: Instagram/yrf ► Visit us on: yashrajfilms.com 🎬 Movie Credits: Movie: Chandni Starring: Sridevi, Rishi Kapoor, Vinod Khanna, Waheeda Rehman Director: Yash Chopra Producer: Yash Chopra Music: Shiv-Hari Lyrics: Anand Bakshi Release Date: 14 September 1989 Watch all videos from the film ‘Chandni’: https://www.youtube.com/watch?v=KmPvEh4O4tE&list=PLcVfz1-_0rj_joQI3NySMiNZj4E38b5RJ&index=2&t=0s Synopsis: In one cruel stroke of fate, Chandni (Sridevi) faces life alone, her heart and her dreams shattered as Rohit (Rishi Kapoor) disappears from her life. When she meets Lalit (Vinod Khanna) who is fighting the demons of tragic memories, they both find solace in this new friendship. Lalits affection gives a new direction to Chandnis life, but Lalit is falling for her and Chandni resigns to destiny, till one day, Rohit knocks on her door. Chandni is a classic Yash Chopra love story, softly lyrical, throbbingly beautiful and filled with exquisite locales, lilting melodies and the sound of three hearts hopelessly in love. #YRFnewreleases #Chandni #YRF #YRF50 #Yashraj #YashrajFilms #YRFmovies #YRFmusic #YashChopra #AdityaChopra #RishiKapoor #Sridevi #VinodKhanna #WaheedaRehman #ShivHari #AnandBakshi © Yash Raj Films Pvt. Ltd. ["Folk music", "Music", "Dance music"] ["low quality", "arpeggiated harp", "shimmering tambourine", "wooden percussive elements", "plucked strings melody", "traditional", "groovy"] 4 awax48X8YlU 3587
Musik Tradisional Madura_Semut ireng The low quality recording features a live performance of a traditional song and it consists of a bell melody, followed by wooden percussion. There are some flat male vocals talking, after which there are harmonizing male vocals singing over it. It sounds passionate, even though the recording is noisy. 2013-12-11T10:31:53Z Achmad Syauqi Musik Tradisional Madura_Semut ireng ["Folk music", "Music", "Rattle (instrument)", "Speech"] ["low quality", "noisy", "live performance", "traditional", "bells melody", "wooden percussions", "flat mel vocal", "harmonizing male vocals", "passionate"] 4 bBy0NCoCEHc 3611
LAUGHTER DA MASTER SEASON 2 SEMIFINAL EPISODE 18 PART 1 OF 8 The low quality recording features a jingle that consists of harmonizing vocals talking over snare roll, toms roll, brass melody and groovy bass, after which there is a folk song that starts playing. The folk song contains strings melody, bouncy snare, shimmering hi hats and synth keys chords. It sounds energetic and exciting, and like something you would hear on some TV show. 2013-01-08T17:16:36Z LaughterDaMaster2 ["Folk music", "Music", "Snicker"] ["harmonizing vocals", "snare roll", "jingle", "tom roll", "brass melody", "groovy bass", "low quality", "mono", "folk", "bouncy snare", "strings melody", "synth keys chords", "energetic", "exciting"] 4 bzOeufhFITk 3670
Japp Japp Naam - Bhai Gurpreet Singh Shimla Wale - Amritt Saagar - Shabad Kirtan Gurbani The low quality recording features a traditional song that consists of mellow synth pad chords, wide plucked echoing strings, wobbly percussion, wooden percussion and shimmering tambourine. It sounds happy and joyful - like something you would hear at some traditional festivals. 2011-12-10T07:40:09Z Gurbani Shabad Kirtan - Amritt Saagar Album - Guru Guru Japp Ragi - Bhai Gurpreet Singh Shimla Wale Producer - Balbir Singh Bhatia Company - Amritt Saagar ["Folk music", "Music"] ["low quality", "traditional", "mellow synth pad chords", "wide plucked echoing strings", "wobbly percussion", "wooden percussions", "shimmering tambourine", "happy", "joyful"] 4 eSIxvnEQ6R0 3862
Vehra Shagna Da | Part 8 Of 8 | Punjabi Marriage Songs | Traditional Wedding Song The low quality recording features a traditional song sung by harmonizing female vocals over breathy flute melody and wooden percussion. It sounds harsh, muddy, passionate and soulful, as audio is distorted due to poor quality microphone. 2012-03-19T12:34:10Z Catrack Entertainment This Punjabi Song represents the Rich Punjabi Culture and Punjabi Music and is Part of Rituals in every Traditional Punjabi Wedding whether it takes place in a Village of Punjab (India) or Anywhere in the World. These Folk / Marriage Songs are integral part of Punjabi Culture and have various forms of Song & Dance like Tappe, Bolian, Gidha, Bhangra and Sithniyan. These are also called Shagna De Geet. All Punjabi Songs / Punjabi Music By Catrack is Available On I-Tunes, Spotify, Rhapsody, Nokia, emusic, Google Music, Amazon & Sound Cloud. Subscribe to Catrack's Youtube Channel http://www.youtube.com/subscription_center?add_user=catrackentertainment Join Us On Facebook http://www.facebook.com/CatrackOfficial Twitter https://twitter.com/catrack Google+ https://plus.google.com/112539272523400923462/ For Any Content, Advertising, or Marketing Related Queries for All our Platforms, including Heeroz OTT, Kindly Visit: http://www.catrack.com ..... @Catrack Entertainment #catrack #punjabitappebolian #punjabtappe #geetshagnade #punjabimarriagesongs #punjabimarriage #punjabibolian #bolian #punjabiweddingsongs ["Folk music", "Music"] ["traditional", "wooden percussions", "breathy flute melody", "low quality", "harmonizing female vocals", "harsh", "muddy", "distorted audio", "passionate", "soulful"] 4 eStzDzEopDI 3865
Top 30 Indie Folk and Acoustic (Playlist #5) The low quality recording features an indie folk song that consists of wide harmonizing male vocals and acoustic rhythm guitar. In the second half of the loop, the lead female vocal appears, creating a perfect harmony with the previously mentioned male vocals. It sounds passionate, emotional and sad. 2014-02-28T23:48:23Z Indie & Folky Me Indie Folk Playlist of march 2014 by the Indie and Folky Me Team Website: http://IndieFolkyMe.tk Follow us on twitter : @IndieFolkyMe Join us on facebook : https://www.facebook.com/IndieFolkyMe Photo by Antsa Rvl (Fickr) : http://www.flickr.com/people/10663187... Go here to watch the EXCLUSIVE Top 20 Indie Pop Charts : http://t.co/Isqtvo2FQ5 TRACKLIST Fall At Your Feet - Boy & Bear Just For Now - Cloud Control Where We Gonna Go From Here - Mat Kearney More Than Life - Whitley Message - Xavier Rudd Big Black Car - Gregory Alan Isakov Wolves - The Accidental Something Better - Ecclectic Approach Horses - The Be Good Tanyas Follow Fires - Matthew & The Atlas Move mountains - Roo Panes Without You - Keith Urban Night Bus - Lucy Rose David - Noah Gundersen The Romance Of Wolves - Roma Di Luna Send Me On My Way - Rusted Root Stereo Heart - Collin Mcloughlin Willow Tree March - THe Paper Kites Where Is My Mind - Tramped By Turtles Girl - Lovedrug Riverbanks - Charlie Simpson Sunday best - Augustana The Story I Heard - Blind Pilot Karen O - The Moon Song People - Sharon Nutzati Hidden Edelweiss - Spark Alaska Always Remember Me - Ry Cuming ft Sara Bareilles Worry - Rhodes Rosemary - Ghost & Gale Sons & Daughters - Allman Brown ft Liz Lawrence Bonus: I Lived - One Republic * Copyright Disclaimer * Under Section 107 of the Copyright Act 1976, allowance is made for "fair use" for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favor of fair use." ["Folk music", "Acoustic guitar", "Music", "Independent music", "Song", "Strum", "Plucked string instrument"] ["low quality", "wide harmonizing male vocals", "indie folk", "acoustic rhythm guitar", "lead female vocal", "passionate", "emotional", "sad"] 4 hTlIqICkbW8 4110
Ustad Nusrat Fath Ali Khan The low quality recording features a traditional song that consists of passionate male vocals singing over wooden percussion, claps, repetitive plucked strings melody and accordion melody. The percussion and plucked strings are in the left channel, while the other elements are in the right channel of the stereo image. It sounds passionate and soulful. 2010-08-29T13:38:36Z TheRizwan292 ["Folk music", "Music"] ["low quality", "traditional", "passionate male vocals", "wooden percussions", "claps", "repetitive plucked strings melody", "accordion melody", "passionate", "soulful"] 4 jWTm17KZGI8 4259
Tarang - A traditional music from Nepal The low quality recording features a traditional song that contains a wide string melody, wooden percussion and some noisy sound in the background. It gives relaxing vibes, even though the percussion and strings are a bit aggressive. 2014-01-11T17:07:23Z Satya Bonasera A traditional music cd that I've found between my memories. Here's the soundtrak list: Arachana (8.24) Majhi (7.29) Ashare (4.23) Malshree(7.21) Damai geet (7.18) Holi (6.10) Khyali (5.31) Bhairabi(12.22) Total running time - 58.58 min There is a little gap in the beginning, the numbers near the son's title is the duration. ["Folk music", "Music", "Sitar"] ["wooden percussions", "wide strings melody", "noisy sound", "low quality", "traditional", "relaxing"] 4 qKXhSGaudtk 4777
Farhad Shams Qarsak-e Panjsher and Sheen Khaale The low quality recording features a traditional pop song that consists of a flat male vocal, alongside exciting background vocals, singing over claps, wooden percussive elements, groovy bass and acoustic guitar melody. It sounds energetic, addictive, fun and joyful - like something you would hear at more traditional parties. 2013-03-18T17:13:05Z StylezhooDB3o9 Farhad Shams Qarsak-e Panjsher and Sheen Khaale Farhad Shams Qarsak-e Panjsher and Sheen Khaale ["Singing", "Folk music", "Music"] ["low quality", "pop", "traditional", "acoustic guitar melody", "wooden percussive elements", "clapping", "groovy bass", "flat male vocal", "exciting background male vocals", "wide", "energetic", "addictive", "fun", "joyful"] 4 qM8F6ECriRc 4779
Ruben Sasunci ft. Gohar Hovhannisyan - Ari Zoravar // Armenian Folk // HF New // HD The low quality recording features a pop song that consists of harmonizing vocals singing over pulsating synth lead melody, groovy bass, "4 on the floor" kick pattern, punchy snare, shimmering hi hats and some wooden percussive elements. It sounds energetic and addictive. 2015-09-07T18:32:51Z HayFanat http://hayfanat.com Here is "Ari Zoravar" by Ruben Sasunci and Gohar Hovhannisyan. Music & Lyrics by Gusan Haykazun Follow HayFanat also on Facebook http://www.facebook.com/hayfanat Google+ http://www.google.com/+HayFanat Instagram https://instagram.com/hayfanatofficial Twitter https://twitter.com/hayfanat HayFanat.com © 2015. All Rights Reserved. ["Folk music", "Music"] ["low quality", "pop", "harmonizing vocals", "pulsating synth lead melody", "groovy bass", "\"4 on the floor\" kick pattern", "punchy snare", "shimmering hi hats", "wooden percussive elements", "energetic", "addictive"] 4 qjJ41iwU9LY 4811
Ghadoli Bhar Aayee Aan | Geet Shagna De | Punjabi Marriage Ceremony Songs | Popular Wedding Music The low quality recording features a traditional song sung by harmonizing female vocals and followed by wooden percussion, short flute licks and mellow piano chords. It sounds addictive and passionate. 2012-03-18T14:50:28Z Catrack Entertainment This Song/Boliyan represents the Rich Punjabi Culture and Music and is Part of Rituals in every Traditional Punjabi Wedding Ceremony whether it takes place in a Village of Punjab (India) or Anywhere in the World. These Folk / Marriage Songs are integral part of Punjabi Culture and have various forms of Song & Dance like Tappe, Bolian, Gidha, Bhangra and Sithniyan. These are also called Shagna De Geet. . All Punjabi Songs / Punjabi Music By Catrack is Available On I-Tunes, Spotify, Rhapsody, Nokia, emusic, Google Music, Amazon & Sound Cloud. Subscribe to Catrack's Youtube Channel http://www.youtube.com/subscription_center?add_user=catrackentertainment Join Us On Facebook http://www.facebook.com/CatrackOfficial Twitter https://twitter.com/catrack Google+ https://plus.google.com/112539272523400923462/ For Any Content, Advertising, or Marketing Related Queries for All our Platforms, including Heeroz OTT, Kindly Visit: http://www.catrack.com ["Singing", "Folk music", "Music", "Wedding music", "Middle Eastern music", "Song"] ["low quality", "traditional", "harmonizing female vocals", "wooden percussions", "short flute licks", "addictive", "mellow piano chords", "passionate"] 4 ucSF9NIxK8A 5128
Electrum Drum Machine / Sampler for Android devices The low quality recording features a hip hop song played on a speaker that features groovy piano melody, synth lead melody, strings power chords, punchy snare, shimmering shakers, claps and punchy kick hits. It sounds noisy and thin as it lacks bass frequencies. 2011-01-30T23:05:05Z nikotwenty Video demo of Electrum Drum Machine running on a Samsung Galaxy Tablet. Demonstrating some of the features, especially playing with loading loops unto the drum pads, and switching live between patterns, as well as a small demo of playing the multitouch pad dialog pads. ["Folk music", "Music"] ["low quality", "hip hop", "noisy", "thin", "muffled", "groovy piano melody", "synth lead melody", "strings power chords", "punchy snare", "shimmering shakers", "clapping", "punchy kick"] 4 wg_kYW4xvz4 5282

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;