musiccaps_details (view)

1 row where musiccaps_aspects contains "low quality", musiccaps_aspects contains "mellow female vocal", musiccaps_aspects contains "simple hi hats" and musiccaps_aspects contains "stereo imbalance"

✎ 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
TeknoAXE's Royalty Free Music - Royalty Free Music #130 (Sun -- by Qelric) Grunge/Rock/Hard Rock The Soft rock song features a mellow female vocal singing the same melody as the lead electric guitar, followed by widely spread acoustic rhythm guitars, simple bass, soft kick hits, punchy snare, simple hi hats, shimmering open hats and energetic crash cymbals. There is a short snare roll at some point in the loop. The stereo bass guitar is what makes the stereo image imbalance and therefore the song sounds lower in quality. 2012-07-01T12:33:07Z TeknoAXE's Royalty Free Music Download Music: http://teknoaxe.com/Link_Code_3.php?q=166 http://www.youtube.com/user/Qelric **This track is Royalty Free and is free for anyone to use in YouTube videos or other projects, whether monetized or not.** http://www.facebook.com/teknoaxe http://www.reverbnation.com/teknoaxe I'm very proud to present "Sun", by Qelric! Early last week, she came to me wanting to Collaborate on a song she had written, complete with a demo that she had done on her recording set up. She asked me to interpret her song, recording it to my computer and this is the result. I personally think it's awesome! Most, if not all, the writing credit goes to Qelric. The notes are hers, so I had it easy this time and just recorded the track how I felt it would sound best. This song from Qelric actually inspired me to restring my acoustic guitar, which has been sitting in the corner defunct for months now. But now it works and sounds fantastic! So Qelric had some reservations about putting less reverb on her voice because she feels that it sounds better. But I think you'll agree that it sounds really good with just a touch of reverb for the mix and her voice sounds great cutting through! *Legal notice: The publisher of this video and Qelric (http://www.youtube.com/user/Qelric) are the original sources for the music track being presented in this video, which is entitled "Sun -- by Qelric". No one entity, person or organization may take legal action against other entity, person or organization due to use or distribution of this track or modified portions of this music track. image used: http://commons.wikimedia.org/wiki/File:Sun_Clouds.JPG ["Music", "Punk rock", "Rock music", "Rock and roll", "Grunge"] ["soft rock", "mellow female vocal", "wide acoustic rhythm guitars", "mono solo electric guitar lead melody", "short snare roll", "energetic cash cymbal", "simple hi hats", "shimmering open hat", "easygoing", "smooth", "simple bass guitar", "low quality", "stereo imbalance"] 4 dbldb9tq8ng 3803

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;