musiccaps_details (view)
1 row where musiccaps_aspects contains "groovy", musiccaps_aspects contains "r&b" and musiccaps_aspects contains "sensual"
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| The Thong song - Runescape Style | This is an R&B/soul music piece. There is a male vocalist singing melodically and in a sensual manner over multiple tracks. The melody of the beat is provided by a string sample. There is a strong bass sound in the piece. The rhythm is provided by a groovy electronic drum beat. There is an urban feel to this piece. It could be used in the soundtrack of a TV series where two characters are sharing intimate moments. | 2007-07-20T10:33:10Z | Sladeakakevin | That Thong th thong thong thong :) Enjoy! HONORS FOR THIS VID: --TODAY-- #16 - Most Viewed (Today) - Gadgets & Games #2 - Top Rated (Today) - Gadgets & Games #1 - Most Discussed (Today) - Gadgets & Games #2 - Top Favorites (Today) - Gadgets & Games --THIS WEEK-- #8 - Top Rated (This Week) - Gadgets & Games #6 - Most Discussed (This Week) - Gadgets & Games #10 - Top Favorites (This Week) - Gadgets & Games --THIS MONTH-- #16 - Top Rated (This Month) - Gadgets & Games #22 - Most Discussed (This Month) - Gadgets & Games #11 - Top Favorites (This Month) - Gadgets & Games _______ RuneScape is a registered trademark of JaGeX Limited. I do not claim, or have any, affiliation with JaGeX Ltd. This video was not intended for any personal gain, only for entertainment purposes. All comments expressed in the video are solely my own, all comments by others are their own and I do not take responsibility for their actions. Consider this, free advertising http://www.runescape.com/ | ["Music", "Exciting music"] | ["r&b", "soul", "male vocal", "melodic singing", "strings sample", "strong bass", "electronic drums", "sensual", "groovy", "urban"] | 9 | -6pcgdLfb_A | 16 |
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;