musiccaps_details (view)
19 rows where search matches "guitar", musiccaps_author = 6 and musiccaps_names contains "Singing" sorted by youtube_description
This data as json, CSV (advanced)
Suggested facets: musiccaps_names, youtube_published (date)
musiccaps_aspects (array) 90 ✖
- acoustic drums 13
- e-bass 11
- e-guitar 10
- acoustic guitar 8
- amateur recording 7
- medium to uptempo 6
- male voice singing 4
- uptempo 4
- female voice singing 3
- male voices singing 3
- acoustic piano 2
- electric piano 2
- higher register 2
- keyboard 2
- medium tempo 2
- pop 2
- uplifting mood 2
- aggressive energy 1
- alternative rock 1
- alternative/indi 1
- background cheering 1
- background noises 1
- backing song 1
- brass section 1
- castanets 1
- congas 1
- crowd cheering and clapping 1
- digital drums 1
- e-guitars 1
- electric organ 1
- electronic sounds 1
- fast tempo 1
- female backing voice 1
- female voice singing/yodeling 1
- flamenco/ballad 1
- flute 1
- higher pitch 1
- indie7rock/pop 1
- jazz/ballad 1
- loud cheering and clapping 1
- male and female singers 1
- male backing vocals 1
- male backing voices 1
- male deep voice singing 1
- male higher voice singing 1
- male singer 1
- male soul voice singing 1
- male voice rapping 1
- male voice streaming 1
- melancholic 1
- mid range 1
- mid-range 1
- mid-range voice 1
- mideum to uptempo 1
- old recording 1
- percussion 1
- piano 1
- positive vibe 1
- progrock 1
- punkrock/electronic 1
- r&b 1
- reggae/pop 1
- rock 1
- rock&roll 1
- romantic 1
- sad atmosphere 1
- saxophone 1
- semi-acoustic guitar 1
- sensitive 1
- sensual 1
- shaker 1
- singer-songwriter/rap 1
- ska cubano 1
- skarock 1
- slide guitar 1
- slow tempo 1
- slow to medium tempo 1
- soul/blues/jazz 1
- soulful 1
- strings 1
- sub bass 1
- synth 1
- synth pad 1
- tambourine 1
- trombone 1
- trumpet 1
- upbeat 1
- upright bass 1
- western/county 1
- yodeling 1
musiccaps_names (array) 29 ✖
- Music 19
- Singing · 19 ✖
- Ska 6
- Song 3
- Country 2
- Independent music 2
- Inside, large room or hall 2
- Pop music 2
- Whoop 2
- Angry music 1
- Applause 1
- Exciting music 1
- Flamenco 1
- Folk music 1
- Guitar 1
- Inside, public space 1
- Maraca 1
- Music of Latin America 1
- Musical instrument 1
- Plucked string instrument 1
- Psychedelic rock 1
- Sad music 1
- Sampler 1
- Swing music 1
- Tambourine 1
- Vocal music 1
- Wedding music 1
- Yell 1
- Yodeling 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Try a little tendernes_The Commitmens | A male voice is singing loud and soulfully. A saxophone is playing a slight variation of the singer's melody. A piano is playing bluesy/jazzy chord chops accompanied by an electric organ playing along with the melody. Panned to the left side of the speaker, a e-guitar is playing one single chord as a rhythmic element. The e-bass is playing a line along with a simple rimshot and shakers that are barely noticeable. This song may be playing at a live concert. | 2010-09-27T10:52:20Z | dimosk100 | ["Singing", "Music", "Ska"] | ["soul/blues/jazz", "male soul voice singing", "e-guitar", "saxophone", "piano", "electric organ", "e-bass", "acoustic drums", "soulful", "medium to uptempo"] | 6 | dTVkk4GSmNA | 3790 | ||
Peter Doherty - Nothing Comes To Nothing (DEMO Track) | This song contains acoustic drums playing kind of a slow drum&bass rhythm along with a bass playing the rootnote of a e-guitar strumming along. Another e-guitar is strumming along, panned to the right side of the speakers. A male voice is singing in a higher key with delay in his voice. This song may be playing with headphones on a rainy colder day. | 2012-12-10T19:03:53Z | enenes | "Nothing Comes To Nothing" Won't you come, come back to earth Cause they're all concerned You know how they're worried for you. And all their words, they jar my nerves I know Each curse by each new kiss is run through Nothing comes to nothing without my baby, Nothing ever comes to nothing without my baby At an Amwellian Do a tongue soaked in booze says "He's filthy and much older than you" Oh the sick sick muse, the sickly muse Pulls out her sickle so shiny, cuts the tongue in two While the music sways and forays and searches and says: "Give me the young man in blue" While the music sways and forays and searches and says: "Break your heart in two" Nothing comes to nothing without my baby, Nothing ever comes to nothing with my baby, All I ever do Where's the happy prince? Where? There's his smiling bride. He's right beside you Flo... Nothing ever comes to nothing without my baby, Nothing's ever good for nothing with that lady Nothing ever comes to nothing without my baby, Nothing ever comes to nothing without my baby | ["Singing", "Music", "Ska"] | ["rock", "e-bass", "e-guitars", "acoustic drums", "male voice singing", "higher register", "melancholic", "medium to uptempo"] | 6 | FY8bZRm_QiE | 1647 | |
PROUD MARY Show Sampler - 24K Gold Music | A male voice is singing with reverb and delay in his voice. An acoustic drum is playing a faster groove on the piano, a tambourine can be heard. An electric bass is playing repeating notes without a lot of changes. A brass section is repeating a theme while keyboards and a guitar are playing along. This song may be playing live in-between an entertainment-show. | 2011-08-26T02:57:44Z | 24kGoldSAMPLESMusic | 24K Gold Music's rendition of the big hit "Proud Mary", in the stylings of Elvis Presley's version. 24K Gold Music Show performs all over Florida in various auditoriums (such as the Lakeland Center's Youkey Auditorium, and other Performing Arts Centers across the state), focusing mostly on the central Florida area. They are sometimes available out-of-state for special events if the facilities is large enough to handle such a huge production. Anyone needing to get in touch with 24K Gold Music Shows can go to the web site at www.C24K.com or send an email to our name (24KgoldMUSICshow) at gmail.com. 24K Gold Music Shows is a 136 person show-team. We are a Florida Not-For-Profit corporation. Our shows feature many different styles of performances of top song hits from a period of about 50 years, with special emphasis upon oldies from the 50s, 60s, and 70s. We perform different songs in every show, from a 500 song repertoire list. Our web site is www.C24K.com. Some people ask why we publish mostly parts of songs (clips), and do not publish very many full length songs. We are trying hard not to end up causing anyone any problems. We DO feel the fair use clause in the copyright laws pertains to what we are doing, since none of us have ever made a penny from performing or working in the shows. We are all volunteers, and LOVE working together as a family! WE LOVE THE MUSIC! All of the income from the shows goes to HELP pay for advertising and production costs, such as the rental of auditoriums, licensing fees to the performing rights organizations, toll free phone lines, credit card acceptance fees, sales tax, insurance, equipment rentals and repairs, etc. However, in spite of the fair use clause, we still try our best to not create problems. If we don't publish ANY of our videos, then how else can people determine whether they want to attend, and if they don't attend, then the performing rights organizations will not get money to pass on to the performers and songwriters). We hope by doing things this way, we ca… | ["Singing", "Country", "Sampler", "Folk music", "Music", "Pop music", "Song"] | ["rock&roll", "acoustic drums", "e-bass", "brass section", "e-guitar", "keyboard", "male singer", "mid-range", "uptempo", "uplifting mood", "amateur recording"] | 6 | ktw_J6ZW0MM | 4364 | |
Portugal The Man "People Say" live at Twist & Shout, Denver, CO | Someone is strumming chords on an acoustic guitar singing along with a male voice in the higher register. male backing vocalists are supporting the singer. A piano is playing supportive chords along with congas and a tambourine. This is an amateur recording but of decent quality. This song may be playing live. | 2009-08-18T20:18:15Z | Suburbanhome | 8.14.09 live at Twist and Shout records in Denver, CO | ["Singing", "Country", "Music", "Tambourine"] | ["alternative/indi", "keyboard", "tambourine", "congas", "acoustic guitar", "male higher voice singing", "male backing vocals", "medium tempo", "amateur recording"] | 6 | gXOyw8a4_Xs | 4037 | |
Teri Aahatein-Full Original Video Song-Ek Mein Aur Ekk Tu ft Imran Khan Kareena Kapoor | An acoustic piano is playing a melody along with a flute-sound and an acoustic guitar picking two notes repeatedly. Then the song breaks softly into a new part as the acoustic guitar and piano are fading out. In the background you can hear some insects chirping. Now an electric piano sound is playing a melody along with a male voice singing. His voice sounds sensitive. This song may be playing for a movie scene. | 2012-01-14T08:17:35Z | rfication rakesh | Ek Mein Aur Ekk Tu songs 2012 Teri Aahatein kareena Kapoor Imran Khan new bollywood songs 2012 2011 movies trailers karan johar | ["Singing", "Music", "Sad music"] | ["pop", "acoustic piano", "flute", "acoustic guitar", "electric piano", "male voice singing", "mid-range voice", "sensitive", "medium to uptempo", "background noises"] | 6 | lmrzR9cSMRY | 4419 | |
Dmitry Zharkov - Olga Kulikova | Final Slow Fox | Finland Open 2016 Grand Slam | An acoustic drum is playing a jazzy groove on the ride along with a bassline while an e-guitar is playing jazz chords with a lot of changes together with an acoustic piano rendering phrases with an uplifting melody. The singer's voice sounds low and romantic. This song may be playing while dancing with a partner. | 2016-03-26T13:14:27Z | in.media | Finland Open 2016 Grand Slam Standard Final Round Slow Foxtrot Dmitry Zharkov - Olga Kulikova | ["Singing", "Applause", "Music"] | ["jazz/ballad", "acoustic piano", "acoustic drums", "e-bass", "e-guitar", "male deep voice singing", "crowd cheering and clapping", "medium to uptempo", "romantic"] | 6 | HLz3N5nG8fQ | 1793 | |
Top 30 Indie Songs I Think You Should Listen To | This song contains someone playing acoustic drums along with an e-bass. They both sound in the foreground. A male voice is singing in the high mids and with reverb and a little delay on his voice. Then the song breaks into the next part and an e-guitar comes in with a strummed melody. This song may be playing with headphones lost in thoughts. | 2009-09-27T17:23:53Z | top30music | Follow me on twitter!: @Top30music 30 great indie songs from bands from 12 different countries!!... if you know a good indie song dont keep it to yourself... comment about it! If you're looking for new music, don't hesitate on clicking here: http://www.youtube.com/watch?v=1xXuKvtOlaw amazing artist! | ["Singing", "Music", "Independent music"] | ["indie7rock/pop", "male voice singing", "higher pitch", "acoustic drums", "e-bass", "e-guitar", "uptempo"] | 6 | atWaDoSyGgY | 3584 | |
Alternative Wedding Songs | Unique Wedding Songs | "THE ENGAGEMENTS" | Covers Band | Wedding Band | This song contains a female singer singing with a lower voice. An acoustic drum is playing a simple groove with a catchy bassline. An e-guitar is playing the notes along with the bass. A keyboard is emulating an e-guitar sound by playing a little lick. This song may be playing at a live concert. | 2009-04-12T21:28:45Z | JazzCapitalEvents | Hear the difference: THE ENGAGEMENTS are simply the best sounding wedding band. Contact us now: http://www.jazzcapital.net/contact.php Call us: (718) 941-2295 Click Here to watch the full high quality clip of this video: http://www.youtube.com/watch?v=gqVmNdtapbc See our other videos! The Engagements also play jazz, soul, funk, and 60s 70s and 80s dance covers! Booking The Engagements for your wedding or party is easy. Email us: info@JazzCapitalEvents.com Click here: http://www.JazzCapital.net/contact.php ---------------------------------------- -------------- Categories: Alternative Wedding Songs | Unique Wedding Songs | Alternative Wedding | Wedding Ideas | 80s Covers | 80s Music | Unique Wedding Ideas | Wedding Band | Wedding Bands | Music For Weddings | New York Wedding Band | New York Wedding Entertainment | New York Wedding Band | Cover Band | Cover Bands | Live Music Band | Book Bands | Book Entertainment | Wedding Singers | Wedding Alternatives | Wedding Music Alternatives | Great Wedding Songs | Wedding Band NYC | Wedding Bands New York | Weddings Bands | New York City |Wedding Reception Songs | Dance Wedding Songs | Songs For Wedding | Jazz Live Music | List Bands | Alternative Wedding Band | Wedding Band Swing | Soul Band | Soul Bands | Book Entertainment ---------------------------------------- -------------- This short video sample features The Engagements performing Sweet Dreams (Are Made Of This) by The Eurythmics. The Engagements is a New York wedding reception party band like no other. Simply put, The Engagements is a special event powerhouse. From classic funk and soul covers to 80s favorites, this live band will keep everyone dancing. The Engagements players have logged hours on the road with the likes of Q-Tip, Mos Def, Sharon Jones and The Dap-Kings, Steely Dan, Rod Stewart, Bernie Worrell, Dr. Lonnie Smith, the Duke Ellington Orchestra, Whitney Houston, and The Isley Brothers. Available for weddings, corporate events, and parties of both the private … | ["Singing", "Music", "Wedding music", "Psychedelic rock", "Pop music", "Ska"] | ["pop", "amateur recording", "e-bass", "e-guitar", "acoustic drums", "synth", "female voice singing", "mid range", "mideum to uptempo"] | 6 | t9aSL2MwEDM | 5012 | |
Diam's - DJ (Clip officiel) | This song contains digital drums with a soft sub bass playing along every kick hit. An acoustic guitar/sitar is playing a melody with a synth sound playing a high counter melody panned to the left side of the speakers. A synth pad is playing a long note melody in a higher register. A female voice is singing the main melody. Her voice is doubled and backing voices are adding harmonies. This song may be playing in a hip-hop club. | 2009-02-26T21:52:50Z | Diam's officiel | Music video by Diam's performing Dj. | ["Singing", "Music", "Exciting music"] | ["r&b", "acoustic guitar", "synth pad", "digital drums", "sub bass", "female voice singing", "uptempo"] | 6 | oRVivXC83hA | 4629 | |
Electric Callboy - We Are The Mess (OFFICIAL VIDEO) | This song is a mixture of punk rock with acoustic drums with crash hits, e-guitar playing low notes along with the bassline, a male voice aggressively, loud screaming and digital higher pitched sample sounds being panned to the left and right side of the speakers. This song may be playing at a live concert in an underground club. | 2013-11-29T08:17:57Z | Electric Callboy | New Single "We Are The Mess" - Out Now! iTunes: http://bit.ly/1cFo7bM Amazon Digital: http://amzn.to/1egxoch "We Are The Mess" taken from the upcoming album "We are The Mess"! Street Date: 10th January 2014. GET MERCHANDISE: http://www.electriccallboy.com (worldwide shipping) Thanks for your support!!! Video Production: Directed by Eskimo Callboy & Oliver Schillo Edit and VFX by Oliver Schillo & Pascal Schillo Sound Design by Pascal Schillo Music & Lyrics by Electric Callboy Produced by Daniel Haniß and Pascal Schillo Recorded by Electric Callboy Mixed by Daniel Haniß and Pascal Schillo Mastered by Kristian "Kohle" Kohlmannslehner at Kohlekeller Studio Published by BMG Rights Management. Redfield Records 2014. Lyrcis: We don't wanna be sober anymore let's get fucked up with those bitches and whores We don't wanna be sober anymore, let's get fucked up with those bitches and whores Baby let me be your bartender let's get fucked up that we can't remember last night I'm alright when you're here with me I'm alright when you're here with me We are looking for some trouble tonight We wanna party like a g6 looking for those hot chicks I said get out the way I wanna rock the dance floor I got the moves you got the keys for the backdoor Life is a party Why are you so serious ? We make you look ridiculous Ladies get naughty! Gentlemen are in da club Sing along let's get fucked up! Baby let me be your bartender let's get fucked up that we can't remember last night I'm alright when you're here with me I'm alright when you're here with me Baby let me be your bartender let's get fucked up that we can't remember last night I'm alright when you're here with me I'm alright when you're here with me We break the girl's hearts still before we have a drink We're smoking the last cigarette before your girlfriends show us pink and you can't fuck with us and you can't fuck with me We are the new kids from the block and you're just cheesy Life is a party why are you so serious ? We make you look ri… | ["Singing", "Music", "Angry music"] | ["punkrock/electronic", "electronic sounds", "e-guitar", "e-bass", "acoustic drums", "male voice streaming", "aggressive energy", "medium to uptempo"] | 6 | hj7VJnNq6A4 | 4131 | |
Tokyo Ska Paradise Orchestra Live - Ska Me Crazy | An e-bass is playing a bluesy bassline along with acoustic drums with a slightly open hihat. An electric piano/organ is playing one short chord as a rhythmic element adding reggae vibes along with a e-guitar strumming fast chords on the offbeat. The guitar is running through a chorus effect. The male voices are singing a simple melody. This song may be playing at a live concert before a sports-event. | 2007-01-16T11:24:03Z | SkaRebel | SKA SKA SKA!!! | ["Singing", "Music", "Ska"] | ["skarock", "acoustic drums", "e-bass", "electric piano", "e-guitar", "male voices singing", "amateur recording", "fast tempo", "uplifting mood"] | 6 | rJZgUpzqAyY | 4864 | |
Ska Cubano " Chango " at Jazz Cafe London | An acoustic drum is holding the groove together with an upright bass and an acoustic guitar playing rhythmic chords on the backbeat. A trumpet and trombone are playing a melody before the male voice starts to sing being backed up by other male voices singing along. This song may be playing during a live event. | 2012-02-08T15:17:51Z | carlinmalacopa | Ska Cubano at Jazz cafe London, December 2011 | ["Singing", "Music", "Ska"] | ["ska cubano", "upright bass", "acoustic guitar", "acoustic drums", "male voices singing", "trumpet", "trombone", "upbeat", "amateur recording"] | 6 | 5NCUtndrsHg | 658 | |
The Who - I'm Free | A male voice is singing in a higher register along with male background voices. An acoustic drum is playing a complex groove with a lot of fill-ins. A e-bass is holding the groove along with a e-guitar strumming single chords. This song may be playing live at a festival in the 70s. | 2010-03-20T18:43:09Z | TheWhoVEVO | The Who - Live At The Fillmore East 1968 out now! Check it out: https://lnk.to/TheWhoFillmoreEast Explore more music from The Who: https://lnk.to/TheWhoBestOf Follow us: https://www.instagram.com/officialthewho/ https://www.facebook.com/thewho/ https://twitter.com/TheWho #TheWho | ["Singing", "Music", "Ska"] | ["alternative rock", "e-guitar", "e-bass", "acoustic drums", "male backing voices", "male voice singing", "higher register", "old recording"] | 6 | Ux1vBolJf5Q | 2958 | |
Black Veil Brides- Andy calls out/fights a guy in the crowd 2013 | The file contains acoustic drums playing with a lot of crash hits, an e-guitar playing a melody along with male voice singing the same melody. The crowd is cheering and screaming in the background. This is an amateur recording with poor sound-quality. This song may be playing at a live concert. | 2013-01-21T02:46:41Z | Amanda Norris | This guy in the crowd starting fighting a kid who was just trying to mosh, and another person told him to be careful, but the guy just pushed him. Andy saw what was going on and, being known for standing up for himself and his fans, called him out and fought with him while the song(Nobody's Hero) was playing. Andy told the guy to come to the front, and when he goes off stage, he fights with him. I believe they punched each other and Andy hit him with his mic. Odessa, TX at Dos Amigos on January 9, 2013, Church of the wild ones tour. The guy was about Andy's height, if not taller, and a senior in high school, age 18 assumedly. So no, he was not fighting a "little kid." | ["Singing", "Music", "Whoop", "Inside, large room or hall", "Inside, public space"] | ["progrock", "e-guitar", "male voices singing", "acoustic drums", "background cheering", "slow to medium tempo"] | 6 | YSrTtw6ku2E | 3286 | |
Room39 - Mixed Song @ FAT Fest 10 | An acoustic guitar is strumming chords along with a male voice rapping that gets backing vocals from a female voice for a moment. A lot of people are clapping and cheering. This song may be playing at a live concert. | 2010-11-07T17:27:20Z | KaitoGallery | from iPhone upload by http://www.entertainstation.com | ["Singing", "Music", "Whoop", "Yell", "Inside, large room or hall"] | ["singer-songwriter/rap", "acoustic guitar", "male voice rapping", "loud cheering and clapping", "female backing voice", "uptempo", "positive vibe"] | 6 | sOSU7p9pLjs | 4946 | |
Toasted Western Swing Band: Leaving and Saying Goodbye | An acoustic drum is playing a groove with brushes while an e-bass is playing a walking bassline. Someone is strumming chords on an acoustic guitar while an e-guitar is playing rhythmic chords on the offbeat along with a slide guitar playing a melody. A mid-ranged male voice is singing a melody supported by male and female backing singers. This song may be playing in a coffee shop in the morning. | 2012-01-27T00:53:15Z | ArtistsTribute | http://festivalentertainment.ca/toasted-western-swing-band/ You will feel the nostalgic magic in the air when Canada's Favourite Cowboys and Cowgirls take the stage with their thrilling tribute to the Legends of Texas Swing Music! This crowd pleasing band has plenty of pedigree as they have performed live on stage at some of Canada's largest Music Event Festivals. They have opened shows for many legendary performers to include Martina McBride, Shenandoah, Sawyer Brown, Joe Nichols, Doug Kershaw, Tommy Hunter, Jeannie Sealy, and more! The Toasted Western Swing Band delivers to their audience a foot stompin/ toe tapping celebration of the great songs of such Texas Swing Legends such as Bob Wills and the Texas Playboys, Ray Charles, Jeannie Sealy, Asleep at the Wheel, Willie Nelson, Johnny Cash, Buck Owens, Dwight Yoakum and Much More! Find out why the Toasted Western Swing Band was held over for 47 straight weeks at the Best Western Hotel in Niagara Falls! It don't mean a thing unless its got that Texas Swing! Yeeeeee Hawwwwwww!!! | ["Singing", "Swing music", "Music", "Independent music", "Song"] | ["western/county", "acoustic guitar", "slide guitar", "e-guitar", "acoustic drums", "e-bass", "male and female singers", "medium to uptempo"] | 6 | MwK9HYjeeN0 | 2310 | |
oude vrouw jodelt als jonge dame | A semi-acoustic guitar is playing slow chords and the bassline at the same time while a female voice is singing/yodeling. A reverb effect is on her voice. In the background you can hear voices talking and clapping. This is an amateur recording but of decent sound quality. This song may be playing at a folkfest. | 2008-03-04T12:14:05Z | Veerle Ruijsch van Dugteren | opgenomen tijdens vakantie met hub'n bub'n in oostenrijk 2007 | ["Singing", "Yodeling", "Music", "Song", "Vocal music"] | ["yodeling", "semi-acoustic guitar", "female voice singing/yodeling", "slow tempo", "amateur recording"] | 6 | WtN6uiDikRM | 3145 | |
timile ta haina | Someone is playing an acoustic guitar strumming chords on the backbeat while someone is holding the rhythm with a shaker and a percussion in the background. This song may be playing while having a jam session with your friends. | 2014-09-10T14:13:19Z | Jolon Deepanjali Joshi | rehearsal | ["Singing", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Maraca"] | ["reggae/pop", "amateur recording", "acoustic guitar", "shaker", "percussion", "medium tempo"] | 6 | Gow0TlxIx7U | 1755 | |
山口かおる♪『哀愁フラメンコ』 | This song contains a female voice singing in the mid to higher register sounding sensual and sad. She is singing along to a backing track containing acoustic drums playing along with an e-bass. Castanets typical for latin music, an acoustic guitar, plucked and long notes being played by strings giving the song a feeling of flamenco music. In the background you can hear the crowd giving applause. This song may be playing as a live concert. | 2008-11-15T08:18:47Z | kakiuchi takeo | テレビ画面より | ["Singing", "Flamenco", "Music", "Music of Latin America"] | ["flamenco/ballad", "female voice singing", "backing song", "e-bass", "castanets", "acoustic drums", "strings", "acoustic guitar", "sensual", "sad atmosphere"] | 6 | nvrMO6TDu2g | 4593 |
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;