musiccaps_details (view)

1 row where musiccaps_aspects contains "acoustic guitars", musiccaps_aspects contains "digital acoustic drums", musiccaps_aspects contains "string section" and musiccaps_names contains "Tender music"

✎ 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
Thunderstep Music - Conquistador (Epic Beautiful Orchestral Drama) This song contains a string section playing a short stroke melody in the lower range along to a digital acoustic drum playing a rather complex groove. Acoustic guitars are playing a melody. This song may be playing in a heroic movie scene. 2013-05-18T17:52:28Z Apollon de Moura / Thunderstep Music Please read the description if you want to use this composition in your own work. Some specific tracks have their own terms, so be sure to read the description for each and every score you want to use. If you are just a harmless listener *wink* you can download this track for free here (payment is optional): https://thunderstepmusic.bandcamp.com/track/conquistador If you want to use this track, you have to read this first! This track is registered under AdRev. If you use it in your work, AdRev's content-ID tracking system will find it and claim it. Don't worry, this is just a notification, your video will not be taken down, nor will your channel get flagged. AdRev just monetizes it (places ads in front of it) and generates ad revenue for me. This way, you won't have to pay for a license and still can use the music, you just won't be able to monetize that one video, as it will be indirectly monetized by me (so to speak). Long story short: This track is free to use but ads will be placed in front of your video. This way you don't have to spend money but I can still receive payment and treat this channel as the job it is. To ensure everything goes off without a hitch please comply with these three conditions: 1. The work in which this track is used must be non-commercial (no monetizing or gaining money in any other form). 2. You must give credit to me. 3. If remixed or changed in any other way, the derivative track must be distributed under the conditions above. That's all, thanks for taking your time! If you have... ...interest in a paid commercial use of this track ...interest in a custom score production ...an issue with or wonder what content-ID is ...any other questions or just want to talk to me, please contact me over the platforms below. I'd be happy to help you out! Thunderstep Music: Facebook: https://facebook.com/thunderstepmusic (most active) Twitter: https://twitter.com/thegod0fsun Souncloud: https://soundcloud.com/armando-de-moura Bandcamp: https://thunderstepmusic.bandcamp.com/ Audiojungl… ["Background music", "Theme music", "New-age music", "Music", "Tender music"] ["cinematic", "experimental", "e-bass", "acoustic guitars", "string section", "digital acoustic drums", "uptempo", "complex"] 6 aupCwPVWsMo 3585

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;