musiccaps_details (view)
18 rows where musiccaps_aspects contains "groovy bass line", musiccaps_aspects contains "medium tempo" and musiccaps_aspects contains "passionate"
This data as json, CSV (advanced)
musiccaps_names (array) >30 ✖
- Music 15
- Keyboard (musical) 2
- Musical instrument 2
- Salsa music 2
- /t/dd00003 1
- Angry music 1
- Banjo 1
- Blues 1
- Bowed string instrument 1
- Camera 1
- Christian music 1
- Electric piano 1
- Electronic organ 1
- Hip hop music 1
- Independent music 1
- Middle Eastern music 1
- Organ 1
- Percussion 1
- Piano 1
- Plucked string instrument 1
- Pop music 1
- Radio 1
- Rapping 1
- Rhythm and blues 1
- Singing 1
- Ska 1
- Song 1
- Swing music 1
- Tapping (guitar technique) 1
- Tender music 1
- …
musiccaps_aspects (array) >30 ✖
- groovy bass line · 18 ✖
- medium tempo · 18 ✖
- passionate · 18 ✖
- emotional 11
- spirited 8
- steady drumming rhythm 7
- instrumental music 6
- romantic 6
- guitar accompaniment 5
- male singer 5
- energetic 4
- exciting 4
- inspiring 4
- keyboard harmony 4
- people dancing 4
- youthful 4
- bad audio quality 3
- female singer 3
- groovy music 3
- groovy rhythm 3
- guitar lead 3
- latin percussions 3
- poor audio quality 3
- ad jingle 2
- dance groove 2
- dance rhythm 2
- female singers 2
- groovy 2
- keybiard accompaniment 2
- keyboard accompaniment 2
- …
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Tubular Bells | The song is an instrumental. The song is medium tempo with three guitars playing in harmony, guitar accompaniment, guitar harmony, guitar lead and a strong bass line. The song is emotional and spirited. The song has an average audio quality and is played in front of a live audience. | 2009-07-01T03:28:17Z | Christine Robertson | California Guitar Trio's version of Tubular Bells live at B.B. King's June 22, 2009 with Tyler Trotter on Melodica | ["Banjo", "Tapping (guitar technique)", "Music"] | ["poor audio quality", "home video recording", "guitar band", "instrumental music", "medium tempo", "guitars playing in harmony", "groovy bass line", "guitar lead", "guitar accompaniment", "entertaining", "emotional", "passionate", "spirited", "lilting"] | 1 | 1RwhRTe-OKk | 275 | |
2014: Willow (Jeff Hardy) 14th & New TNA Theme Song - "Willow's Way" + DL w/Lyrics | A male singer screams and laughs loudly. The song is medium tempo with steady rock drumming, groovy bass line and electric guitar rhythm. The song is energetic and haunting. The song is a modern punk rock song. | 2014-04-25T19:35:34Z | TheGreatWhiteHD | Title: "Willow's Way" Artist: PeroxWhy?Gen Album: Evolution XIV Genre: Rock Released: April, 2014. Download Link: .mp3: http://www.sendspace.com/file/4k1s14 ShopTNA: http://bit.ly/1lbRokM Theme Count: 1st: "Modest" (as Jeff Hardy) 2nd: "Alien Waltz" (Instrumental with "Modest" Intro) (as Jeff Hardy) 3rd: "Alien Waltz" (Instrumental) (as Jeff Hardy) 4th: "Modest" (Intro Cut) (as Jeff Hardy) 5th: "Alien Waltz" (with "Modest" Intro) (as Jeff Hardy) 6th: "Alien Waltz" (as Jeff Hardy) 7th: "Modest" (V2) (as Jeff Hardy) 8th: "Modest" (V3) (as Jeff Hardy) 9th: "Another Me" (as Jeff Hardy) 10th: "Resurrected" (as Jeff Hardy) 11th: "Similar Creatures" (BFG Mix of Themes Intro) (as Jeff Hardy) 12th: "Time & Fate" (BFG Mix of Themes Intro) (as Jeff Hardy) 13th: "Time & Fate" (Intro Cut) (BFG Mix of Themes Intro) (as Jeff Hardy) 14th: "Willow's Way" (as Willow) Lyrics: Pointless to memorize Inklings that writting They calculate who we are Shedding the skin of Bizzare They make their voice and they know Systematically they're low I am leaving away I saw it out in two face Pointless to analyze What we cannot energize Hatred is steering me wrong Because the hope is all gone And the angels fly on by Head down the hope is all gone While the demons hide inside It's down the hope is all gone The devil sets fire to evil souls Worship and pray While God's ambitious plan unfolds In Willow's Way Pointless to even pretend It doesn't matter within' They justify who we are Shedding the weight of bizzare They make their dates and they know Charismatically they're low I wide open seen the soul It's just the way I was born Pointless to even defend What we cannot comprehend Hatred is guiding me wrong Because the faith is all gone And the angels fly on by Head down the faith is all gone While the demons hide inside It's down the faith is all gone The devil sets fire to evil souls Worship and pray While God's ambitious plan unfolds In Willow's Way Worship and pray In Wilow's Way Worship and pray Nothin left to say In Willow's Way And… | ["Music", "Angry music"] | ["screaming vocals", "rock band", "punk rock", "youthful", "emo teens", "eerie", "live audience", "pulsating rhythm", "rebellious nature", "ambient keyboard tones", "keyboard harmony", "laughing devilishly", "emo", "kiss", "haunting vocals", "heavy metal", "medium tempo", "haunting", "passionate", "exciting", "groovy bass line"] | 1 | 2ATMQxWVpXk | 338 | |
Radio Receiver Software | The song has different music tracks played in succession. The song has guitar accompaniment and a groovy bass followed by female singer singing vocal chants with male backup singer in vocal harmony, on a groovy drum rhythm and keyboard harmony with white noise added. The song is probably an ad jingle. | 2012-09-27T10:44:13Z | SoftwareRadioOnline | http://linkclick.me/OnlineRadio ◄ Retail version (no ads) http://linkclick.me/FreeRadio ◄ Radio Receiver Software Enjoy 5,325 world Radio stations with No monthly fees! Listen to thousands of HQ radio stations from your computer! 2 minutes and your computer will become an amazing Music player! Turn your computer into a multi-channel WEB Radio! With our service you can listen to thousands of Radio stations from all over the world, Installation is simple and easy - in just a few seconds you will be able to listen to thousands of stations. Online Radio is the perfect solution, a simple and convenient alternative to Satellite Radio. Absolutely ZERO monthly costs -- Online Radio is free of any monthly charge or recurring monthly subscription. A lifetime license for free updates is included in this package. Thousands of stations - Select your favorites out of thousands international internet based stations from all over the world. No additional hardware required - This is software only, one that can be installed on any Internet enabled PC desktop or Laptop. There is no need to add additional hardware such as a Radio tuner or DVR card. Easy to use -- Everyone can use this. A simple interface makes it as easy as listening to your regular radio set! Works everywhere in the world --Listen to internet Radio with your PC in any country with Internet access. 100% Legal -- This software is not illegal in any way, as it streams all the free FREE web stations available on the Internet. Runs on Windows Platform -- Works smoothly on every PC running any version of the Microsoft Windows operating system including Windows 98, XP, Vista and Windows 7. A one time payment of less Than $15 and you can stream over thousands of web Radio stations free! A free Premier auto update license is included in this package. | ["Music", "Radio"] | ["guitar lead", "groovy bass line", "white noise", "medium tempo", "exciting", "passionate", "dance groove", "ad jingle", "radio tuning signals", "tv spot", "female singers", "male backup singers", "different keys", "steady drumming rhythm", "churchy audio signal", "vocal chanting", "groovy rhythm", "pop music", "advertisement music track", "different music tracks"] | 1 | 2FQKfGCwjSE | 342 | |
【華燈市】市政店精品吊扇展示中心 | The song is an instrumental. The song is medium tempo with a guitar playing solo, steady drum rhythm, groovy bass line and steady bass line. The song is funky and groovy in nature. The song is an ad jingle. | 2015-05-18T10:07:19Z | 華燈市燈飾 吊扇 光源 設計 | 官網-https://www.waldens-lighting.com/ 免費到府勘查- https://www.waldens-lighting.com/cont... 華燈市提供您全省安裝服務,自有工班提供您專業的燈具安裝、吊扇安裝、照明燈具、安裝維修、五星級安裝,產品有保固,購買燈具有保障,一年保固終身保修 ------------------------------------------------------------------------------------------------------------------------------------------------------------------ 華燈市為全國最大的精品吊扇展示中心,吊扇種類最多,針對不同的需求,提供您最佳的吊扇 選擇,從 #Fanaway、 #Fanscool、 #ModernFan、到 #Vento…,無論是國際精品品牌,或者是台灣之光,您都可以透過店內實品展示的體驗,實際感受及體驗這些精品吊扇的魅力 #燈的事就交給華燈市 #全省安裝 #精品吊扇 | ["Music", "Camera"] | ["instrumental music", "cash register click", "passionate", "spirited", "exciting", "medium tempo", "groovy rhythm", "romantic", "energetic", "youthful", "jazz music influences", "dreamy", "enterprising", "guitar solo", "groovy bass line", "steady drumming rhythm", "ad jingle", "soundtrack", "funk jazz music", "shakers percussions", "groovy", "soul music", "medium tempo"] | 1 | D2w3qHmJrdU | 1429 | |
SALSA CLASICA ROMANTICA MIX RONNY MUSIC | A male singer sings this Latin melody. The song is medium tempo with a groovy Latin percussive rhythm, keyboard accompaniment, brass band harmony and a groovy bass line. The song is romantic and emotional. The song is a salsa dance hit, but has poor audio quality issues.. | 2011-09-30T01:08:54Z | ronnymusic01 | BY DJ RONNY MUSIC | ["Music", "Middle Eastern music", "Salsa music"] | ["salsa", "latin folk music", "male singer", "spirited singing", "emotional", "couples dancing", "passionate song", "mysterious", "latin percussions", "trumpets playing", "medium tempo", "various percussion hits", "keyboard harmony", "romantic", "love songs", "latin romantic hits", "keyboard accompaniment", "poor audio quality", "passionate", "groovy bass line"] | 1 | DKflAAykh6A | 1464 | |
American Folk Blues Festival 1983 feat. Carey Bell | The song is an instrumental blues song. The song is medium tempo with a blues harmonica playing a cool melody, walking bass line, guitar accompaniment , steady drumming rhythm and other percussion hits. The song is exciting and groovy. The song has a bad audio quality. | 2006-06-16T20:47:21Z | Harpsucker | Carey Bell-voc/harmonica Louisiana Red-git Jimmy Rodgers-git Lovie Lee-piano Queen Sylvia Embry-bass Charles"Honey Boy"Otis-drums rec-live in germany 1983 | ["Blues", "Music"] | ["blues harmonica", "blues harp", "harpist", "instrumental music", "harmonica player", "groovy bass line", "guitar rhythm", "steady drumming", "the blues", "blues progression", "instrumental music", "soaring melody", "bad audio quality", "blue band", "walking bass line", "blues turn around", "blues legends", "medium tempo", "adventurous", "exciting", "groovy", "slow dance", "passionate", "spirited"] | 1 | GT9g4uqK9G8 | 1725 | |
Rock Band 3 - Bohemian Rhapsody [Splitscreen] [100% FC Expert Pro Keys] | The song is an instrumental. The song is medium tempo and tempo changes occur later, with piano accompaniment, guitar solo, chord changes, steady drumming rhythm, rhythm guitar, and strong bass line . The song is an iconic rock hit and has a bad audio quality. | 2011-07-07T00:24:37Z | RockerSVK | Bohemian Rhapsody - Queen XBL Gamertag: RockerSVK My friend lent me a camera so I could finally record my hands playing pro keys as many of you requested that. I ReFCd Bohemian Rhapsody just to show you my hands, I also made it one handed just for you. I even improved my best score :) Also notice this is my first splitscreen video ever so I hope you like it :D Btw I recorded my hands playing 2 other songs I already FCd (you can guess which ones) so stay tuned :) I had to change a pitch of audio track half a semitone up otherwise the video will be blocked in some countries. Sorry for that. | ["Swing music", "Musical instrument", "Keyboard (musical)"] | ["electric guitar lead", "chord changes", "specials sound effects", "groovy bass line", "piano accompaniment", "classic rock song", "instrumental music", "cymbal crashes", "piano accompaniment", "emotional", "sentimental", "rock super-hits", "passionate", "spirited", "cult classic", "bad audio quality", "passionate", "energetic", "youthful", "iconic solo", "rock anthem", "tempo changes", "medium tempo"] | 1 | LR3U4b_fVBc | 2186 | |
Sylwia Grzeszczak - Flirt [Official Music Video] | A female singer sings this emotional melody. The song is medium tempo with guitar strumming rhythm, strong bass line, steady drumming rhythm, keyboard accompaniment and sound effects. The song is emotional and romantic. The song is a euro pop love song and has poor audio quality. | 2013-04-16T09:57:50Z | SylwiaGrzeszczak | ✅ Subskrybuj: https://bit.ly/WMP_YT ✅ Instagram https://instagram.com/warnermusicpoland ✅ Facebook: https://fb.com/warnermusicpoland ✅ TikTok: https://www.tiktok.com/@warnermusicpoland Music video by Sylwia Grzeszczak performing Flirt. (P) 2013 The copyright in this audiovisual recording is owned by Gorgo under exclusive licence to EMI Music Poland Sp. z.o.o. | ["Music", "Tender music"] | ["female singer", "russian pop star", "medium tempo", "groovy bass line", "emotional", "passionate", "madly in love", "say sorry", "poor audio quality", "guitar strumming", "groovy bas line", "sonic effects", "keybiard accompaniment", "steady drumming rhythm", "romantic", "love song", "euro pop hits"] | 1 | ORikRIu7s1o | 2440 | |
Frank Heinen auf der Wersi-Orgel in Konzert! | The song is an instrumental. The tempo is medium with a groovy bass line, keyboard accompaniment, percussive bass line , steady drumming drumming and other percussion hits. The song is a pop song cover with a bad audio quality. | 2009-08-26T20:34:40Z | derjaschka | Ausschnitte von diversen Veranstaltungen 2009! https://www.facebook.com/frankheinenwersi | ["Organ", "Electric piano", "Electronic organ", "Keyboard (musical)", "Piano"] | ["church organ playing", "instrumental music", "passionate", "emotional", "romantic", "love song", "greatest love sings", "song cover", "live performance", "ambient noises", "bad audio quality", "medium tempo", "ethereal harmony", "bell tones", "keyboard accompaniment", "groovy bass line", "pop super hits", "retro pop hits", "romantic", "eternal love", "together forever", "never give up"] | 1 | Pgpd1yxLcLI | 2558 | |
Gunshot - ROCMA ( Feat. XEptional ) | A male rapper sings this groovy melody. The song is medium tempo with a steady drumming rhythm, groovy bass line, a melancholic flute countermelody, keyboard harmony and guitar accompaniment. The song is exciting and passionate. The song is a modern Russian rap song with a story telling nature. | 2014-04-05T21:46:22Z | Mehdi Rafale | Produced and Mixed by XEptional https://www.facebook.com/Gunshot.officiel https://www.facebook.com/thexeptionalpage | ["Music", "Rapping", "Hip hop music"] | ["male rapper", "russian rap music", "medium tempo", "purposeful", "inspiring", "underground music", "youthful", "discotheque", "hardship", "flute countermelody", "guitar accompaniment", "groovy bass line", "steady drumming rhythm", "steady drumming rhythm", "keyboard harmony", "poignant", "melancholic", "emotional", "russian hit songs", "euro pop", "groovy music", "dance music", "dance mix", "dance club", "people dancing", "passionate", "story telling"] | 1 | TakkuFZJsis | 2849 | |
BIG MONTUNO - LATIN PERCUSSION | The song is an instrumental. The song is in medium tempo with various Latin percussions playing syncopated rhythms and an organ playing accompaniment. The song is a Latin Jazz tune with a definite dance rhythm. The audio quality is mediocre. | 2013-11-12T23:07:35Z | EL RINCON DE CHECHO ...! | !!! Cuenta la historia que la marca de productos de percusión y musicales LATIN PERCUSSION para poder promocionar su marca y el sonido que lograban sus instrumentos , creo la ORQUESTA LATIN PERCUSSION , reuniendo a varios artistas de la época , realizaron 16 lps y este es uno de los temas que acuñaron ..BAJO LA DIRECCION DE TITO PUENTE . !!!! !! GRACIAS AREITO !!! DISFRUTENLO ....!!! | ["Wood block", "Percussion"] | ["latin dance rhythm", "latin percussions", "mediocre audio quality", "latin dancers", "emotional", "passionate", "energetic", "organ accompaniment", "instrumental music", "latin percussion instruments", "syncopated rhythms", "groovy dance music", "groovy bass line", "latin jazz music", "medium tempo"] | 1 | UR3k09hOxI4 | 2916 | |
J. Cole - Too Deep For The Intro | Friday Night Lights | A female singer sings this cool melody with male backup singer in harmony. The song is medium tempo with a groovy bass line, steady drumming rhythm, keyboard harmony and other percussion hits. The song is groovy with a story telling nature. The song is a retro hip hop dance hit. | 2010-11-12T23:44:00Z | Archive | J. Cole - Too Deep For The Intro J. Cole - Too Deep For The Intro J. Cole - Too Deep For The Intro http://coastingonadream.tumblr.com/ | ["Music", "Rhythm and blues"] | ["female singer", "male backup singers", "hip hop music", "retro dance hits", "keyboard harmony", "groovy bass line", "rapping vocals", "story telling", "romantic", "groovy music", "energetic", "spirited", "passionate", "life lessons", "melancholic", "cheerful", "life is good", "relaxing playlists", "hip hop dance music", "medium tempo"] | 1 | UfEGX0rNOvA | 2932 | |
singing sandra crying | A female singer sings this passionate melody. The song is medium tempo with steady drumming rhythm, groovy bass line, Caribbean percussion, guitar accompaniment and a brass band playing percussively. The song is emotional and spirited. The song is a classic renege hit. | 2008-09-26T00:01:17Z | ANDY WONG KEE | music | ["Music", "/t/dd00003"] | ["female singer", "spirited singing", "reggae hits", "tropical dance hit", "caribbean music style", "trumpets blaring", "caribbean percussions rhythm", "medium tempo", "guitar accompaniment", "groovy bass line", "steady drumming rhythm", "brass band harmony", "emotional", "passionate", "reggae groove", "classic reverse hits", "spirited", "dance groove", "beachside party", "people dancing", "inspiring", "life is good", "enjoy life", "life is a dance"] | 1 | XXBVsNt2Qr8 | 3192 | |
Jakes List Jun 2012 Top 10 Independent Music Video Uploads | Male and female singers sing this vocal harmony. The song is medium tempo with a groovy bass-line, keyboard accompaniment, guitar rhythm and a steady drumming rhythm with clapping percussions. The song is exciting and groovy. The song is a classic pop hit cover with an average quality sound. | 2012-06-30T22:34:02Z | Jake Niall Foster | The top 10 music video uploads for the month of June 2012 (with a cut-off date of 22 Jun) for Independent and Unsigned artists. | ["Singing", "Music", "Independent music", "Pop music", "Song"] | ["male singer", "backup singers", "female singers", "clapping percussions", "groovy bass line", "medium tempo", "guitar accompaniment", "keybiard accompaniment", "song cover", "home studio", "average audio quality", "hissing vocals", "spirited", "passionate", "dance rhythm", "groovy rhythm", "life lessons", "motivational", "inspiring", "retro pop hits"] | 1 | lR8am4rK7qQ | 4395 | |
The Polar Express- "Believe" | A male singer sings this passionate and emotional melody. The song is medium tempo with a groovy bass line, steady drumming rhythm, piano accompaniment and an emotional string section harmony. The song is inspiring and emotional. The song is a Christmas classic and movie soundtrack. The audio quality is poor with a lot of hissing noises. | 2009-11-16T04:28:03Z | MECFilmProductions | Wow, almost 50,000 views! Thank you everyone! This took two weeks because of Windows Movie Maker, which kept malfunctioning. Then when I upload WMG Copyright kicks in. Ya well it can't beat me;) Anyway here it is in all it's splendor. It didn't turn out as well as I hoped but I have no more patience with it. Enjoy! I do not own anything, movie and music belong to respectful owners! | ["Christian music", "Music"] | ["male singer", "soaring vocals", "hissing noise", "string section harmony", "medium tempo", "movie soundtrack", "christmas", "inspiring", "steady drumming rhythm", "groovy bass line", "piano accompaniment", "orchestra playing", "inspiring", "motivational", "devotional", "christmas time", "winter wonderland", "poor quality audio", "pop hits", "christmas classics", "miracles", "santa claus", "christmas ade nature", "christmas carols", "emotional", "passionate", "reindeers", "snow", "philharmonic orchestra"] | 1 | nZ19mW-TMRk | 4551 | |
BACHATA MIX AVENTURA | A male Latin singer sings this passionate melody. The song is medium tempo with various Latin percussions, groovy bass line, keyboard harmony and a guitar playing lead. The song is romantic and a classic Latin dance groove. The song is a Latin dance hit with a deteriorating audio quality. | 2009-01-05T07:54:32Z | R G COCINA | BACHATA | ["Music", "Salsa music"] | ["male latin singer", "bad quality audio", "latin dance band", "deteriorating audio quality", "groovy dance hits", "retro latin hits", "medium tempo", "bachata", "vocal echoes", "latin percussions", "guitar lead", "keyboard tones", "enthusiastic", "emotional", "passionate", "romantic", "retro latin hits", "latin pop hits", "people dancing", "passionate", "romantic", "groovy bass line", "latin love hits", "wedding music", "people dancing", "latin dance hits", "latin dance music"] | 1 | qsRPTMXFGsA | 4830 | |
Abar (আবার) Ukulele version by - Rafa | A male singer sings this delightful melody. The song is medium tempo with a ukulele accompaniment, steady drumming rhythm with various percussions like clapping and tambourine along with a keyboard accompaniment. The song is emotional and groovy. The song is a local Indian language pop song, most probably a Bengali pop song. | 2013-12-30T22:12:20Z | AvoidRafa | This song of mine is also available in Aurthohin's album Aushomapto 2. But that version is a whole lot heavier than this. This is my way of seeing into this piece of tune. Thanks a million to Bassbaba for writing the amazing words that made this song so positive. (Unlike me :P) Thanks to Nabil Khan for the insane video he pulled in just half an hour of shoot and one night of editing. I am very pleased to present you with this video. There will be more soon :) Here's the link for the song https://soundcloud.com/avoidraef/abar-ukulele-version | ["Music", "Musical instrument", "Ukulele", "Plucked string instrument", "Bowed string instrument"] | ["male singer", "indian music", "ukulele accompaniment", "bengali pop song", "emotional", "spirited", "message of kindness", "passionate", "love anthem", "madly in love", "adore you", "medium tempo", "groovy music", "tambourine percussion", "steady drumming rhythm", "clapping rhythm", "groovy bass line", "indian pop song", "private music video"] | 1 | x1x54MgStxQ | 5301 | |
Melbourne Ska Orchestra - The Best Things In Life Are Free | A male singer sings this jazz melody with the backup singer in vocal harmony. The song is medium tempo, with saxophone harmony, ska drumming rhythm and a good bass line. The song is entertaining and groovy. The song is a classic jazz tune played in ska style. | 2012-12-06T06:35:18Z | Melbourne Ska Orchestra | The Melbourne Ska Orchestra's take on 1920's classic, "The Best Things In Life Are Free" from their 2013 self-titled album. Available here: https://abcmusic.lnk.to/MelbourneSkaOrchestra This music video was filmed at the legendary Allan Eaton Studios in Melbourne, Australia and features vocalist Pat Powell. The track featured on Freeview Australia's national TV campaign with Melbourne Ska Orchestra Conductor/MC Nicky Bomba and members of the orchestra. www.melbourneskaorchestra.com Video Clip produced by Bison Films and Clayton Jacobson | ["Music", "Ska"] | ["male singer", "reggae music", "ska band", "dance rhythm", "people dancing", "band recording", "classy", "medium tempo", "guitar accompaniment", "bass guitar", "saxophones harmony", "backup singer", "vocal harmony", "groovy bass line", "jazz music", "funky jazz", "percussive horn section", "joyful", "passionate", "medium tempo", "syncopated vocals", "ska orchestra", "jazz hits", "life’s truths"] | 1 | xUVvBF9BWdg | 5333 |
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;