musiccaps_details (view)
17 rows where musiccaps_aspects contains "jazz" and musiccaps_author = 9
This data as json, CSV (advanced)
musiccaps_aspects (array) 80 ✖
- jazz · 17 ✖
- acoustic drums 11
- instrumental 10
- no singer 7
- piano 7
- upright bass 7
- bass guitar 6
- saxophone 6
- electric guitar 5
- lively 4
- acoustic jazz drums 3
- complex 3
- groovy 3
- improvisation 3
- jam 3
- live performance 3
- playful 3
- trumpet 3
- big band 2
- cheerful 2
- chill 2
- clarinet 2
- gentle 2
- keyboard 2
- mellow 2
- reggae 2
- soft 2
- tranquil 2
- upbeat 2
- vibraphone 2
- background music 1
- backing track 1
- bossa nova 1
- brass 1
- brass section 1
- brushes 1
- calm 1
- calming 1
- charleston dance 1
- chewing 1
- cinematic 1
- concert 1
- dreamy 1
- dub 1
- epic 1
- explosions 1
- flute 1
- gibberish singing 1
- guitar solo 1
- jazz fusion 1
- jovial 1
- light-hearted 1
- male vocal 1
- melancholic 1
- movie music 1
- organ 1
- package opening 1
- piano sound 1
- relaxing 1
- restless 1
- saxophone solo 1
- sensual 1
- single instrument 1
- slow tempo 1
- sophisticated 1
- sound effects 1
- squeaking 1
- swing 1
- synth bass 1
- theme music 1
- toy review 1
- trippy 1
- trombone 1
- tropical 1
- trumpet solo 1
- tuba 1
- vibrant 1
- video game theme 1
- winds section 1
- xylophone 1
musiccaps_names (array) 28 ✖
- Music 8
- Brass instrument 7
- Jazz 5
- Saxophone 4
- Trumpet 3
- Guitar 2
- Musical instrument 2
- Plucked string instrument 2
- Swing music 2
- Trombone 2
- Wind instrument, woodwind instrument 2
- Acoustic guitar 1
- Blues 1
- Clarinet 1
- Distortion 1
- Effects unit 1
- Electric guitar 1
- Keyboard (musical) 1
- Lullaby 1
- Oink 1
- Piano 1
- Reggae 1
- Roll 1
- Ska 1
- Soul music 1
- Strum 1
- Synthesizer 1
- Tender music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Relaxing Jazz Music | This is a jazz music piece with a saxophone solo as the lead. There is a clean-toned synth bass in the background creating an epic atmosphere. It would fit perfectly in a movie/TV show setting as a soundtrack opening. | 2012-02-01T16:01:47Z | xmattzax | Cowboy Bebop OST - Space Lion 0:00 Cowboy Bebop OST/Blue - Farewell Blues 7:11 Cowboy Bebop OST/Blue - Road to the West 12:41 Fly Me to the Moon - Jazz Piano 15:36 Cowboy Bebop OST - Goodnight Julia 18:00 Serenade - Blue [Chrono Trigger - Corridor of Time] - Nostalgic Melodies 19:54 Smooth Jazz Music Track 24:09 Tengen Toppa Gurren Lagann OST - Elegy for Kamina's Father Who Became a Skeleton 29:54 The Seatbelts - Adieu 33:05 The Seatbelts - Waste Land 39:18 Turnabout Jazz Soul - Track 8 - Godot - The Fragrance of Dark Coffee 41:09 New version without the fireplace sounds, by request. Enjoy. If you like video game videos (Gameplays, Let's Plays), check out my other channel at https://www.youtube.com/user/MattCenterCX | ["Jazz", "Music", "Tender music"] | ["saxophone", "synth bass", "cinematic", "jazz", "epic", "movie music"] | 9 | 26IOFykrJrc | 333 | |
Fly Me To The Moon Jazz Backing Track | This is an instrumental backing track of a jazz music piece. There is no singer in this version of the piece. The piano is playing the chords in the minor key while a bass guitar can be heard playing a walking bass line. The rhythmic background consists of acoustic drums playing a jazz swing beat. The atmosphere is delicate. This piece could be playing in the background at a coffee shop. It could be used in the soundtrack of a romantic movie. | 2009-08-13T06:58:18Z | gamerohan | This is a Fly Me To The Moon backing track (C MAJOR) Chords as followed | Am7 | Dm7 | G7 | CM7 | FM7 | Bm7b5 | E7b9 | | Am7 | Dm7 | G9 | CM9 | Am7 | Dm7 | G7 | CM7 | Bm7, E7 | | Am7 | Dm7 | G7 | CM7 | FM7 | B half dim. | E7 b9 | | Am7 | Dm7 | G9 | First Ending | Em7b5 | A7b9 | Dm7 | Dm7/G | C6 | Bm7, E7 | | Am7 | Dm7 | G7 | CM7 | FM7 | Bm7b5 | E7b9 | | Am7 | Dm7 | G9 | CM9 | Am7 | Dm7 | G7 | CM7 | Bm7, E7 | | Am7 | Dm7 | G7 | CM7 | FM7 | B half dim. | E7 b9 | | Am7 | Dm7 | G9 | Second Ending : | Em7b5 | A7b9 | Dm7 | G7 | C6 | C6 || Instruments: Bass Piano Drums Bass and Piano recorded by me , drums - garageband loop MIcrophones Used : Rode M3 Rode NT1-A | ["Jazz", "Music"] | ["jazz", "no singer", "instrumental", "backing track", "piano", "bass guitar", "acoustic jazz drums", "mellow", "soft", "swing", "light-hearted"] | 9 | 3TQmts_MxyQ | 471 | |
Billie Holiday & Her Orchestra - Sophisticated Lady (Verve Records 1956) | This is a jazz music piece. There is a saxophone playing a solo in the lead. A tuba is playing the bass line. There is an electric guitar strumming chords. The rhythm is being played on the ride cymbal by the acoustic drums. The instrumentals have a sophisticated feel. This piece could be playing in the background at a classy restaurant. | 2011-01-02T10:43:06Z | RoundMidnightTV | "Sophisticated Lady" is a jazz standard, composed as an instrumental in 1932 by Duke Ellington and Irving Mills, to which words were added by Mitchell Parish. The words met with approval from Ellington, who described them as "wonderful — but not entirely fitted to my original conception." That original conception was inspired by three of Ellington's grade school teachers. "They taught all winter and toured Europe in the summer. To me that spelled sophistication." Billie's accompanied by Joe Mondragon (bass), Alvin Stoller (drums), Barney Kessel (guitar), Jimmy Rowles (piano), Harry "Sweets" Edison (trumpet), and Ben Webster (Tenor Saxophone). Recorded August 18, 1956, Los Angeles. (Verve Records) They say into your early life romance came And then this heart of yours burned a flame A flame that flickered one day and died away Then with disillusion deep in your eyes You learned that fools in love soon grow wise The years have changed you somehow I see you now Smoking, drinking, never thinking Of tomorrow, nonchalant Diamonds shining, dancing, dining With some man in a restaurant Is that all you really want? No, sophisticated lady I know, you miss the love you lost long ago And when nobody is nigh [near] you cry Smoking, drinking, never thinking Of tomorrow, nonchalant Diamonds shining, dancing, dining With some man in a restaurant Is that all you really want? No, sophisticated lady I know, you miss the love you lost long ago And when nobody is nigh [near] you cry Sophisticated lady you cry | ["Brass instrument", "Saxophone"] | ["jazz", "tuba", "saxophone", "electric guitar", "acoustic drums", "melancholic", "sophisticated"] | 9 | 5r4jLwjj_Ik | 698 | |
Meschiya Lake and the Little Big Horns-Luck Devil | This is a jazz music piece. There is a saxophone playing a jazzy solo for the melody. There is an upright bass playing in the background. The rhythmic background consists of a slow tempo acoustic drum beat that is played with brushes. The atmosphere is mellow. This piece could be playing in the background of a classy restaurant or a coffee shop. | 2011-03-06T05:41:05Z | raystewification | The Title Track from "Lucky Devil" Duplicated because youtube sucks. | ["Brass instrument", "Saxophone", "Wind instrument, woodwind instrument"] | ["jazz", "instrumental", "saxophone", "upright bass", "acoustic drums", "brushes", "mellow", "gentle", "slow tempo"] | 9 | 9UCLvFqkFxk | 1012 | |
David Byrd - HD Live! (Tropical Addiction Series 2012) Chicago Reggae Channel | This is the recording of a jazz reggae concert. There is a saxophone lead playing a solo. There is a keyboard and an electric guitar playing the main tune with the backing of a bass guitar. In the rhythmic background, there is an acoustic reggae drum beat. The atmosphere is groovy and chill. This piece could be playing in the background at a beach. It could also be included in the soundtrack of a summer/vacation/tropical themed movie. | 2012-08-16T15:30:54Z | Whitelion Promotio | http://chicagoreggaechannel.com presents: Tropical Addiction Series 2012 - Reggae At The Dock Produced by WhiteLion Promotion, Hosted by Madhatter Promotions August 1st, 2012 | ["Blues", "Effects unit", "Electric guitar", "Guitar", "Music", "Reggae", "Plucked string instrument", "Distortion"] | ["jazz", "reggae", "live performance", "concert", "saxophone", "keyboard", "electric guitar", "bass guitar", "acoustic drums", "groovy", "relaxing", "calm", "chill", "tropical", "jam"] | 9 | ALVS3Q_jNaU | 1108 | |
Blue Bossa - Achim Kohl - Jazz Guitar Improvisation with Tabs | This is an instrumental jazz improvisation piece with heavy bossa nova influences. There is an over-arching bossa nova syncopation not only being played by the acoustic drums in the backing track but also followed by the electric rhythm guitar and the bass guitar. The lead is a guitar solo being played by a gentle sounding electric guitar. Although there are complex chords and riffs, the general atmosphere is tranquil. This piece could be playing in the background of a restaurant. It could also be included in the soundtrack of a movie during serene scenery. | 2013-03-11T13:08:58Z | Achim Kohl | played with my Gibson ES 137 Custom, If you want to play a transcription of this solo, go to https://www.klangfarbe-noten-shop.de/en/blue-bossa-solo.html | ["Guitar", "Jazz", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["jam", "jazz", "bossa nova", "no singer", "instrumental", "electric guitar", "guitar solo", "bass guitar", "acoustic drums", "soft", "sensual", "tranquil"] | 9 | AgtY6m-b3Gk | 1155 | |
SkylanderDude VS the big green fat pig angry birds space | This is a jazz piece played in the background of a video game. A trumpet plays the main melody while a xylophone and a bass guitar is supporting the tune in the background. A playful jazz drum beat carries the rhythmic background. Occasional electric guitar fills in the form a strum can be heard. There are a lot of sound effects related to the game such as squeaking, chewing and explosions. | 2012-07-30T19:33:03Z | SkylanderDudeFilms | ewww. over cooked popcorn | ["Music", "Oink"] | ["jazz", "trumpet", "acoustic drums", "xylophone", "electric guitar", "bass guitar", "sound effects", "squeaking", "chewing", "explosions", "playful", "jovial"] | 9 | BkOfrw3c3EE | 1284 | |
Joey DeFrancesco & George Coleman - Ceora | This is the live performance of a jazz music piece. There is an organ playing the chords in the background. There is a complex and improvised saxophone solo in the lead. The acoustic drums are playing a mellow jazz beat. The atmosphere is rather tranquil. This piece could be playing in the background at a coffee shop or a classy restaurant. | 2011-02-05T19:16:50Z | Peter W. Bosse | Joey DeFrancesco (Hammond B-3 organ) George Coleman (saxophone) Jake Langley (guitar) Byron Landham (drums). rec. 2006 | ["Brass instrument", "Saxophone"] | ["jazz", "live performance", "no singer", "instrumental", "organ", "saxophone solo", "bass guitar", "acoustic drums", "tranquil", "complex", "improvisation"] | 9 | CYuYfvQv4eo | 1376 | |
A Griffon Day | This is a big band jazz music piece. It is an instrumental piece. The main melody is played by a wide variety of the winds section composed of the saxophone, the trumpet, the flute and the clarinet. The piano and the upright bass provide backing structures. The rhythmic background consists of a jazz acoustic drum beat. The atmosphere is playful. This piece could fit perfectly in the soundtrack of a Disney-type animation movie. | 2008-01-27T00:18:25Z | George Pfeiffer | Gus the Brussels Griffon documents a typical day in his life. If you like dogs...or monkeys...or Ewoks....then you'll love this little pooch! | ["Swing music", "Jazz", "Music"] | ["jazz", "big band", "instrumental", "winds section", "saxophone", "trumpet", "flute", "clarinet", "upright bass", "piano", "acoustic drums", "lively", "playful", "upbeat"] | 9 | JU6GUqRqbtI | 2011 | |
Nord Stage 2 - Demo (Full version) | This is the recording of a jazz improvisation performance. It is in an instrumental piece performed with a keyboard that utilizes a classical piano sound. The chords are being played gently which creates a calming atmosphere. Due to various chords and lines being played in this performance, parts of it could be lifted to be used as piano samples for a beat. It could also be playing in the background of a restaurant or a jazz bar. | 2011-06-29T11:02:48Z | nordkeyboards | Demonstration of Nord's new flagship keyboard, the Nord Stage 2. Read more about the Nord Stage 2 here: bitly.com/nordstage2 Music and performance: Federico Solazzo Thanks to our Italian distributor Mogar for creating the video! | ["Music", "Musical instrument", "Keyboard (musical)", "Piano", "Lullaby", "Synthesizer"] | ["jazz", "improvisation", "no singer", "instrumental", "single instrument", "jam", "keyboard", "piano sound", "gentle", "calming"] | 9 | M4rXhyyvERM | 2240 | |
Katamari Roll (you up into my life) | This is a video game theme in the style of jazz music. There is a male vocalist singing gibberish while imitating a brass instrument. The vibraphone is playing the main melody. There is a piano playing chords in a syncopated manner. The bass guitar is playing a groovy bass line. The rhythmic background consists of an acoustic jazz drum beat. The atmosphere is dreamy and cheerful. This piece could be playing in the soundtrack of an animation movie during a dream sequence. | 2008-11-26T21:49:26Z | leftofftheark | I know you love me I want to wad you up into my life Lets roll up to be a single star in the sky I hear you calling me I want to wad you up into my life Lets lump up to make a single star in the sky To you, to you Im so in love with you I want to wad you up into my life Lets roll up to be a single star in the sky I need you to feel me I want to wad you up into my life Lets lump up to make a single star in the sky To you I know you love me I want to wad you up into my life Lets roll up to be a single star in the sky I hear you calling me I want to wad you up into my life Lets lump up to make a single star in the sky To you, oh to you Yes to you | ["Music", "Roll", "Soul music"] | ["video game theme", "jazz", "male vocal", "gibberish singing", "vibraphone", "piano", "upright bass", "acoustic jazz drums", "dreamy", "complex", "cheerful"] | 9 | Mv90uA0tmgc | 2307 | |
Fat Freddy's Drop Blackbird Album Bones | This is a dub/jazz music piece. There is an electric guitar playing the main melody while a fat bass guitar is supporting it in the background. The rhythm is being played by a laid-back acoustic drum beat. The atmosphere is chill and trippy. This piece could be playing in the background at a dance club for a slow dance night. It could also be used in the soundtrack of a romance movie that takes place in the city, especially during intimate scenes. | 2013-10-22T10:00:01Z | Fat Freddy's Drop | Fat Freddy's Drop -- Bones Subscribe now to Fat Freddy's Drop TV - http://bit.ly/Subscribe2FatFreddysDropTV Taken from the album Blackbird released June 2013. Buy the album here - http://smarturl.it/1uy8fl Freddy HQ - http://www.fatfreddysdrop.com ---------------------------- Follow Freddy's at: https://www.facebook.com/fatfreddysdropnz https://www.instagram.com/fatfreddysdropnz https://twitter.com/fatfreddysdrop1 Upcoming Tours: https://tinyurl.com/ydgo2j9w http://fatfreddysdrop.com/gig-guide Merch: https://tinyurl.com/y84dv3ow ---------------------------- | ["Jazz"] | ["dub", "jazz", "reggae", "electric guitar", "bass guitar", "acoustic drums", "chill", "groovy", "trippy"] | 9 | OeNTAUKZgKs | 2454 | |
数字変形 Numbers transform to vehicles for kids | This is a toy package opening video with a jazz music piece in the background. In the piece, there is a clarinet playing the leading melody while other brass elements, the piano and the upright bass are accompanying it with backing tunes. The rhythm is being played by the upbeat jazz acoustic drums. The atmosphere of the piece is lively. If the package opening sounds could be removed, the piece would suit well in the soundtrack of a feelgood animation movie. | 2015-10-11T07:57:43Z | Talking Toyss | This video shows how Numbers transform to vehicles. The number includes 1,2,3. Hope you enjoy our video, pls subscribe, leave comments and check out TalkingToyss channel! learn to count numbers 1 to 10 for kids with street vechicles tomica and tomica factory https://www.youtube.com/watch?v=0ajlonqR7VY Choro-Q TRANSFORMERS チョロQ・トランスフォーマー for kids with Q Transformer and Hello Kitty cross over https://www.youtube.com/watch?v=1zDtV3Og5xY Learning Street Vehicles Names and Sounds for kids with tomica tayo robocar Poli https://www.youtube.com/watch?v=cFeJ-ORLYpI VooV ブーブ 変身 Transform street vehicles for kids with Trains https://www.youtube.com/watch?v=jfpBPYrCRrA VooV ブーブ 変身 Transform street vehicles for kids with Cars and Trucks 2 https://www.youtube.com/watch?v=OkVB75ZnwVw Learning street vehicle name with Roboca Poli English https://www.youtube.com/watch?v=99LFSxjHYbI VooV ブーブ 変身 Transform street vehicles for kids with Cars and Trucks https://www.youtube.com/watch?v=OrAW8wNYuas Vintage Lego 10196 Grand Carousel in white with sound and motor spin https://www.youtube.com/watch?v=rQ5-ycJZkyk Minions Stuart banana toys for minions movie 2015 with Sounds and Flash https://www.youtube.com/watch?v=H70IwYW9q2I Super Mario World Toys Collection unboxing https://www.youtube.com/watch?v=sFtsQvGhzJw 5 Kinder Surprise Eggs Airbus A330-300 Airplane collection https://www.youtube.com/watch?v=pZSbivWZqcw Play Doh meal makin kitchen Playset https://www.youtube.com/watch?v=iYTm2x5haM4 How to build Lego Emerald Express train - Lego Creator 31015 https://www.youtube.com/watch?v=1x0N3NGqP8c 20 Surprise Eggs,Play Doh Kinder Surprise Spongebob Disney Pixar Frozen Cars Mario https://www.youtube.com/watch?v=W4rtfPtjJ4A Toy Cutting Fruit Velcro Vegetable Salad Cooking Playset velcro steak fish chicken Cooking Playset https://www.youtube.com/watch?v=AkRYQf2gBwU Doraemon robot figure playset toy reviews https://www.youtube.com/watch?v=OG8pw04SN9I | ["Brass instrument", "Clarinet", "Trombone", "Trumpet", "Wind instrument, woodwind instrument"] | ["toy review", "package opening", "background music", "jazz", "clarinet", "brass", "upright bass", "piano", "acoustic drums", "cheerful", "lively"] | 9 | Pzp_oTEn0Yk | 2585 | |
"Milestones" (Miles Davis) | This is the live performance of a jazz music piece. There is a trumpet solo at the forefront. The background consists of the piano, the upright bass and a jazz acoustic drum beat. The atmosphere is restless. This piece could be playing in the background at a jazz bar. | 2006-08-18T02:23:52Z | Bobbelden | BOB BELDEN BIG BAND "Birdland" May 26, 2004 Jeremy Pelt-trumpet soloist, Joe Lovano-tenor sax soloist Seneca Black, Tony Kadleck, Ray Vega, Lew Glucken-trumpets Dave Gibson, Andre Hayward-trombones John Clark-french horn Howard Johnson-tuba Tim Ries, Charles Pillow, Mike Migliore, Ronnie Cuber, Gary Smulyan(winds) Kevin Hays-piano Derek Neyvergeld-bass Tommy Crane-drums Camera: Mantis Evar | ["Brass instrument", "Trumpet"] | ["jazz", "jazz fusion", "live performance", "no singer", "instrumental", "trumpet solo", "piano", "upright bass", "acoustic jazz drums", "improvisation", "complex", "restless"] | 9 | R6k2BkwZt1Y | 2670 | |
Professional Charleston - Strictly Come Dancing 2011 | This is a big band jazz music piece. It is an accompaniment piece to the Charleston dance. The band consists of a wide range of brass sections, an upright bass, a jazz acoustic drum beat and a vibraphone. Sounds from the cheering crowd can be heard. The atmosphere is lively. The piece is upbeat. | 2011-12-05T22:33:48Z | LunaleeTreasureBox | 2011 Professional Dancers: Pasha Kovalev Katya Virshilas Artem Chigvintsev Kristina Rihanoff Brendan Cole Erin Boag Anton du Beke Ola Jordan Robin Windsor Natalie Lowe Vincent Simone Aliona Vilani James Jordan Flavia Cacace 2011 Couples: Alex Jones & James Jordan Anita Dobson & Robin Windsor Audley Harrison & Natalie Lowe Chelsee Healey & Pasha Kovalev Dan Lobb & Katya Virshilas Edwina Currie & Vincent Simone Harry Judd & Aliona Vilani Holly Valance & Artem Chigvintsev Jason Donovan & Kristina Rihanoff Lulu & Brendan Cole Nancy Dell'Olio & Anton du Beke Robbie Savage & Ola Jordan Rory Bremner & Erin Boag Russell Grant & Flavia Cacace | ["Swing music", "Ska"] | ["jazz", "big band", "charleston dance", "no singer", "instrumental", "brass section", "upright bass", "acoustic drums", "vibraphone", "lively", "upbeat"] | 9 | WmyhSRhWh3k | 3135 | |
Miles Davis Quintet - Doxy | This is a jazz music piece. There is a trumpet and a saxophone playing the lead melody. The piano is playing the chords of the piece while the upright bass is playing a groovy bass line. The acoustic drums are playing a swing type beat for the rhythmic background. The atmosphere is groovy. This piece could be playing in the background at a coffee shop. | 2014-06-22T16:09:17Z | 60otaku4 | Miles Davis Quintet - Doxy (1954) Personnel: Miles Davis (trumpet), Sonny Rollins (tenor sax), Horace Silver (piano), Percy Heath (bass), Kenny Clarke (drums) from the album 'BAGS' GROOVE' (Prestige Records) | ["Brass instrument", "Saxophone", "Trumpet"] | ["jazz", "instrumental", "trumpet", "saxophone", "upright bass", "piano", "acoustic drums", "groovy", "vibrant"] | 9 | XpueyrkcMyQ | 3228 | |
WMB-12-007 情熱大陸(トロンボーン・ソロ) | This is a jazz music piece. There is a piano and a trombone playing a groovy tune. The atmosphere is lively. This piece could be used as an opening theme for a nighttime talk show or a historical YouTube channel. | 2012-12-07T06:47:10Z | めちゃモテ・シリーズ | ★管楽器プレイヤーのための新しいソロ楽譜"めちゃモテ"シリーズ ~トロンボーン~ 演奏:前田 大輔 編曲:前田大輔、萩原 隆、小林真人 この曲はTBS系ドキュメンタリー番組「情熱大陸」のオープニング曲です。 情熱的なヴァイオリンとバンドネオンのエキゾチックな響きが印象的で、 この曲が収録されたアルバム「image」は、イージーリスニング音楽のアルバムとして史上初のオリコン総合チャート1位を記録し話題となりました。 演奏に使われている楽譜の購入はコチラから ↓伴奏CD付楽譜 http://brass.winds-score.com/?pid=52535119 | ["Brass instrument", "Trombone"] | ["jazz", "no singer", "instrumental", "piano", "trombone", "lively", "playful", "theme music"] | 9 | tBKOvAiNOQE | 5014 |
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;