musiccaps_details (view)
14 rows where musiccaps_aspects contains "trumpets" and musiccaps_author = 7 sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 247 ✖
- trumpets · 14 ✖
- instrumental 9
- brass band 5
- ambient 4
- fast tempo 4
- lively 4
- medium tempo 4
- slow tempo 4
- blues 3
- bongos 3
- cello 3
- groovy 3
- groovy bass lines 3
- intense 3
- pleasant 3
- soothing 3
- animated 2
- bass drum 2
- brass instruments 2
- cheerful 2
- clarinet 2
- concert 2
- dance groove 2
- electric guitar 2
- elegant 2
- enthusiastic 2
- happy 2
- improvisation 2
- jazz 2
- keyboard harmony 2
- live performance 2
- male singer 2
- orchestra 2
- peppy 2
- piano accompaniment 2
- polyrhythms 2
- rhythmic acoustic guitar 2
- saxophone 2
- slick drumming 2
- soul 2
- steady drumming 2
- swing 2
- symphony 2
- synthesiser arrangement 2
- trombone 2
- vigorous 2
- viola 2
- vivacious 2
- world music 2
- accordion harmony 1
- acoustic drums 1
- acoustic guitar 1
- african music 1
- animated piano 1
- atmospheric 1
- baarat music 1
- bachata 1
- backup vocals 1
- baroque 1
- bass 1
- bassoon 1
- beep 1
- birthday celebration 1
- birthday song 1
- boisterous 1
- boisterous unrelated 1
- buoyant 1
- burgeoning 1
- bustling music 1
- busy 1
- calm 1
- carrie an music 1
- catchy 1
- celebration 1
- celestial 1
- chain saw 1
- chaotic 1
- cheering 1
- christian praise and worship 1
- christian song 1
- christmas song 1
- clapping cheering 1
- clasical music 1
- classic 1
- clinking 1
- colourful 1
- compelling 1
- complex chords 1
- complex harmonies 1
- complex harmony 1
- conga 1
- congas 1
- congas beats 1
- contemporary christian music 1
- contemporary indian music 1
- contemporary traditional music 1
- controlled singing 1
- cymbal rides 1
- dance hits 1
- dance music 1
- deafening 1
- dholak 1
- digital drums 1
- dissonant 1
- dissonant unrelated 1
- distorted sounds 1
- drums 1
- dulcet 1
- easter song 1
- electric guitar lead 1
- electronic music 1
- electronic reggae 1
- emotional 1
- emphatic 1
- energetic 1
- engine 1
- enigmatic flutes 1
- enthralling 1
- ethereal 1
- euphonious 1
- exquisite 1
- falsetto 1
- female vocalist 1
- female voice talking 1
- flute 1
- folk music 1
- french horn 1
- funk rock 1
- funk/soul 1
- funky 1
- good friday 1
- gospel music 1
- groovy bass 1
- groovy bass line 1
- happy birthday song 1
- happy merry 1
- heavy bass line 1
- high notes 1
- high-spirited 1
- improvisations 1
- indian ceremonial band 1
- indian music 1
- indian percussions 1
- indian wedding 1
- infectious drum grooves 1
- instrumental cover 1
- jazz drumming 1
- jazz piano 1
- keyboard accompaniment 1
- latin dance music 1
- latin folk 1
- latin influence music 1
- latin song 1
- laughing 1
- lilting 1
- live orchestra 1
- lively piano 1
- lively spirited 1
- lively trumpet 1
- low audio quality 1
- male vocalist 1
- male voice talking 1
- melancholic 1
- mellow 1
- melodic 1
- mexican 1
- muddled audio 1
- multiple tracks playing 1
- music 1
- nagpada 1
- neo soul 1
- noisy 1
- north indian wedding music 1
- orchestral music 1
- party song 1
- people talking 1
- percussions 1
- perky 1
- piano 1
- pop rock 1
- powerful vocals 1
- psychedelic 1
- punchy 1
- r&b 1
- rapid changes in pitch 1
- reggae 1
- reggae tones 1
- rhythmic 1
- rhythmic acousitc guitar 1
- rhythmic counter play 1
- rich 1
- rock 1
- romantic 1
- running 1
- salsa 1
- salsa music 1
- saxophone accompaniment 1
- scuffling 1
- sentimental 1
- sere 1
- shakers 1
- sighing 1
- simple 1
- snare drums 1
- soft 1
- soft rock 1
- spanish 1
- spirited paino 1
- stage performance 1
- steady beat 1
- steel pan 1
- string instruments 1
- super imposing background 1
- superimposed speech 1
- superimposed tracks 1
- synced harmonies 1
- syncopated 1
- syncopated bass lines 1
- syncopated harmony 1
- syncopated melody 1
- syncopated music 1
- synth arrangements 1
- tambourine 1
- tapping sound 1
- telephone busy signal 1
- the lord’s prayer 1
- triumphant 1
- trombone harmony 1
- tuba accompaniment 1
- unpleasant 1
- upbeat 1
- vibrant vocals 1
- vigorous drumming 1
- violin 1
- violin plucking rhythm 1
- violin symphony 1
- violins 1
- vivid 1
- vocal backup 1
- vocalisation 1
- vocalising 1
- western classic 1
- wind instrument 1
- wind instruments 1
- xylophone 1
- yodelling 1
- youthful 1
musiccaps_names (array) 21 ✖
- Music 10
- Brass instrument 3
- Salsa music 2
- Ska 2
- Swing music 2
- Blues 1
- Chainsaw 1
- Clarinet 1
- French horn 1
- Music of Latin America 1
- Opera 1
- Reggae 1
- Roll 1
- Saxophone 1
- Sigh 1
- Singing 1
- Song 1
- Soul music 1
- Timpani 1
- Trombone 1
- Yodeling 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Tedeschi Trucks Band - Midnight in Harlem (Live from Atlanta) | This music is a melodic instrumental. The tempo is medium with a captivating electric guitar lead, rhythmic acoustic guitar, funky bass line, keyboard accompaniment, steady drumming and trumpets. The music is soothing, atmospheric, euphonious, youthful, and soulful. This instrumental is a Soft Rock/Funk pop. | 2011-08-18T07:00:00Z | TedeschiTrucksVEVO | Music video by Tedeschi Trucks Band performing Midnight in Harlem (Live from Atlanta). (C) 2011 Sony Music Entertainment | ["Blues"] | ["instrumental", "medium tempo", "electric guitar lead", "ambient", "steady drumming", "groovy bass line", "trumpets", "melodic", "pleasant", "funky", "groovy", "soft rock", "pop rock", "funk rock", "youthful", "atmospheric", "brass band", "soul", "neo soul", "soothing", "rhythmic acoustic guitar"] | 7 | -wVWjl9Kq6U | 104 | |
HONK - Hesitation | This music is instrumental. The tempo is fast with trumpet harmony, keyboard accompaniment, infectious drumming, syncopated, funky bass lines, lively piano and electric and acoustic guitar riffs. The music is upbeat, groovy, complex harmony, ambient, soulful and funky. This song is Funk Soul; | 2010-05-19T16:30:27Z | 123c123c123c | Honk - Honk LP :: 1974 | ["Swing music", "Music", "Soul music"] | ["instrumental", "fast tempo", "rock", "blues", "trumpets", "lively spirited", "complex harmony", "complex chords", "cymbal rides", "dance groove", "peppy", "perky", "vivacious", "keyboard harmony", "piano accompaniment", "groovy bass lines", "acoustic guitar", "electric guitar", "slick drumming", "trumpets", "lively", "ambient", "soothing", "improvisation", "soul", "funk/soul", "rhythmic", "dance groove", "syncopated bass lines", "rhythmic counter play", "infectious drum grooves"] | 7 | 2sIfE3KOi5s | 410 | |
Band Baaja Baaraat | Title Song | Ranveer Singh | Anushka Sharma | Salim Merchant | Shraddha Pandit | This song is a lively Indian instrumental. The tempo is fast with lively brass bands playing harmony, energetic drums ,Nagpada and dhol and other Indian percussion and synthesiser with digital arrangements. There is a dialogue of a man and woman superimposed over the music, with sighing and giggling in the background. The music is typical Indian Baarat music. It is happy, cheerful, vivacious, energetic, youthful, vigorous and upbeat. | 2012-01-20T12:10:46Z | YRF | Get into the celebratory mode with the high on energy title track of ‘Band Baaja Baaraat’. ► Subscribe Now: https://goo.gl/xs3mrY 🔔 Stay updated! ► YRF New Releases: https://www.youtube.com/playlist?list=PLCB05E03DA939D484 🎧 Song Credits: Song: Band Baaja Baaraat - Title Song Singers: Salim Merchant, Shraddha Pandit Music: Salim-Sulaiman Lyrics: Amitabh Bhattacharya Stay in the filmy loop: ► Like us on Facebook: Facebook/yrf ► Follow us on Twitter: Twitter/yrf ► Follow us on Instagram: Instagram/yrf ► Visit us on: yashrajfilms.com 🎬 Movie Credits: Movie: Band Baaja Baaraat Starring: Ranveer Singh, Anushka Sharma Director: Maneesh Sharma Producer: Aditya Chopra Music: Salim-Sulaiman Lyrics: Amitabh Bhattacharya Director of Photography: Aseem Mishra Release Date: 10 December 2010 Watch all videos from the film ‘Band Baaja Baaraat’: https://www.youtube.com/watch?v=k67ErU7SeIE&list=PL3137530AC0F0E2FC&index=2&t=0s Synopsis: Shruti (Anushka Sharma) is a 20-something no-nonsense girl from a middle class Delhi household. Focused and determined with preplanned ambitions, her goals in life are well laid out by the time she reaches her final year of college. Bittoo (Ranveer Singh), on the other hand, has no real aim in life. As a final year college student of Delhi University, he whiles away his life having fun with his buddies, barely scraping through his exams. A chance and inopportune meeting (or as you would call it, fate) brings the two of them together on a tumultuous journey where they become partners in their very own, “Wedding planning ka bijness”. The rules however, are clear: “Jisse vyapaar karo, usse kabhi na pyaar karo” (Don’t mix business with pleasure). Together, their friendship and business, enters the ups and downs of the lavish Delhi weddings. And while trying to find themselves, Shruti and Bittoo discover each other and realize that in the course of their journey, unke khud ke rules ki bajegi band. #YRFnewreleases #BandBaajaBaaraat #YRF #YRF50 #Yashraj #YashrajFilms #YRFmovies #YRFmusic #Yash… | ["Music", "Sigh"] | ["instrumental", "trumpets", "brass band", "brass band", "energetic", "lively", "enthusiastic", "vigorous", "peppy", "buoyant", "digital drums", "indian percussions", "drums", "nagpada", "lively trumpet", "dholak", "indian music", "indian wedding", "contemporary indian music", "digital drums", "electronic music", "synth arrangements", "male voice talking", "female voice talking", "sighing", "laughing", "vocalising", "superimposed speech", "baarat music", "indian wedding", "north indian wedding music", "indian ceremonial band"] | 7 | 3kXukXBvDQQ | 496 | |
Thorns in the Straw | This song is an instrumental interlude of the Gospel song ‘Thorns in the Straw. The music is slow with a melancholic trombone and tuba harmony, acoustic guitar accompaniment , bass, steady drumming,and synthesiser arrangements. The music is soft, mellow, poignant,pensive, sentimental,emotional, reflective and serene. This song is a Gospel Instrumental. | 2008-12-22T00:26:42Z | Mike Rutter | A video using 'Thorns in the Straw' by Graham Kendrick | ["Brass instrument", "French horn"] | ["instrumental", "slow tempo", "rhythmic acoustic guitar", "trumpets", "trombone harmony", "tuba accompaniment", "bass", "piano accompaniment", "synthesiser arrangement", "soft", "mellow", "gospel music", "instrumental cover", "christian song", "christian praise and worship", "easter song", "good friday", "christmas song", "contemporary christian music", "mellow", "dulcet", "euphonious", "sentimental", "sere", "calm", "soothing", "emotional"] | 7 | 7OjXHfVoI64 | 843 | |
Chainsaw art time lapse | This is a multi track audio. There are several things happening. There’s an energetic song in the background with enthusiastic vocals, drumming and trumpets. There’s a loud whirring of an engine, like a chain saw, beeps and a phone dial tone. The audio is loud, confusing, chaotic, boisterous,unrelated , noisy, loud, dissonant and unpleasant. | 2008-06-17T18:46:38Z | dtremko | Four days of carving in 2 minutes | ["Chainsaw", "Music", "Roll"] | ["instrumental", "fast tempo", "engine", "vigorous", "dissonant", "unpleasant", "superimposed tracks", "distorted sounds", "dissonant unrelated", "boisterous", "noisy", "chain saw", "music", "beep", "telephone busy signal", "running", "multiple tracks playing", "trumpets", "noisy", "chaotic", "boisterous unrelated", "deafening", "unpleasant"] | 7 | 7TmKzUgWiRU | 848 | |
Nane Tsora | This music is a western classical. The tempo is slow with violins, trumpets, flute, cello. Viola, bassoon harmony. The music is soft, mellow, mellifluous, rich, elegant and exquisite. This is a live performance/concert. | 2007-05-23T12:20:55Z | ErnestNBE | Gipsy tradtional played by the NBE (www.nbe.nl) in the 2005 New Year's Concert in the Concertgebouw Amsterdam. Soloist on bass trombone is Brandt Attema. | ["Brass instrument", "Clarinet", "Trombone"] | ["instrumental", "slow tempo", "orchestra", "rich", "elegant", "exquisite", "compelling", "concert", "piano", "flute", "live performance", "live orchestra", "symphony", "rich", "melancholic", "trumpets", "violin", "cello", "clarinet", "bassoon", "french horn", "baroque", "intense", "western classic", "clasical music"] | 7 | 8y36aT4C_c0 | 961 | |
Straighten up and Fly Right-SWING SUPREME | A male vocalist sings this mellow jazz song. The tempo is medium with a spirited saxophone accompaniment, jazzy piano, groovy bass lines, slick drumming and trumpet . The song is melodic, catchy, ambient, romantic, groovy, light and breezy with a swing rhythm. This song is a lively Jazz song. | 2008-11-13T17:49:53Z | Ian Boyter | A swing standard recorded by the Edinburgh Band Swing Supreme. www.swingsupreme.co.uk | ["Swing music", "Music", "Song"] | ["male singer", "medium tempo", "jazz piano", "trumpets", "romantic", "pleasant", "saxophone accompaniment", "wind instruments", "brass instruments", "slick drumming", "groovy bass lines", "animated piano", "swing", "jazz", "blues", "ambient", "pleasant", "syncopated harmony", "improvisations"] | 7 | CphwhKgYHaM | 1405 | |
HAPPY BIRTHDAY SONG - FELIZ CUMPLEAñOS SALSA MUSIC | A male vocalist sings this cheerful classic Happy Birthday song. The tempo is fast and high spirited with animated trumpets, enthusiastic, syncopated piano accompaniment, energetic congas and bongos beats, spirited drumming, tambourine beats and vocal backup. The music is loud, bustling, hyper, high-energy and a little bit syncopated. It is fun, cheerful, celebratory and happy. | 2009-05-30T03:41:52Z | EL BAILADOR | Happy birthday song- Feliz cumpleaños salsa music . Feliz cumpleaños para la persona especial que tu eres. "Happy Birthday to You", also known more simply as "Happy Birthday", is a traditional song that is sung to celebrate the anniversary of a person's birth. According to the 1998 Guinness Book of World Records, "Happy Birthday to You" is the most well recognized song in the English language, followed by "For He's a Jolly Good Fellow" and "Auld Lang Syne". The song's base lyrics have been translated into at least 18 languages. | ["Music", "Salsa music"] | ["instrumental", "fast tempo", "animated", "trumpets", "classic", "backup vocals", "xylophone", "happy birthday song", "birthday song", "celebration", "birthday celebration", "birthday song", "congas beats", "bongos", "keyboard harmony", "vigorous drumming", "syncopated music", "spirited paino", "latin influence music", "salsa music", "busy", "bustling music", "happy", "cheerful", "enthusiastic"] | 7 | Vx4aO4-nr0c | 3045 | |
Israel Vibration African Unification | A male vocalist sings the Lord’s Prayer. The tempo is medium with Keyboard harmony, steady drumming, groovy basslines, rhythmic guitar,beat of shakers, vocal backup and a trumpet flourish. The music is simple, rhythmic, pleasant, catchy, soulful and punchy Reggae. There are sounds of people clapping and cheering in the background indicating that this is a live performance. | 2007-02-25T01:52:21Z | David Ruiz | Israel Vibration African Unification | ["Music", "Reggae", "Ska"] | ["male singer", "medium tempo", "reggae", "live performance", "stage performance", "concert", "rhythmic acousitc guitar", "clapping cheering", "vocal backup", "shakers", "pleasant", "punchy", "groovy", "happy", "simple", "pleasant", "reggae tones", "groovy bass lines", "trumpets", "brass band", "shakers", "steady drumming", "keyboard accompaniment", "the lord’s prayer", "carrie an music", "african music", "r&b", "world music", "catchy"] | 7 | blsYgo-B1k8 | 3650 | |
Mary Schneider - Yodelling Overtures | A female vocalist sings this lilting melody. The tempo is slow with the vocalist yodelling to the accompaniment of a violin symphony and brass band . The cello and plucking of violin strings adds a dense bass layer and the subtle flutes and trumpets harmony compliment the vocals. The effect is ethereal, celestial, enthralling, enigmatic, melodic and beautiful. | 2011-01-09T14:02:20Z | German Music Channel | The Australian Queen Of Yodelling! 1. Wilhelm Tell 2. Carmen 3. Can Can Winterfest der Volksmusik 2000 | ["Yodeling", "Music", "Opera"] | ["female vocalist", "slow tempo", "enthralling", "celestial", "enigmatic flutes", "trumpets", "viola", "clarinet", "vocalisation", "yodelling", "high notes", "controlled singing", "violin symphony", "brass band", "string instruments", "wind instrument", "violin plucking rhythm", "vibrant vocals", "powerful vocals", "lilting", "ethereal", "rapid changes in pitch", "falsetto"] | 7 | i_G_0vgEYJg | 4199 | |
Ondatrópica - Punkero Sonidero | This music is an upbeat instrumental. The tempo is fast with a plethora of instruments like trumpets, congas, bongos, steel drum, accordion,saxophone, keyboard,and electric guitar. The music is perky, buoyant, high spirited, enthusiastic, energetic with complex harmonies. This music is a contemporary take in Traditional Latin folk music. | 2012-06-29T08:59:31Z | Soundway Records | Artist: Ondatrópica Title: Punkero Sonidero Album: Punkero Sonidero Conceived by Colombian musician Mario Galeano, the force behind the band Frente Cumbiero, and English producer Will 'Quantic' Holland, Ondatrópica brings together an all-star cast representing both the classic and modern styles of la musica Colombiana. Label Website: http://www.soundwayrecords.com https://www.facebook.com/SoundwayRecords http://soundcloud.com/soundway-records https://twitter.com/#!/soundway Click here to subscribe to Soundway Records - http://www.bit.ly/sub2soundway MUSIC FROM PLANET EARTH: PAST, PRESENT & FUTURE Soundway Records was conceived in 2002 by label owner Miles Cleret whilst returning from Ghana with a hoard of dusty old 45s and LPs that had mostly not been heard outside the former Gold Coast since their original release. Planned on a whim the trip was not one of the carefully planned research expeditions that Miles would later embark on to any number of far-flung tropical destinations. On the contrary he left England with no idea of what he might find or that it might be the start of a career in the record business. Although the label has it's roots in West Africa the scope has grown to include many other parts of the tropical belt with the aim of making available recordings that have in most cases never been available outside of their original countries and often not even there for over 30 years. Over the years Soundway's modus operandi has been to approach the music from a different angle from many of the more established "World Music" labels. By focusing on more obscure artists as well as big names and often concentrating on progressive recordings more in sync with Cleret's generation and background in DJ culture and dance-music. Styles have included afro-beat, funk, highlife, ethio-jazz, molam, calypso, cumbia, champeta, biguine, latin-jazz and disco as well as many unclassifiable recordings. Since 2012 Soundway has begun releasing new material from a carefully selected handful of contemporary recording … | ["Music", "Ska"] | ["instrumental", "fast tempo", "trumpets", "complex harmonies", "syncopated", "electronic reggae", "synthesiser arrangement", "folk music", "latin folk", "world music", "accordion harmony", "psychedelic", "party song", "dance groove", "contemporary traditional music", "trombone", "conga", "bongos", "steel pan", "saxophone", "electric guitar", "groovy bass", "upbeat", "cheerful", "happy merry", "polyrhythms", "animated", "high-spirited", "lively", "colourful", "vivid", "vivacious"] | 7 | mcAsO331Z9s | 4482 | |
Thats All Me Bro! | This music is a Jazz instrumental. The tempo is slow with emphatic brass and wind instrumentation, with cello and jazz drumming. The trumpets are emphatic with a lively trombone riff. The other instruments add a rich, dense layer to the music. It is intense, complex, ambient, groovy and pleasant. This music is a Jazz instrumental.5. | 2014-10-25T07:37:25Z | CharlesAlatorre | VLOG CHANNEL: https://www.youtube.com/user/CharlesAlatorre2 Christina (Girl In the Video): https://twitter.com/xtinnnnna http://instagram.com/xtinnnnna Travis's Channel: https://www.youtube.com/user/TravieBASED TWITTER: http://twitter.com/CharlesAlatorre INSTAGRAM: CharlesAlatorre LIKE MY FACEBOOK PAGE: http://www.facebook.com/CharlesAlatorreTV FACEBOOK: http://www.facebook.com/CharlesAlatorre Royalty Free Music By: http://www.audiomicro.com/royalty-free-music | ["Brass instrument", "Saxophone"] | ["instrumental", "slow tempo", "trumpets", "saxophone", "emphatic", "groovy", "ambient", "jazz", "intense", "elegant", "jazz drumming", "lively", "polyrhythms", "blues", "swing", "bass drum", "trombone", "cello", "heavy bass line", "syncopated melody", "improvisation"] | 7 | p1-07VdP__Q | 4676 | |
Palladium Salsa Social | 13 Marzo | Music by Dj Rumbero | A male vocalist sings this peppy Latin pop song.the tempo is medium with animated trumpets, keyboard harmony and percussions rhythms of bongos, congas and subtle drums. The song is muffled and there are sounds in the background of people talking, cheering, the sound of clinking, scuffling and tapping. The song is super imposed by the background sounds. This song is a latin pop song. | 2015-03-14T07:40:22Z | Jorge Rodriguez | Palladium Salsa Social music by Dj Rumbero a través de YouTube Capture | ["Singing", "Music", "Music of Latin America", "Salsa music"] | ["male vocalist", "medium tempo", "latin song", "super imposing background", "mexican", "cheering", "dance music", "latin dance music", "dance hits", "spanish", "dance music", "congas", "bongos", "trumpets", "steady beat", "salsa", "bachata", "people talking", "clinking", "tapping sound", "scuffling", "low audio quality", "muddled audio"] | 7 | sOyHkcK_lOA | 4947 | |
Mark Mothersbaugh - Ping Island / Lightning Strike Rescue Op | This song is an instrumental. The tempo is medium with lively trumpets, trombone ,enthusiastic percussion like the snare, cymbals and bass drum, tambourine , an intense and bright string harmony of violins, viola and cello. The music is intense, serious and is gradually building up. This is an Orchestral piece. | 2007-12-02T16:36:53Z | Evil Chicken MEDIA | The Life Aquatic with Steve Zissou-theme. On of the greatest movies ever made. If you havn't seen it; Go play with Barbie-dolls. | ["Timpani", "Music"] | ["snare drums", "trumpets", "violins", "triumphant", "acoustic drums", "tambourine", "orchestral music", "intense", "burgeoning", "synced harmonies", "bass drum", "viola", "cello", "brass band", "orchestra", "symphony", "brass instruments", "percussions", "lively piano"] | 7 | vOAXAoHtl7o | 5178 |
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;