musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "acoustic drums", musiccaps_aspects contains "guitar solo" and musiccaps_aspects contains "slow tempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- acoustic drums · 2 ✖
- bass guitar 2
- blues 2
- groovy 2
- guitar solo · 2 ✖
- instrumental 2
- slow tempo · 2 ✖
- chill 1
- clean electric guitar 1
- crunchy 1
- easygoing 1
- electric guitar 1
- live performance 1
- no singer 1
- relaxing 1
musiccaps_names (array) 7 ✖
- Blues 2
- Music 2
- Electric guitar 1
- Guitar 1
- Musical instrument 1
- Plucked string instrument 1
- Strum 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Josh Gooch: Guitar Center King of the Blues '09 Finalist | This is the live performance of a blues music piece. It is an instrumental performance. The lead electric guitar is playing a blues solo while another electric guitar and a bass guitar are playing in the background. The rhythmic background consists of a slow tempo blues acoustic drum beat. There is a groovy atmosphere to this performance. This piece could be playing in the background at a rock bar. | 2010-02-05T23:29:42Z | Guitar Center | Guitar Center King of the Blues finalist, Josh Gooch's performance from the GC King of the Blues Grand FInals - Nov 12th, 2009 at the House of Blues Sunset. For more information on Guitar Center or King of the Blues visit www.guitarcenter.com | ["Blues", "Electric guitar", "Guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["live performance", "blues", "instrumental", "electric guitar", "guitar solo", "bass guitar", "acoustic drums", "groovy", "crunchy", "slow tempo"] | 9 | 4bXb6GLm6zg | 589 | |
♫ Blues Music - Relaxing Romantic Sexy Slow Blues - Instrumental Guitar Blues Chill Out | This is an instrumental blues music piece. A clean electric guitar is playing a groovy solo while the bass guitar plays in the background. The acoustic drums are playing a slow tempo blues beat. The piece has a relaxing atmosphere. It could be playing in the background at a rock bar. This piece could also be playing in the soundtrack of a romantic movie especially during flirting scenes. | 2013-09-27T22:08:24Z | BLUES GUITAR NATION by KENNETH ST. KING | Blues Music, Blues songs. Blues Guitar. Sweet Old School slow Blues vibe for your enjoyment. Fashioned in the classic style of BB King, Eric Clapton, Peter Green, Mick Taylor, Mike Bloomfield and all my other boyhood Blues guitar hero's! Thanks! ~KJ St. King Gear used: Fender Hot Rod Telecaster, Fender Jeff Beck Strat, Fender Super Champ XD. Recorded using Garageband. A little sexy musica de striptrips! Photo use: Rodrigo Gianesi @ http://www.flickr.com/photos/perfectsonnet/ Photo use: My Huy Streetphotography @ http://www.flickr.com/photos/myhuyphoto/with/8685713769/ Photos used via Creative Commons License 2.0 @ http://creativecommons.org/licenses/by/2.0/deed.en_CA Great old school Blues guitar. Romantic, sexy and sensual sounding. Rich top notch tones from two of Fender's best guitars played through a superb Fender Amp. Best Relaxing Blues. Best Romantic Blues Guitar. Top Instrumental Blues Guitar. Best Blues Guitar. Blues Guitar Solo. Blues Music Guitar. Instrumental Blues. Blues Guitar Solo. Blues Licks. Blues Riffs. Hot Blues. Best Blues Solo. Blues Tones. For my overseas friends and friends from Non-English speaking countries, here are some descriptives in order to assist you in finding our sweet Blues! Blues Music la música blues موسيقى البلوز блюз Blues müzik muzica blues blues musikk ブルース音楽 blues μουσική Blues-Musik blues musika bluesmuziek Blues Guitar guitarra de blues Блюз гітара guitarra de blues blues gitar блюзової гітари blues gitarr blues gitara блюзовой гитары chitara blues guitarra blues Blues-Gitarre la guitare blues blues gitaar blues kytara | ["Blues", "Music"] | ["blues", "no singer", "instrumental", "clean electric guitar", "guitar solo", "bass guitar", "acoustic drums", "groovy", "chill", "relaxing", "easygoing", "slow tempo"] | 9 | QIjShFhrp6w | 2610 |
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;