musiccaps_details (view)
1 row where musiccaps_aspects contains "low quality", musiccaps_author = 4 and youtube_description = "Bound to go down in history as one of the greatest, most versatile reverb pedals of all time, the TC Electronic Hall Of Fame will not disappoint. Featuring 11 fully tweakable reverb sounds and TC Electronics unique toneprint function, so you can have the reverb tone of all of your favourite artists at your fingertips! The TC Electronic Hall of Fame can also be used stereo, and includes stereo inputs for those who run stereo! Cool! The TC Electronic Hall Of Fame is much much more than just your average amp reverb. Get the tone of the pros and pick up your TC Electronic Hall Of Fame Reverb at https://www.prymaxe.com today!"
This data as json, CSV (advanced)
Suggested facets: musiccaps_names (array), musiccaps_aspects (array)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
TC Electronic Hall Of Fame Reverb | The low quality recording features an emotional electric guitar chord progression being played with a huge reverb effect on it. It sounds like it is played in a huge space. | 2011-07-25T22:15:58Z | Prymaxe | Bound to go down in history as one of the greatest, most versatile reverb pedals of all time, the TC Electronic Hall Of Fame will not disappoint. Featuring 11 fully tweakable reverb sounds and TC Electronics unique toneprint function, so you can have the reverb tone of all of your favourite artists at your fingertips! The TC Electronic Hall of Fame can also be used stereo, and includes stereo inputs for those who run stereo! Cool! The TC Electronic Hall Of Fame is much much more than just your average amp reverb. Get the tone of the pros and pick up your TC Electronic Hall Of Fame Reverb at https://www.prymaxe.com today! | ["Effects unit", "Electric guitar", "Music", "Chorus effect", "Distortion"] | ["low quality", "emotional electric guitar chord progression", "reverb pedal effect", "huge space"] | 4 | CGYflJRiLt0 | 1345 |
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;