musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "medium tempo", musiccaps_names contains "Electric guitar" and musiccaps_names contains "Electronic tuner"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- medium tempo · 3 ✖
- electric guitar tutorial 2
- instrumental 2
- male voice speaking 2
- stringed instrument 2
- amplified 1
- amplified instrument 1
- catchy riff 1
- demo 1
- e-guitar 1
- electric guitar 1
- electric guitar lesson 1
- evie’s 1
- hard rock 1
- heavy meal 1
- introduction 1
- loud 1
- mark lucas 1
- metal 1
- rock 1
- sonic power 1
musiccaps_names (array) 8 ✖
- Electric guitar · 3 ✖
- Electronic tuner · 3 ✖
- Guitar 3
- Music 3
- Musical instrument 3
- Plucked string instrument 3
- Speech 2
- Inside, small room 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
PRS SE 245 Electric Guitar | This music is instrumental. The tempo is medium with a short,electric guitar riff and a male voice doing an introduction to a demo. The video is a tutorial/review of an electric guitar. | 2011-07-01T19:00:48Z | N Stuff Music | With a voice that is classic, eminently recordable and gig ready, the SE 245 is perfect for traditional single-cutaway players. The 24.5" scale length makes this instrument instantly comfortable to players who grew up using short scale guitars. Volume and tone controls for each pickup, a 3-way toggle and bird inlays are all standard appointments. Specifications: Body Top Wood: Maple Top and Flame Maple Veneer (no veneer on opaque finishes) Back Wood: Thick Mahogany Neck Number of Frets: 22 Scale Length: 24 1/2" Neck Wood: Mahogany Fretboard Wood: Rosewood Neck Shape: Wide Fat Fretboard Inlays: Birds Hardware/Electronics Bridge: PRS Designed Stoptail Tuners: PRS Designed Tuners Truss Rod Cover: "PRS" Hardware Type: Nickel Treble Pickup: PRS Designed SE 245 Treble Humbucker Bass Pickup: PRS Designed SE 245 Bass Humbucker Pickup Switching: Volume and Tone Control For Each Pickup and 3-Way Toggle Pickup Selector On Upper Bout . Join us on Facebook! https://www.facebook.com/NStuffmusic Checkout all of the videos on our Youtube channel! https://www.youtube.com/nstuffmusic Follow us on Twitter and stay up-to-date on all our deals! https://twitter.com/Nstuffmusic Wanna see what’s new? Follow us here. https://instagram.com/nstuffmusic Come visit us and check us out on Google. https://plus.google.com/+NstuffMusic N Stuff Music 468 Freeport Road Pittsburgh PA 15238 412-828-1003 https://www.NStuffMusic.com | ["Electric guitar", "Guitar", "Music", "Musical instrument", "Speech", "Electronic tuner", "Plucked string instrument", "Inside, small room"] | ["instrumental", "medium tempo", "introduction", "evie’s", "mark lucas", "male voice speaking", "demo", "electric guitar tutorial", "loud", "sonic power", "amplified", "stringed instrument", "rock", "metal", "heavy meal", "hard rock"] | 7 | Ij1-640aafg | 1933 | |
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 | |
16. Tipos de Guitarra | This music is instrumental. The tempo is medium with an electric guitar harmony. The music is a catchy riff with a male voice speaking in a foreign language. This clip is an electric guitar lesson/ tutorial. | 2009-07-17T04:08:27Z | iBeriano93 | 16/17 Clinica Angel Parra 16/ Tipos de Guitarra sl2! | ["Electric guitar", "Guitar", "Music", "Musical instrument", "Speech", "Electronic tuner", "Plucked string instrument"] | ["instrumental", "medium tempo", "electric guitar", "male voice speaking", "electric guitar lesson", "amplified instrument", "stringed instrument", "electric guitar tutorial", "catchy riff"] | 7 | YBbvQ0RPrG8 | 3264 |
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;