musiccaps_details (view)
1 row where musiccaps_aspects contains "manic", musiccaps_author = 4 and "youtube_published" is on date 2013-12-30
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 |
---|---|---|---|---|---|---|---|---|---|---|
♣ Sensus | WoW Rogue PvP | Slice and Dice 4 (WoW MoP Rogue PvP Movie) [Patch 5.4] | The Metal song features a manic drum roll followed by wide arpeggiated electric guitar melody in the beginning of the loop. When the beat drops, there is a flat male vocal singing over aggressive wide electric guitar chords, energetic bass guitar, energetic cymbals and punchy kick and snare hits. It sounds very energetic, like something you would go in a mosh pit for. | 2013-12-30T23:25:13Z | Sensus | ►Facebook Page: https://www.facebook.com/SensusFans ►Twitch Stream: http://www.twitch.tv/SensusLive ►Anook Page: http://www.anook.com/Sensus ►Sign Up to Gamers League!: http://gamers-league.com/ ►Sign Up to Next Level PvP!: http://www.nextlevelpvp.com?ref=Sensus-5884 ►Get Gungho for 50% off and Free Shipping at: http://www.gogungho.com/WorldofSensus ►Welcome to the next installment of my PvP montage series, Slice and Dice 4! When I originally set out to make this I wanted it to be the best PvP movie I've made so far and I think I accomplished that. I also wanted it to be not only my project, but a community project involving everyone who wanted to be a part of it which is why I've featured some awesome graphics work made by some of you guys in the credits. Huge thanks to everyone who got involved, and now without further ado I present Slice and Dice 4!!! :D (Watch in HD!) Note: Most clips were recorded at the beginning of season 14 so some players in the video (including myself) were still in the process of getting gear. ►Special Thanks to: Cobrak: http://www.youtube.com/user/casteas16 Paralyzar: http://www.youtube.com/user/Para1yzar ►What to Expect: Solo Battleground PvP (Sub, Assassination, and Combat) Rogue Tricks Engineering Duels vs. Retribution Paladin Duels vs. Destruction Warlock Solo World PvP Mistakes ►Music: Blue Stahli - Metamorphosis (Voicians Remix) Our Last Night - Never Felt This Way Fail Emotions - Reborn Nero Argento - Cobrak Our Last Night - Same Old War Our Last Night - Sunrise ►Vocians: https://www.facebook.com/voicians ►Our Last Night: https://www.facebook.com/ourlastnightband ►Fail Emotions: https://www.facebook.com/FailEmotionsband | ["Music", "Angry music"] | ["metal", "drum roll", "energetic", "flat male vocal", "aggressive wide electric guitar chords", "energetic bass guitar", "wide arpeggiated electric guitar melody", "energetic cymbals", "punchy snare", "punchy kick", "manic"] | 4 | UcNVLU-cRNg | 2926 |
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;