musiccaps_details (view)

1 row where musiccaps_aspects contains "guitar solo", musiccaps_aspects contains "hard-hitting" and "youtube_published" is on date 2012-03-15

✎ View and edit SQL

This data as json, CSV (advanced)

video youtube_link musiccaps_caption youtube_published youtube_channel youtube_description musiccaps_names musiccaps_aspects musiccaps_author youtube_id musiccaps_rowid
Korg Pandora Mini Personal Guitar and Bass FX Processor Demo - Nevada Music UK This is an instrumental version of a heavy metal piece. There is a distorted electric guitar and a bass guitar playing the main tune while another distorted electric guitar is playing a medium-to-high pitch solo. The acoustic drums are playing a medium tempo heavy metal beat. It is a hard-hitting piece. This piece can be used in the soundtrack of an action-filled video game. It could also be playing in the background of a rock/metal bar. 2012-03-15T15:27:54Z PMTV Portsmouth Here... http://www.nevadamusic.co.uk/guitar/effects/korg-pandora and in White here... http://www.nevadamusic.co.uk/guitar/effects/korg-pandora-white Korg's in-house developed REMS (Resonant structure and Electronic circuit Modeling System) delivers 158 effects types & 200 Preset programs provide stage-ready sounds for numerous genres and playing styles. Of those, 115 are Song Presets which means that they are sounds which have been accurately re-created for signature songs by famous bands or guitar players. 200 Preset programs cover a broad range of genres and playing styles, so you're sure to find plenty of favorites. Choose one of the 115 Song presets and instantly capture the signature tone used by legendary guitarists playing your favorite hits. Use the Aux input to play along using your iPod, CD or MP3 player. Of the 200 Preset programs, 160 are designed for guitar and 40 are designed for bass. Of course you can also edit your own sounds and store up to 200 of them as User programs. In conjunction with the presets, this gives you a total of 400 programs whilst up to seven different effects can be used simultaneously. PANDORA mini contains 100 rhythm and metronome patterns of diverse types, making it the ideal partner for session practice, song-writing, or rhythm training. The AUX (Auxilliary) pitch function lets you vary the pitch of the audio input by ±1 octave, so it's easy to match the key of the song to the tuning of your guitar. The PANDORA mini operates on a single AA battery and its diminuative size makes it highly portable - you can also connect your PANDORA mini to your computer with a single USB cable and use the dedicated sound editor software (available as a free download from the Korg website) to edit sounds and manage programs. Another useful feature is the built-in auto tuner, complete with a mute button so why not check out this pint-sized powerhouse effects unit on your next visit to the Nevada Music Warehouse ... ["Heavy metal", "Music", "Punk rock", "Progressive rock", "Distortion"] ["heavy metal", "instrumental", "no singer", "distorted electric guitar", "guitar solo", "bass guitar", "acoustic drums", "loud", "hard-hitting"] 9 E_kgtQ93Q1s 1573

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;