musiccaps_details (view)
16 rows where musiccaps_aspects contains "club music" and musiccaps_aspects contains "synthesiser arrangements" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 191 ✖
- club music · 16 ✖
- synthesiser arrangements · 16 ✖
- fast tempo 13
- dance music 12
- youthful 12
- dance pop 9
- buoyant 7
- dj 7
- edm 6
- digital drums 5
- electronic music 5
- energetic 5
- enthusiastic 5
- instrumental 5
- keyboard harmony 5
- psychedelic 5
- punchy 5
- spirited 5
- synth pop 5
- dance hits 4
- electro pop 4
- male vocalist 4
- trance 4
- trap 4
- animated 3
- catchy 3
- dance groove 3
- digital drumming 3
- groovy 3
- groovy bass line 3
- male singer 3
- slick drumming 3
- tambourine beats 3
- techno music 3
- vibrant 3
- vivacious 3
- bongos 2
- congas 2
- deep house 2
- electronica 2
- female singer 2
- foreign language 2
- groovy bass lines 2
- intense 2
- party music 2
- pop 2
- reverb 2
- vigorous drumming 2
- advanced chord structure 1
- ambient mixes 1
- ambulance siren 1
- amplified flute 1
- amplified ney 1
- atmospheric 1
- atmospheric music 1
- bachata 1
- boomy bass 1
- boomy bass drops 1
- bouncy 1
- brass band 1
- brass instruments 1
- breezy fresh 1
- bright 1
- bright steel drumming 1
- bulgarian 1
- busy music 1
- catchy vocal riff 1
- congas rhythm 1
- creepy 1
- cymbal ride 1
- dance floor 1
- dancing 1
- dangerous 1
- digital drum 1
- digital music 1
- digital sound effects 1
- digital soundeffect 1
- disco rap 1
- distorted music 1
- distorted sound 1
- dj mixer 1
- drum machine 1
- duet 1
- eerie 1
- electrifying 1
- electrifying music 1
- electro rock 1
- electronic instrumentation 1
- electronic effects 1
- electronic instrumental 1
- electronic instruments 1
- electronic pop 1
- emphatic vocals 1
- energetic drums 1
- energetic vocal backup 1
- engaging 1
- enigmatic 1
- fast beats 1
- female laughing 1
- female vocalist 1
- female vocals 1
- frightening 1
- funk pop 1
- funky 1
- goth rock 1
- groovy saxophone 1
- grunting 1
- hand percussion 1
- heavy reverb 1
- high spirited 1
- high strung 1
- hip-hop 1
- hip-hop pop 1
- incessant beats 1
- incoherent vocals 1
- inferior sound quality 1
- intense drumming 1
- latin dance music 1
- latin hits 1
- latin song 1
- latin urbano 1
- laughing 1
- lively 1
- lively piano 1
- lively singing 1
- lively trumpet 1
- male vocalists 1
- medium fast 1
- medium fast tempo 1
- melodious 1
- menacing voices 1
- middle eastern music 1
- ney 1
- oud 1
- oud rhythm 1
- party hits 1
- passionate 1
- perky 1
- pleasant 1
- police van siren 1
- pop folk 1
- pop rap 1
- pulsating 1
- pulsating beats 1
- punch 1
- punchy beat 1
- punchy drum beats 1
- punchy youthful 1
- punk rap 1
- rap 1
- rapid tempo 1
- recurring vocal riff 1
- repetitive 1
- rhythmic 1
- rhythmic bongos 1
- rhythmic patter 1
- roaring 1
- rock 1
- rock and roll 1
- romantic 1
- salsa 1
- shakers 1
- simple melody 1
- sinister 1
- soulful vocals 1
- spanish music 1
- spirited drumming 1
- steady drumming 1
- stimulating 1
- surround sound 1
- syncopated harmony 1
- synth rock 1
- synthesised music 1
- synthesised vocal riff 1
- techno mix 1
- techno pop 1
- throbbing 1
- thumping beat 1
- trance trippy 1
- trippy music 1
- unobstructive 1
- upbeat 1
- upbeat electronic riff 1
- video game music 1
- vigorous 1
- vigorous beat 1
- vigorous rhythmic speech 1
- vital 1
- vocal riff 1
- wind instrument 1
- woodwind 1
musiccaps_names (array) 24 ✖
- Music 16
- Dubstep 3
- Electronic dance music 3
- Trance music 3
- Dance music 2
- Disco 2
- Drum and bass 2
- Electronic music 2
- Music of Africa 2
- Techno 2
- Afrobeat 1
- Angry music 1
- Burst, pop 1
- Electronica 1
- Flamenco 1
- Giggle 1
- Harmonic 1
- House music 1
- Maraca 1
- Rapping 1
- Sampler 1
- Shuffle 1
- Ska 1
- Song 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 | |
Per Andersson ''Pump up the Jam'' (Så ska det låta 2012) | This song is a lively duet by two male voices. The tempo is fast with amplified piano, infectious drumming; tambourine beats and synthesiser arrangements. The song is youthful,fun, happy, groovy, energetic, buoyant, and high spirited. This song is called Deep House. | 2012-12-31T17:35:29Z | Theboxen21 | Per Andersson ''Pump up the Jam'' (Så ska det låta 2012) | ["Music", "Ska"] | ["male vocalists", "duet", "fast tempo", "electronic music", "spirited", "buoyant", "club music", "dance music", "dance pop", "techno music", "digital music", "synthesiser arrangements", "deep house", "lively", "youthful", "shakers", "digital drums", "lively singing"] | 7 | 6-MdbipzKS0 | 712 | |
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 | |
Bad Boy Bill - Classics Vol. 2 - Old School Chicago House Music Trax Wbmx Wgci Wcrx | A male vocalist sings this energetic song. The tempo is fast with synthesiser arrangements, digital drumming and tambourine beats along with an incessant catchy vocal riff and vocalisation. The music is buoyant, energetic,enthusiastic , pulsating, punchy and groovy. This song is Techno Pop. | 2011-11-13T00:00:07Z | djmake | This is a Old Mix from Chicago's Very Own Bad Boy Bill. Old Cassette Mix that was converted to cd. Contact info: Djmake@sbcglobal.net - email www.facebook.com/djmakemoney - fan page www.facebook.com/illtechnics - facebook page | ["Afrobeat", "Disco", "Music"] | ["male vocalist", "fast tempo", "electronic music", "techno pop", "synthesiser arrangements", "tambourine beats", "digital drumming", "surround sound", "rock and roll", "techno mix", "electro pop", "trance", "psychedelic", "energetic", "enthusiastic", "groovy", "dance pop", "dance music", "club music", "heavy reverb"] | 7 | DGlP6oTqe5Y | 1459 | |
DJ VENGEANCE - ZOMP STOMP [Jump Up Drum & Bass] | This song is an instrumental. The tempo is fast with vigorous drumming, thumping bass lines and keyboard arrangement with sounds of an ambulance or police van, menacing voices, grunting, incoherent vocal riff and whooshing sound of wind. This song is aggressive, vigorous, energetic trippy, trance like with the syncopated music giving it a eerie, sinister, creepy vibe. This song is a Hard Rock/Goth Rock. | 2008-12-21T08:14:58Z | Vengeance Music UK | DJ Vengeance - Nu Urban Artists 001 Track: Zomp Stomp sample:its a zombie Nu Artists is for, well, exactly that, new artists with plenty of potential on display. And that's precisely why Vengeance is hitting hard with his first release on this brand new imprint. First comes the Electro inspired 'Dancehall Slayer', all synthetic bubbles before the bass drops, and by then it's all over! 'Zomp Stomp' on the flip is full of beans too. This boy will go far! - Nu Urban Music Sales: http://www.nu-urbanmusic.co.uk/drum_and_bass/shop/product_info.php?products_id=11102 | ["Drum and bass", "Music", "Trance music", "Dubstep", "Electronic dance music"] | ["instrumental", "fast tempo", "trance", "trap", "police van siren", "intense", "dj", "dance music", "club music", "incoherent vocals", "trippy music", "vigorous beat", "syncopated harmony", "thumping beat", "vigorous drumming", "synthesiser arrangements", "ambulance siren", "menacing voices", "roaring", "grunting", "vocal riff", "rock", "goth rock", "sinister", "eerie", "creepy", "dangerous", "frightening"] | 7 | ItLWKIhe58c | 1950 | |
Zina Rifia "houbak nar" by SOFALK, ABDER, NABIL - Rai'n'B Fever 4 | A male vocalist sings this energetic pop song. The tempo is fast with piano accompaniment, bright digital drumming, synthesiser arrangements and groovy bass lines. The song is youthful, fresh, catchy, vivacious, upbeat, sprightly and buoyant with a dance groove. This song is a Hip-Hop Pop song. | 2011-05-01T14:45:49Z | Najim Sofalk | ZINA RIFIA AVEC SOFALK, ABDER, NABIL ET J-BEEZY ... MERCI POUR VOS COMMENTAIRES C'EST JUSTE ENORME !! | ["Music of Africa", "Music"] | ["male vocalist", "medium fast", "foreign language", "pop", "hip-hop pop", "groovy bass line", "lively piano", "digital drums", "synthesiser arrangements", "youthful", "spirited", "dance groove", "club music", "dance pop", "dance music", "groovy", "funky", "youthful", "high spirited"] | 7 | Jk2mvFrdZTU | 2030 | |
DJ HumNoy Maraca YouTube | A male vocalist sings this energetic song. The tempo is fast with synthesiser arrangements, punchy digital drumming, tambourine beats and keyboard harmony. The music is upbeat, punchy, groovy, youthful, buoyant and exciting. This song is Synth Pop. | 2013-12-03T12:25:16Z | ณ๊องจุ้น คนเดิม | ["Music", "Song", "Dance music", "Maraca"] | ["male vocalist", "fast tempo", "energetic drums", "synth pop", "buoyant", "tambourine beats", "digital drum", "synthesiser arrangements", "keyboard harmony", "energetic vocal backup", "dj", "dj mixer", "dance pop", "dance music", "club music", "youthful", "enthusiastic", "vivacious"] | 7 | S7rP6coeLTY | 2742 | ||
Rachel Barton - Giggle (Original & Yankee Zulu Remix) | This song is an instrumental. The tempo is fast with boomy bass lines, slick drumming, digital drum rhythm; keyboard harmony, synthesiser arrangements and sound of a woman laughing. The song is electric, vibrant ,youthful ,psychedelic, trippy, hysterical and buoyant with a dance groove. This song is an EDM/Synth pop. | 2010-01-19T18:24:04Z | biginibiza | Beatport: http://bit.ly/4Fo3SX. Following massive support from the likes of Mark Knight, Groove Armada, Style Of Eye, Joe & Will Ask, James Talk, Andy Mac, Jason Herd & more! As well as hitting # 8 in the mighty DMC Buzz Chart, Rachel Barton unleashes the follow up to her monsterous debut single "Who Knows". Now to kick start 2010 Rachel Barton give us Giggle (inc Yankee Zulu Remix). Download now from... Beatport: http://bit.ly/4Fo3SX Juno: http://bit.ly/74v2oD DJ Download: http://bit.ly/7rrROX Trackitdown: http://bit.ly/6t1qoZ For more information check out http://biginibiza.com | ["Sampler", "Electronic music", "Music", "Giggle", "Dance music"] | ["instrumental", "fast tempo", "laughing", "female laughing", "synthesised music", "electro pop", "boomy bass", "slick drumming", "keyboard harmony", "synthesiser arrangements", "punchy beat", "dance music", "edm", "synth pop", "psychedelic", "trance", "trap", "youthful", "energetic", "club music", "dance music"] | 7 | XcvY-NdM8WA | 3202 | |
endless squad SHUFFLE | A female vocalist sings this high energy pop song. The tempo is fast with vigorous drumming, synthesiser arrangements and boomy bass drops. The song is vibrant, lively, spirited, buoyant, punchy and youthful with a catchy vocal riff. The sound quality of this song is inferior and distorted. This song is an EDM/Synth Pop song. | 2011-08-12T07:05:36Z | omingendless | ["Drum and bass", "House music", "Music", "Techno", "Trance music", "Shuffle", "Dubstep", "Electronic dance music"] | ["instrumental", "vibrant", "high strung", "female vocals", "punchy youthful", "dance groove", "inferior sound quality", "distorted sound", "catchy vocal riff", "electro rock", "electro pop", "edm", "distorted music", "synthesiser arrangements", "dj", "dance music", "party music", "club music", "vibrant", "buoyant", "boomy bass drops"] | 7 | YWf3I4jKusI | 3291 | ||
Da Blitz - Moving On (mickey o'hare & dj harmonic remix) | This song is an electronic instrumental. The song is fast tempo with vigorous drumming and electronic instrumentation and synthesiser articulation with catchy synthesised vocal riff which. The song is upbeat, vibrant, vivacious, vigorous, psychedelic, enigmatic and youthful with a trance like dance vibe. This song is an EDM/Synth pop. | 2012-04-17T14:06:31Z | MakinaMuzika | www.facebook.com/makinamuzika | ["Music", "Techno", "Dubstep", "Electronic dance music", "Harmonic"] | ["edm", "instrumental", "fast tempo", "synth pop", "edm", "electronic pop", "electronic instrumental", "synth pop", "dance hits", "rapid tempo", "dance music", "trance", "trap", "psychedelic", "pop", "electronic music", "vigorous drumming", "synthesiser arrangements", "synthesised vocal riff", "recurring vocal riff", "club music", "dance hits", "party hits", "youthful", "energetic", "enigmatic", "enthusiastic", "dj"] | 7 | lGaA1dJQ0AQ | 4387 | |
flamenco salsero 2017 - SALSA CHOKE - CHOKECHACHE - los chaches | A male vocalist sings this spirited song. The tempo is fast with a fast keyboard harmony, boomy bass line, rhythmic drums, steel drums,congas and bongos, cymbal ride and sound of clapping. The song is upbeat, punchy, buoyant, spirited, energetic and youthful with a dance groove. This song is Latin Urbano. | 2015-04-21T18:31:13Z | Los Chaches Record | flamenco salsero 2017 - rap 2017 - salsa choke 2017 - chokechache 2017 - flamenco 2017 - maketas flamencas 2017 - perreo 2017 - rumba 2017 - rap flamenco 2017 - video bailando riko de los chaches - moncho chavea - el vaka los chaches record | ["Flamenco", "Music"] | ["male singer", "fast tempo", "latin song", "latin dance music", "bright steel drumming", "youthful", "energetic", "congas", "bongos", "cymbal ride", "buoyant", "club music", "party music", "dance hits", "latin urbano", "punchy", "spirited", "upbeat", "catchy", "spanish music", "latin hits", "salsa", "bachata", "groovy bass lines", "keyboard harmony", "congas rhythm", "rhythmic bongos", "synthesiser arrangements"] | 7 | m3uiITzeM70 | 4442 | |
¿CUAL DE ESTAS CANCIONES TE INICIO EN LA MÚSICA ELECTRÓNICA? | A female vocalist sings this upbeat electronic pop song. The tempo is fast with enthusiastic synthesiser arrangements, groovy drumming. The music is electronically arranged and has a youthful, vivacious, enthusiastic, buoyant dance groove. This music is upbeat Electronic Dance music. | 2016-11-15T22:53:12Z | Most Viewed | ----------------------------------------------------------------------------------------------------- ACÉPTALO UNA DE ESTAS CANCIONES TE INICIO EN LA MÚSICA ELECTRÓNICA. COMENTA QUE CANCIÓN NO OLVIDES DAR LIKE Y SI ERES NUEVO SUSCRIBETE SALUDOS!! ----------------------------------------------------------------------------------------------- TEMAS: 0:12 Mauro Picotto - Komodo 0:26 Darude - Sandstorm 0:40 call on me -eric prydz 0:52 Benny Benassi - Satisfaction 1:06 Alice Deejay - Better Off Alone 1:21 Lasgo - Something 1:34 Safri Duo - Played-A-Live 1:46 Gigi D'Agostino - L'Amour Toujours 1:58 Bellini - Samba De Janeiro 2:10 Paul van Dyk - For An Angel 2009 2:24 DJ Tiesto - Adagio For Strings 2:38 Tiesto - Traffic 2:53 ATB - 9PM (Till I Come) 3:09 Modjo - Lady (Hear Me Tonight) 3:22 DJ Visage Formula 1 3:36 Supermode - Tell Me Why 3:49 ATC - All Around The World (la la la la la la la la) 4:02 Benny Benassi - Illusion 4:18 Guru Josh Project - Infinity 4:31 Airplay - The Music is Moving 4:45 Eiffel 65 - Blue (Da Ba Dee) 5:00 Barthezz - On The Move 5:13 Mauro Picotto - Proximus 5:27 DJ Encore feat Engelina - I See Right Through To You 5:40 BBE - 7 days and one week 5:55 4 Strings - Take Me Away 6:08 Motorcycle - As The Rush Comes The Machinist 6:21 Miss Jane - Its a fine day ATB INTRO: 50 Cent - In Da Club (Naxsy & Rolf Dyman Remix) CANCION FINAL: Sak Noel & Salvi ft. Sean Paul - Trumpets SALUDOS SUSCRIPTORES!! ---------------------------------------------------------------------------------------- | ["Electronic music", "Music", "Electronica"] | ["female singer", "fast tempo", "electronic music", "punchy", "buoyant", "youthful", "dance groove", "pulsating", "edm", "techno music", "synthesiser arrangements", "slick drumming", "digital drumming", "fast beats", "punchy", "dance groove", "club music", "dj", "dance pop", "electronica"] | 7 | oTzTZqDOIt0 | 4635 | |
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 | |
|Deep house| Cutting Shapes | A male vocalist sings this catchy song. The tempo is fast with synthesiser arrangement, punchy digital drum beats, groovy bass line and melodic vocal backup. The music has a repetitive, catchy vocal riff. It is youthful, punchy, bouncy, thumping, pulsating, and throbbing with soulful vocals and a dance groove. This music is Deep House/Techno pop. | 2014-02-20T00:28:06Z | Simon Boles | ["Disco", "Music"] | ["male singer", "fast tempo", "punchy drum beats", "digital drums", "synthesiser arrangements", "electronic effects", "reverb", "techno music", "edm", "electronica", "dance pop", "club music", "deep house", "pulsating beats", "electrifying", "youthful", "punchy", "throbbing", "buoyant", "psychedelic", "repetitive", "incessant beats", "melodious", "groovy bass lines", "ambient mixes", "atmospheric", "advanced chord structure", "soulful vocals", "unobstructive", "stimulating", "dancing"] | 7 | poxsF3-HeP0 | 4736 | ||
ANDREA (SAHARA) ft Kristali - NA EKS - produced by COSTI 2011 | A female vocalist sings this spirited pop. The tempo is medium fast with percussion accompaniment like congas, bongos and drums , tambourine beats,along with amplified flute like the Ney and rhythmic oud. The music is catchy, youthful, groovy, breezy, romantic, pleasant and spirited. This music is contemporary Folk Pop. | 2011-04-27T13:59:10Z | FORZZA MUSIC | Subscribe to my channel: https://bit.ly/ForzzaMusic Subscribe 👉https://bit.ly/2Siqg8P 🔝🎶 NA EKS - produced by COSTI COSTI Grammy Nominated Producer Billboard Hot💯🇺🇸🇷🇴 producer, songwriter, top-liner, compozitor & artist. FORTZAAAA 🔝🎶 Powered by Doctor Music® 2017 Productions & Booking : drstudio@costi.ro International PR Department : office@doctormusic.ro http://www.facebook.com/DrCosti.TheProducer http://twitter.com/CostiOfficial https://instagram.com/costiofficial/ http://www.soundcloud.com/CostiOfficial Costi (The Music Producer) - the first Romanian producer with a Grammy Nomination (Grammy Awards 2012) All rights reserved. Unauthorized reproduction is a violation of applicable laws. | ["Music of Africa", "Music"] | ["female vocalist", "medium fast tempo", "simple melody", "romantic", "breezy fresh", "pleasant", "groovy", "dance music", "dance pop", "club music", "tambourine beats", "catchy", "punchy", "perky", "amplified flute", "ney", "oud", "electronic music", "pop folk", "bulgarian", "middle eastern music", "hand percussion", "congas", "bongos", "steady drumming", "synthesiser arrangements", "amplified ney", "oud rhythm"] | 7 | tJHFSRTPyew | 5026 | |
Smack Wooo Riddim Freestyle | A male vocalist sings this energetic rap. The tempo is fast with electronic music and synthesiser arrangements with digital drum rhythm and boomy bass. The song is upbeat, energetic, buoyant, punchy and youthful with a bright dance groove. This song is an EDM/Synth pop. | 2012-02-04T03:16:37Z | ILOVEUKGRIME1 | ["Music", "Rapping"] | ["male singer", "fast tempo", "synth pop", "punchy", "atmospheric music", "vibrant", "edm", "drum machine", "synthesiser arrangements", "digital drumming", "reverb", "rhythmic patter", "vigorous rhythmic speech", "pop rap", "disco rap", "dance pop", "energetic", "enthusiastic", "punch", "youthful", "bouncy", "hip-hop", "rap", "dj", "punk rap", "club music"] | 7 | u6tgeRXOxnU | 5090 |
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;