musiccaps_details (view)
1 row where musiccaps_names contains "Guitar", musiccaps_names contains "Music" and "youtube_published" is on date 2011-08-17
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 |
---|---|---|---|---|---|---|---|---|---|---|
Gibson Custom Shop 1957 Les Paul Goldtop | Someone is strumming a melody on a clean e-guitar. This may be playing for an advertisement. | 2011-08-17T23:02:03Z | MusicStoreTV | GIBSON CS Les Paul '54 VOS Reissue GT Gold Top Die Gibson Les Paul 1957 Goldtop wurde dem neu entwickelten Lackieverfahren (VOS) unterzogen. Durch dieses Verfahren ist die Gitarre jetzt auch optisch auf dem Ton-Level dieser einzigartigen Les Paul. Mehr Sustain als mit einer Les Paul gibt es einfach nicht. Aber hören Sie selbst! Erhältlich unter: http://www.musicstore.de/de_DE/EUR/Gibson-1954-Les-Paul-Goldtop-VOS-Antique-Gold/art-GIT0016115-000 http://www.musicstore.de | ["Electric guitar", "Guitar", "Music", "Musical instrument", "Electronic tuner", "Plucked string instrument"] | ["e-guitar", "medium tempo"] | 6 | XOLVI1bgxqk | 3180 |
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;