musiccaps_details (view)
1 row where musiccaps_aspects contains "saxophone", musiccaps_aspects contains "shocking strings playing" and musiccaps_author = 3
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 |
---|---|---|---|---|---|---|---|---|---|---|
Seraph of the End Crack #2 | This is a series of clips - a compilation. The compilation is separated by the telephone beep tone. One of the clips is orchestral strings playing a motif that would be used when something shocking or suspenseful happens. The other clip contains a jazzy saxophone motif. There is also a sultry woman speaking sassily with some upbeat percussion under her vocal. | 2016-01-05T05:36:29Z | SirenDragonSong | Yes, I did another Seraph of the End crack. And no, I think this obsession is completely normal XD My first crack has been by far my most popular video, so I thought I would make another for all of you! I hope you all like it! And I'm sorry it took so long to post it, iMovie kept messing the video up and I had to restart it. I made an intro too if any of you noticed. Does it look ok? My updating hasn't been regular in the first place, but it will probably become even more irregular because I start school again soon, though I will try to update as much as possible. Thank you again to all of the commenters of my first video, I really appreciate the positive feedback! It makes me happy to know everyone has been liking the anime crack. I know I have been reusing many of the same episodes of scenes in the cracks, but that's because I haven't finished the series yet and I don't know what clips from later episodes work (currently I am only on episode 7 of season 2, but I have spoiled episode 10 for myself, so that's why it's there XD) On to my next video business. I don't know what I should to next, or what you guys want. I was thinking about doing another Nightcore, or even trying an AMV. But if you guys want another crack, I can do that too. I am open to any suggestions. All of the fanart I got off of Google Images if any of you want to know. Just search up "Mika and yuu fanart". *I don't own Seraph of the End, music, or program rights.* | ["Busy signal", "Music"] | ["telephone beep tone", "saxophone", "shocking strings playing", "repeated telephone beep tone", "talking woman", "disjointed", "upbeat pop clip"] | 3 | b9rgWct9ivI | 3606 |
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;