musiccaps_details (view)

1 row where musiccaps_author = 4, musiccaps_names contains "Music" and "youtube_published" is on date 2013-01-14

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: youtube_published (date), musiccaps_names (array)

video youtube_link musiccaps_caption youtube_published youtube_channel youtube_description musiccaps_names musiccaps_aspects musiccaps_author youtube_id musiccaps_rowid
Peavey - 6505 Plus 112 Combo Demo at GAK! The low quality recording features an electric guitar melody being played. There is a tiny audio pop in the left channel of the stereo image. The recording is noisy and muffled, but regardless it sounds hopeful. 2013-01-14T10:09:51Z GAK Subscribe to GAK Vision for daily video demos and features - http://www.youtube.com/subscription_center?add_user=GAKVision Watch this video in my guitars playlist - https://www.youtube.com/watch?v=dfKJiUdaIPw&feature=c4-overview-vl&list=PLvmXUu0-OdydwHjr7sid9cCIXbCkN-gt1 Peavey 6505 Plus 112 Combo http://www.gak.co.uk/en/peavey-6505-plus-112-combo/37958/ After forging the sound of aggression for more than 15 years, Peavey is making its highly respected, high-gain 6505® Series amplifier available for the first time in a 1x12 combo-amp configuration. The new 6505 Plus 112 combo harnesses the full gain and legendary tone of the Peavey 6505 Series, which since 1991 has defined the sounds of extreme rock guitar, into a format that is equally suited to clubs, rehearsal rooms and studios. Five select 12AX7 preamp tubes and a pair of 6L6GC power-amp tubes provide the tonal foundation for the 6505 Plus 112 combo, while patented circuitry such as Peavey's Resonance control tweak its legendary tone. Both the Lead and Rhythm channels feature independent three-band EQ, pre/post gain controls and Presence and Resonance adjustment. The Rhythm channel also includes a footswitchable Crunch boost. The 6505 Plus 112 combo also features the Peavey MSDI™ microphone-simulated direct interface, which eliminates the need for miking by allowing users to route the amp's signal directly to a recording device or mixing console. Additional features include three- spring reverb, effects loop and external speaker outputs, plus a 12" Sheffield® loudspeaker in a sealed-back cabinet that offers maximum resonance and sound projection. Visit GAK Vision for more videos: http://www.youtube.com/gakvision ["Effects unit", "Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument"] ["low quality", "electric guitar melody", "hopeful", "tinny audio pop", "noisy", "muffled"] 4 Z0OTDXtjK9M 3335

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;