musiccaps_details (view)
12 rows where musiccaps_aspects contains "animated", musiccaps_aspects contains "fast tempo" and musiccaps_aspects contains "youthful"
This data as json, CSV (advanced)
musiccaps_aspects (array) 156 ✖
- animated · 12 ✖
- fast tempo · 12 ✖
- youthful · 12 ✖
- vivacious 7
- dance music 6
- buoyant 5
- club music 5
- enthusiastic 5
- spirited 5
- vibrant 5
- male singer 4
- rock 4
- vigorous 4
- vital 4
- digital drums 3
- electronic music 3
- groovy bass line 3
- hard rock 3
- instrumental 3
- intense drumming 3
- keyboard harmony 3
- male vocalist 3
- pop rock 3
- punchy 3
- synth pop 3
- synthesiser arrangements 3
- vigorous drumming 3
- catchy 2
- classic rock 2
- concert 2
- dance floor 2
- dance groove 2
- dance hits 2
- dj 2
- edm 2
- electro pop 2
- energetic 2
- female singer 2
- funky bass line 2
- happy 2
- hard hitting drums 2
- intense 2
- metal 2
- synth rock 2
- synthesiser articulation 2
- video game music 2
- ambient 1
- amplified keyboard harmony 1
- amplified viloin 1
- animate 1
- animated electric guitar accompaniment 1
- animated instrumentation 1
- animated melody 1
- animated vocals 1
- auto tune 1
- auto tuned voice 1
- backup vocals 1
- brass band 1
- brass instruments 1
- bright 1
- bright bass lines 1
- bright vocals 1
- burgeoning music 1
- busy 1
- busy music 1
- camera roll sound 1
- captivating keyboard harmony 1
- cello drone 1
- chaotic 1
- cheerful 1
- cheering 1
- children’s song 1
- clapping 1
- dance pop 1
- digital sound effects 1
- digital soundeffect 1
- dj mis 1
- dj mix 1
- dj mixer 1
- dominating electric guitar 1
- electric guitar feedback 1
- electric guitar melody 1
- electrifying music 1
- electronic instrumentation 1
- electronic rhythm 1
- electronic instrumentation 1
- electronic instruments 1
- emphatic vocals 1
- energetic electric guitar harmony 1
- energetic music 1
- engaging 1
- enthusiastic drumming 1
- enthusiastic vocals 1
- excite crowd 1
- female vocal riff 1
- foreign language 1
- foreign language introduction 1
- fun 1
- funk pop 1
- groovy bass lines 1
- groovy saxophone 1
- harmonious 1
- heavy metal 1
- imposing music 1
- intense electric guitar feedback 1
- keyboard accompaniment 1
- live performance 1
- lively 1
- lively trumpet 1
- loud electric guitar feedback 1
- oud cymbals 1
- passionate 1
- peppy 1
- perky 1
- pop 1
- powerful 1
- progressive 1
- progressive metal 1
- psychedelic 1
- pulsating 1
- punchy drum rhythm 1
- punk rock 1
- rhythmic 1
- rhythmic acoustic guitar 1
- rock hits 1
- scratching sounds 1
- skilled guitarist 1
- slick drumming 1
- slow beginning 1
- soft paino 1
- song beginning 1
- spirited drumming 1
- spirited enthusiastic 1
- spirited vocals 1
- spirted 1
- steady bass line 1
- subdued vocals 1
- synth arrangements 1
- synthesiser arrangement 1
- teen pop 1
- throbbing 1
- trance trippy 1
- trap 1
- turn table 1
- untiring 1
- upbeat 1
- upbeat electronic riff 1
- upbeat vivacious 1
- vigorous background music 1
- vigorous bass lines 1
- vigorous keyboard harmony 1
- vinyl records 1
- vocal backup 1
- whirring sound 1
- wind instrument 1
- woodwind 1
musiccaps_names (array) 13 ✖
- Music 12
- Angry music 3
- Burst, pop 2
- /t/dd00032 1
- Ambient music 1
- Exciting music 1
- Grunge 1
- Heavy metal 1
- Musical instrument 1
- Theme music 1
- Trance music 1
- Violin, fiddle 1
- Zing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Novo Smartphone Alcatel POP 4 | A male vocalist sings this lively pop. The tempo is fast and peppy with animated trumpets, groovy saxophone, slick drumming, funky bass line, keyboard harmony, synthesiser arrangements and electronic sounds. The song is upbeat, energetic, enthusiastic, youthful, vibrant, effervescent; passionate and electrifying. This song is Synth Pop. | 2016-08-16T22:34:36Z | Alcatel Brasil | Conheça o novo Smartphone Alcatel POP 4. Com tela de de 5", Memória de 40GB, câmera de 13MP e Selfie de 8MP, 4G e ainda vem com 3 Capinhas diferentes. Para mais informações, acesse nosso site oficial: https://www.alcatelshop.com.br/detalhe-produto/smartphone-alcatel-pop4-5-premium-memoria-40gb8mais32-sd-3-capas-camera-13mp-selfie-8mp-flash4g/493310 | ["Music", "Burst, pop"] | ["male vocalist", "fast tempo", "lively trumpet", "synth pop", "funk pop", "electrifying music", "passionate", "vital", "catchy", "engaging", "buoyant", "groovy saxophone", "keyboard harmony", "slick drumming", "synthesiser arrangements", "digital drums", "brass instruments", "wind instrument", "woodwind", "brass band", "rhythmic", "animated", "youthful", "dance music", "club music", "dj", "dance floor", "dance pop", "enthusiastic", "vivacious", "bright"] | 7 | 1pR0SgbqP3M | 313 | |
I Prevail - Stuck In Your Head (Official Music Video) | A male vocalist sings this enthusiastic Rock song. The tempo is fast with bright drumming, enthusiastic electric guitar harmony, keyboard accompaniment , groovy bass line. The song is youthful, enthusiastic, energetic, vital, vigorous and passionate rock. | 2016-10-22T16:00:46Z | IPrevailBand | Stream ‘TRUE POWER’ - https://found.ee/iptruepower Get Official I Prevail merch - https://found.ee/tp_merch "Stuck In Your Head" taken from the album 'Lifelines' available now. ITUNES: http://smarturl.it/IPlifelines Video by Drew Russ. http://drewruss.com/ Follow I Prevail: Website: https://found.ee/ip_web Facebook: https://found.ee/ip_facebook Twitter: https://found.ee/ip_twitter Instagram: https://found.ee/ip_instagram TikTok: https://found.ee/ip_tiktok Spotify: https://found.ee/ip_spotify Apple Music: https://found.ee/ip_applemusic Stay Connected with Fearless Records: Website: http://www.fearlessrecords.com/ Facebook: https://found.ee/FearlessFB Instagram: https://found.ee/FearlessIG Twitter:https://found.ee/FearlessTW Subscribe to Fearless Records on Youtube: http://found.ee/fr_youtube LYRICS: You’re not the one I want in my bed But I’m gonna be the song stuck in your head Stuck in your head Stuck in your head Guess what? For the record you’re the broken one Tried to sing along but we got stuck So we turn it over and over again But now, a thousand scratches on the song we held A million cuts finally wore it down Couldn’t turn it over and over again Turn it over and over again This’ll be the last time that I spin our life Never gonna play again You’re not the one I want in my bed I’m not the song you want in your head This’ll be the last time that I spin our life Never gonna play again You’re not the one I want in my bed But I’m gonna be the song stuck in your head Stuck in your head Guess what? Didn’t wanna have to write these words Now you’re on the other side reversed Never turning over and over again So now, I’ll turn it off cuz it’s so damn loud All your lies finally wore me down You can skip our track, cuz I’m not coming back This’ll be the last time that I spin our life Never gonna play again You’re not the one I want in my bed I’m not the song you want in your head This’ll be the last time that I spin our life Never gonna play again You’re not the one I want in my bed But I’m gonna be the… | ["Music", "Exciting music"] | ["male singer", "fast tempo", "rock", "hard rock", "metal", "heavy metal", "hard hitting drums", "animated electric guitar accompaniment", "groovy bass line", "captivating keyboard harmony", "enthusiastic vocals", "youthful", "electronic music", "dance music", "energetic", "enthusiastic", "spirited", "animated", "vigorous", "vital", "dance groove"] | 7 | 5keRbrVx-G4 | 690 | |
I Say Yes (Zero no Tsukaima - Futatsuki no Kishi) | A female vocalist sings this energetic song. The tempo is fast with enthusiastic drumming, funky bass line, keyboard harmony and synthesiser arrangements. The song is youthful, vibrant, vivacious, hyper, spirited, passionate, bright and has a dance groove. This song is an Electro Pop song. | 2008-07-11T15:03:54Z | Aiath86 | Album: Exit Trance Presents Speed Anime Trance Best 4 | ["Music", "Trance music"] | ["female singer", "fast tempo", "foreign language", "dance music", "dance hits", "club music", "dance music", "electronic instrumentation", "synthesiser arrangements", "spirited drumming", "keyboard harmony", "groovy bass line", "busy music", "electro pop", "animated", "spirited", "emphatic vocals", "youthful", "upbeat electronic riff", "vibrant", "vivacious"] | 7 | BkoCi-IZccI | 1287 | |
Ratrace Music Video | A male vocalist sings this simple, peppy melody. The tempo is fast with keyboard harmony, enthusiastic drumming, steady bass line, acoustic guitar rhythm and electronic arrangements. The song is fun, animated, upbeat, catchy, energetic, spirited and vibrant and appealing to children . This song is a Synth Pop/Rock. | 2008-10-01T02:40:34Z | PlasticManFilms | Aniamting to the song Ratrace. clips of many of our videos along with the stort story of a hobo who has a spending problem.PLEASE COMMENT | ["Music", "/t/dd00032"] | ["male singer", "fast tempo", "energetic music", "peppy", "buoyant", "electronic rhythm", "enthusiastic drumming", "rhythmic acoustic guitar", "steady bass line", "fun", "youthful", "animated", "spirted", "vivacious", "happy", "children’s song", "synth arrangements", "synth pop", "pop rock"] | 7 | EaGhKzpkNso | 1574 | |
Avantasia - Wastelands (Michael Kiske) | A male vocalist sings this high energy Rock song. The tempo is fast with enthusiastic and skilled bass guitar lines, intense, hard hitting drums, groovy electric guitar accompaniment and rhythmic keyboard. The song is youthful, animated, spirited, animated,vigorous, incredibly vital and vivacious. This song is Hard Rock/ Progressive metal. | 2010-03-24T12:02:47Z | Artem Reva | The new edition of Tobias Sammet's AVANTASIA will be released as two separate albums entitled "The Wicked Symphony" and "Angel Of Babylon". Status: Ready to be release. Record deal: Nuclear Blast Records. Album scheduled for release in April 3rd 2010. The Japanese edition on 31th March. Michael sings on "Stargazers", "Wastelands", "Runaway Train" and "Promised Land". | ["Heavy metal", "Music", "Angry music"] | ["male vocalist", "fast tempo", "hard rock", "vigorous bass lines", "youthful", "animated", "vigorous", "vital", "vivacious", "progressive", "metal", "progressive metal", "intense electric guitar feedback", "intense drumming", "funky bass line", "vigorous keyboard harmony", "spirited vocals", "rock", "hard rock", "skilled guitarist", "youthful", "vibrant"] | 7 | JRmfjBDKCpE | 2006 | |
► Animash - United State of Pop - MashUp ◄ || Happy New Year ;D || and now 400+ Subbies :) | A male vocalist sings this animated and upbeat pop song. The song starts with a slow tempo with male vocals and soft but emphatic piano accompaniment and cello drone, and a whirring sound like a camera rolling. Post this the song picks up to an upbeat tempo with hard hitting drumming, cymbal rides, upbeat synthesiser harmony and electronic instruments. The song is a ,vibrant, spirited, bouncy, punchy, vivacious, youthful Electronic Dance music/Synth Pop. | 2010-01-02T11:40:42Z | White Liolynx | Edit - on september 13th Huh... I thougt a long time about it, and now... I delete ALL anotations! becasue of problems, too slow video and they were alredy too much! o.o so, hope nobody is angry of me *blush* and thanks you all for 1.000 "likes" on this video =D _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ UPDATE of the January 5th, 2010 : WOW! I get in 3 days 60 new subbies? omfg, THANK YOOOOOOOOOOOOOOOU!! ANNOTATIONS - LINK : - - - (this link is "closed" now, maybe I will write it someday here again xD) hehe, as I saw this remix, I thoght "ooooh my god!...i love it... yay I'm making an animash with it" =D Its for new yeah, but I've had some problems, so its too late =( well, but I hope you like it anyway =) hmm, I think the video looks really simple..but it was hard to work on it =P weeeell... ^^ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ • PROGRAMM : Sony Vegas Pro 9 Song : United State of Pop 2009 (Blame It on the Pop) © DJ Earworm Clips: Bambi 2 Lady and the Tramp 1 and 2 Lion King 1 and 2 Brother Bear 1 Fox and the Hound 1 and 2 Oliver & Co. Aristocats 101 Dalmatians Bolt © Disney/ Pixar Spirit © Dreamworks Balto 1 © Universal All Dogs go to Heaven 2 © MGM Ice Age © Blue Sky Studios HONORS: Second day: #77 - Most Discussed (Today) - Germany #11 - Most Discussed (Today) - Film & Animation - Germany #10 - Top Favorited (Today) - Germany #2 - Top Favorited (Today) - Film & Animation - Germany #20 - Top Favorited (Today) - Film & Animation #24 - Top Rated (Today) - Germany #2 - Top Rated (Today) - Film & Animation - Germany #51 - Top Rated (Today) - Film & Animation #11 - Top Rated (This Week) - Film & Animation - Germany Third day: #50 - Most Discussed (Today) - Germany #4 - Most Discussed (Today) - Film & Animation - Germany #74 - Most Discussed (Today) - Film & Animation #85 - Most Discussed (This Week) - Film & Animation - Germany #46 - Most Viewed (Today) - Germany #86 - Most Viewed (Today) - Film & Animation - Germany #85 - Most Viewed (Today) - F… | ["Music", "Burst, pop"] | ["male vocalist", "slow beginning", "cello drone", "digital drums", "electronic music", "electronic instrumentation", "auto tune", "fast tempo", "edm", "synth pop", "buoyant", "punchy", "vibrant", "animated", "youthful", "spirited", "burgeoning music", "whirring sound", "camera roll sound", "auto tuned voice", "animated instrumentation", "soft paino", "vigorous drumming", "oud cymbals", "vocal backup", "female vocal riff", "song beginning", "pop", "pop rock", "animate", "buoyant", "happy", "lively", "spirited"] | 7 | KMQmM12G9Z4 | 2076 | |
Super Smash Bros 64 move swap | This song is an instrumental. The tempo is fast with an animated keyboard harmony, funky bass lines; groovy electric guitar melody, slick drumming and synthesiser arrangements. The instrumental is upbeat, catchy, vibrant, animated, youthful and vivacious. This song is an Electro Rock/ Synth Rock. | 2009-04-18T22:29:08Z | YoYoSpln | Super Smash Bros 64 move swap HEX | ["Music", "Ambient music"] | ["instrumental", "fast tempo", "synthesiser articulation", "electric guitar melody", "keyboard harmony", "upbeat", "vivacious", "youthful", "electric guitar feedback", "groovy bass lines", "intense drumming", "animated", "vibrant", "catchy", "youthful", "upbeat vivacious", "rock", "synth rock", "punk rock"] | 7 | VNjYW4OXqTs | 2996 | |
Voice Hands Machine - Take Your Hand | A male vocalist sings this spirited song. The tempo is fast with electronic instrumentation, synthesiser articulation and turn table. The song is spirited,youthful , enthusiastic, energetic, vigorous and vital. This song is an EDM/ Synth Pop song. | 2011-06-26T23:35:39Z | VoiceHandsMachine | Voice Hands Machine - Take Your Hand GET IT on ITUNES: http://bit.ly/tyhitu Website: http://bit.ly/vhm_www Facebook: http://on.fb.me/vhm_fb TAKE YOUR HAND is the new single from the fresh Paris talent, Voice Hands Machine. | ["Music", "Zing"] | ["male singer", "fast tempo", "edm", "electro pop", "dj mix", "youthful", "animated", "vigorous", "vital", "enthusiastic", "dance groove", "electronic music", "turn table", "dj", "animated vocals", "synthesiser articulation", "scratching sounds", "vinyl records", "dj mis", "dj mixer", "dance music", "dance floor", "club music", "ambient"] | 7 | X7qFgrAl3OU | 3163 | |
【東方】TAM TOHO Violin LIVE! 05 ナイト・オブ・ナイツ Night Of Knights | This music is an animated instrumental. The tempo is very fast with a violin playing a very vigorous and upbeat amplified violin harmony with synthesiser arrangements and punchy digital drumming.The music is pulsating, energetic, enthusiastic, throbbing, youthful,powerful, compelling, engaging and untiring. The audio quality is inferior and there are sounds of hustling,people clapping along, chatting and cheering Indicating that this is a live performance. | 2010-05-18T13:53:31Z | TAM [タム] ViolinPiano 放浪のバイオリニスト | Violin:TAM(TAMUSIC) バイオリン:タム(タムシック) 二次創作:ビートまりお(COOL&CREATE)http://cool-create.cc/ ZUN (上海アリス幻樂団) : Original Violin:TAM http://tam3.name/ Product:TAMUSIC http://tamusic.jp/ 10.04.29 大⑨州東方祭2 dai9shuu touhou sai inKyushu 10.04.29 大⑨州東方祭2 @九州小倉 http://www11.atpages.jp/daikyusyutoho... の3:30からスタートしたライブ企画の一幕です ライブ観客2000人弱?(一列35~40人?×50列?)の前で、前回に引き続きライブをやらせて頂きました ・関連動画 【東方】ナイト・オブ・ナイツをバイオリンで弾いてみた【演奏】 http://www.youtube.com/watch?v=S4IarEh_23Q | ["Theme music", "Music", "Musical instrument", "Violin, fiddle"] | ["instrumental", "fast tempo", "amplified viloin", "throbbing", "pulsating", "powerful", "untiring", "punchy drum rhythm", "youthful", "animated", "cheerful", "vigorous background music", "synthesiser arrangement", "vigorous drumming", "clapping", "cheering", "live performance", "concert", "excite crowd", "animated melody", "harmonious", "spirited enthusiastic"] | 7 | bNvp4y9WSGM | 3620 | |
Ace Pk Session 1 | Maxed Chaotic Pure | 100% Pure Hybridding | Eruption of Pures | A male vocalist sings this spirited Rock song. The tempo is fast with an upbeat Amplified keyboard harmony, hard hitting drums, punchy bass lines and a dominating electric guitar accompaniment. The vocals are subdued for a Rock song. The song is youthful, vibrant, energetic, enthusiastic, buoyant, punchy and vivacious. This song is Classic Hard Rock. | 2011-11-25T01:44:13Z | AceyFiasco | I tried my best guys, all feedback is appreciated. You can join the clan I'm in @ EoP-Rs.com Runescape is owned and operated by Jagex Limited ("JaGeX"), I Do Not own Runescape i make videos for entertainment purposes "Only" and not for the sake of profiting.All music used in my videos is purchased and not for the intent of redistributing it. You Can Play Runescape At: http://www.runescape.com IGNORE THE FOLOWING~~~~~~~~~~~~~ bounty hunter TERMPINATION TERMPINATIONZ BH VID # 1 blue stanger TERPINATIONownage range of ish PD OWN TRILE12 STR B0S 001 runescape bs bh pking bounty hunter pking blue bountyhunter bs bh rs runescape jagex ltd rs elvemage kids ranqe defil3d elf mage pka i ayzee i wildy owns1 spanjol 91 bloodhoun34zezima youbleedred i kasoy i xxphatmagexx dawgsaysftw skychi review best Bounty Hunter video armadylgodsword ownage ko pk whip pks barrow pks spartacus121 best pker in rs best pker pk vid. best pker bounty hunter vid Archer96 Letterbomb05's Dark Bow theunforgiving yogosun yogosun2 fat wrecked zeldagirl8 lvl126inrs sosolid2k maxboisen Tehnoobshow Runescape Zezima Interview max hits high hits Best Lure video ever purple 0wnz bloodhoun34 OMG runescape pking wild pker ownage zezima phat lure KIDS RANQE PURPLE 0WNZ ZEZIMA N0VALYFE PHAT LURE OWNAGE RUNESCAPE WILDY WILDERNESS ELVEMAGE ELVEMAGE RUNESCAPE PKING RUN3 4RR0WPK OWNAGE MAIKEL PRO I MAHATMA I EVO BLOODHOUN34 KIDS RANQE KRAZYFAKEN RUNESCAPE PKER RUNESCAPE PKING INTIATE PURE OWNAGE LURE PHAT 99 1337 PWNAGE PKING PKERS PK PARTYHAT ZEZIMA N0VALYFE RUNESCAPE WILDY BARRAGE ANCIENTS LURING FROSTYDAPKER JETCHIMP BLOOD SEASON BLOODHOUN34 I Mahatma I, Stonecoldpkr,P0ke N Die2, Sourpatchk1d, Krazyfaken, Kids Ranqe ,dragon claws maxxing 1 Pure Devil, Evilsexc, Dizzy Mauler, I Shonomercy, E4t F0od Nub, Im Easy Xp, Iminsan3, Pure insan3, and Xoxofuryxoxo.pvp best loots whipper whip elvemage sv3rige bloofhoun34 is elvemage bloodhoun34 hiei the pk lexmark78 6th outlaw i meleed i ultimate strength hybrid barrage blitz burst 99 range mage krazyfaken f… | ["Music", "Grunge"] | ["male singer", "fast tempo", "rock", "hard rock", "dominating electric guitar", "punchy", "buoyant", "vivacious", "video game music", "animated", "chaotic", "busy", "rock hits", "concert", "hard hitting drums", "loud electric guitar feedback", "amplified keyboard harmony", "funky bass line", "subdued vocals", "imposing music", "youthful", "energetic", "enthusiastic", "spirited", "vivacious", "classic rock", "intense"] | 7 | dHGAXJ9RPJs | 3773 | |
Hawaiian Roller Coaster Ride- Jump 5 (Lyrics) | A female vocalist sings this spirited pop song. The tempo is fast with vigorous drumming, animated electric guitar harmony, keyboard accompaniment and groovy bass lines along with backup vocals. The first bit of the song is sung in foreign language. The song is energetic, youthful, passionate, vibrant and vivacious with a dance groove. This song is Teen Pop/Pop Rock. | 2009-08-22T02:50:00Z | Javiix7 | lyrics this is one of my favorite songs | ["Music", "Angry music"] | ["female singer", "fast tempo", "vigorous drumming", "teen pop", "foreign language introduction", "vibrant", "vivacious", "teen pop", "dance music", "club music", "energetic electric guitar harmony", "bright bass lines", "bright vocals", "backup vocals", "animated", "youthful", "enthusiastic", "dance music", "perky", "punchy", "buoyant", "pop rock", "classic rock", "keyboard accompaniment"] | 7 | id5ibIqjRto | 4208 | |
Full Torva + Divine PKing - HIGH RISK! 2b+ | This song is an animated instrumental. The tempo is fast with synthesiser arrangements, intense drumming, groovy bass lines and digital sound effects. The music is upbeat, catchy, compelling, youthful, psychedelic, trance like and intense with an upbeat dance groove. This song is contemporary Synth Pop. | 2011-03-02T22:56:59Z | Pixel Bones | Make sure you thumbs up :)! CRAZY RISK! | ["Music", "Angry music"] | ["instrumental", "fast tempo", "synth rock", "animated", "video game music", "psychedelic", "digital sound effects", "vigorous", "intense", "trap", "trance trippy", "psychedelic", "dance music", "dance hits", "club music", "youthful", "spirited", "groovy bass line", "intense drumming", "synthesiser arrangements", "electronic instruments", "digital drums", "digital soundeffect"] | 7 | pn6toTLXAck | 4734 |
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;