musiccaps_details (view)
23 rows where musiccaps_author = 4 and musiccaps_names contains "Strum"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date), musiccaps_aspects (array)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
林宥嘉 Yoga Lin [ 寵兒 The Loved Ones ] Music Video (電影「我的蛋男情人」主題曲) 陳星合 Acoustic Cover | The low quality recording features a cover of a ballad song that consists of passionate, muddy male vocal singing over arpeggiated acoustic guitar melody. It sounds noisy, muddy and messy, as the frequencies are clashing, but it is also emotional and raw. | 2016-10-01T13:18:56Z | 我是星合HE's channel | 林宥嘉 [ 寵兒 The Loved Ones ] Acoustic Cover 吉他翻唱改編 ►陳星合Facebook粉絲頁 : https://www.facebook.com/shinghemusic ►Instagram : https://www.instagram.com/shinghe0807/ →歡迎追蹤與訂閱← 每週三都會有新的音樂作品哦!!! 希望你們會喜歡這次的翻唱 :) | ["Acoustic guitar", "Music", "Musical instrument", "Steel guitar, slide guitar", "Strum", "Plucked string instrument", "Tender music"] | ["low quality", "passionate muddy male vocal", "arpeggiated acoustic guitar melody", "noisy", "muddy", "cover", "emotional", "ballad", "raw", "messy"] | 4 | -8cgbhIR_pw | 21 | |
DAVID ALLAN COE interview - part 1 | The low quality recording features a flat male vocal singing over acoustic rhythm guitar chords, after which that same vocal is talking. The song sounds passionate, while the recording, overall, is noisy and in mono. | 2008-07-26T19:53:24Z | BubbaTheLawnJockey | DAVID ALLAN COE interview - part 1 | ["Singing", "Country", "Music", "Strum"] | ["low quality", "noisy", "mono", "acoustic rhythm guitar", "flat male vocal", "passionate", "country"] | 4 | -UuEBhule84 | 52 | |
How to play romanza (romance) classical guitar lessons with Gary | The low quality recording features a guitar tutorial that consists of a flat male vocal talking and counting the rhythm over an arpeggiated acoustic guitar melody. The recording is mono and noisy. | 2008-01-09T06:25:04Z | Taffypro | TO HEAR THIS WITHOUT THE ANNOYING ACCENT AND AT FULL QUALITY PLEASE VISIT: http://taffyproductions.com/ How to play romance classical guitar lesson, Guitar lessons, classical guitar lessons, How to play, beginning guitar lesson How to play romanza romanza on the guitar | ["Guitar", "Music", "Musical instrument", "Strum", "Speech", "Plucked string instrument"] | ["low quality", "flat male vocal", "arpeggiated acoustic guitar melody", "tutorial", "noisy", "mono"] | 4 | 0K-zyeLuKho | 146 | |
EXO Chanyeol 2014 special stage live guitar and singing parts compilation | The low quality recording features a pop song performed by passionate male vocalists, followed by acoustic guitar arpeggiated melody and mellow piano melody. It sounds heartfelt and emotional. There are some crowd noises in the background. | 2015-01-12T14:42:18Z | geniechan | List of songs: 141231 MBC Gayo Daejun 2014 https://www.youtube.com/watch?v=-bGjK1ErIZ8 141226 KBS Gayo Daejun 2014 Don't Be Sad (슬픈 표정 하지 말아요) https://www.youtube.com/watch?v=NvRyjwIvxKU 141112 KBS MUSIC BANK in MEXICO Sabor a mi https://www.youtube.com/watch?v=Gk1iZ8na42I love love love acoustic version (this one is not live but I include it as it sounds so beautiful XD) https://www.youtube.com/watch?v=yO9C-4wFx_4 I do not own ANY of the soundtrack and images. full credits go to exo and the aforementioned tv programs. | ["Guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument", "/t/dd00003"] | ["low quality", "pop", "acoustic guitar arpeggiated melody", "passionate male vocal", "crowd noises", "mellow piano melody", "heartfelt", "emotional"] | 4 | 0_QcatLmg7c | 182 | |
Blues Guitar Lessons - Stormy Monday - Style Blues Progression | The low quality recording features a cover of a blues song and it consists of subtly strummed, acoustic rhythm guitar, followed by electric guitar solo melody. It sounds passionate, easygoing and cool - like something you would hear in high end bars or blues clubs. The recording is a bit noisy. | 2010-12-31T03:07:30Z | GuitarJamz | Free Ebook when you sign my email list http://www.guitarjamz.com/new_requests/ Tony's Site http://www.tonybrucco.com | ["Electric guitar", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["cover", "low quality", "noisy", "blues", "subtly strummed acoustic rhythm guitar", "electric guitar solo melody", "passionate", "easygoing", "cool"] | 4 | 1JwoLPCIGhs | 259 | |
Sweater Weather by The Neighbourhood acoustic guitar instrumental cover with onscreen lyrics karaoke | The low quality recording features an arpeggiated acoustic guitar. It sounds mellow, soft, emotional and sad. | 2014-02-10T00:29:44Z | avg iQ | Download http://avg-iq.com/2014/02/sweater-weather-neighbourhood.html More instrumentals http://avg-iq.com/p/more-songs_28.html Chords: Eb Cm Gm Bb (Beginning to End) Sweater Weather by The Neighbourhood acoustic guitar instrumental cover with onscreen lyrics karaoke backing track . Singing Tips http://bit.ly/avgiQsingingtips Guitar Lesson http://bit.ly/avgiQguitarlesson Piano Lesson http://bit.ly/avgiQpianolesson . . We want to make you an exclusive guitar instrumental of your favorite song or any song you want. Please email avgiQacoustic@gmail.com . Request a Song http://avg-iq.com/p/request-song.html | ["Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["low quality", "arpeggiated acoustic guitar", "mellow", "soft", "emotional", "sad"] | 4 | 2x9735gU01s | 419 | |
Fingerstyle Jazz Guitar Improv - Jody Fisher | The low quality recording features a jazzy electric guitar melody. The recording is noisy and it is in mono - regardless, it sounds calming and relaxing. | 2006-02-23T23:43:33Z | workshoplive | http://www.workshoplive.com/index.cfm?WT.mc_id=YTJZGIT-JF1 Jody Fisher, one of our jazz instructors at workshoplive, took some time to jam some jazz musings on his Klein electric guitar. Enjoy Jody's music! | ["Guitar", "Jazz", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["jazzy electric guitar melody", "low quality", "mono", "noisy", "calming", "relaxing"] | 4 | 476vNb6thyM | 540 | |
50 guitar building tools anyone can make | The low quality recording features a flat male vocal talking over an acoustic guitar solo melody playing in the background. It sounds like a tutorial and the recording is in mono. | 2009-10-20T18:40:43Z | Jamie Boss | You can learn more about my guitar building, banjo and mandolin DVDs at http://www.hotstringsguitar.com. You can purchase the entire 30 minute DVD by going to http://stores.ebay.com/Hot-Strings-Guitar-Shop or http://www.hotstringsguitar.com/dvd-guitar-building-tools.php. This is my latest DVD "50 guitar building tools anyone can make". The 30 minute video highlights 50 tools that I have built in my workshop for guitar building and repair. Easy to make and well thought out, these tools will inspire a lot of guitar making tools in your guitar shop. Designed for the beginning guitar builder and luthier alike, this DVD can be purchased on my website, www.hotstringsguitar.com. Background guitar by Jamie Boss. Copyright®2009 Jamie Boss | ["Bass guitar", "Guitar", "Music", "Musical instrument", "Strum", "Speech", "Plucked string instrument"] | ["low quality", "flat male vocal", "acoustic guitar solo melody", "tutorial", "mono"] | 4 | 4LZSSya3ZZQ | 558 | |
40 guitar techniques in one solo! | The low quality recording features a cover of a soft rock song and it consists of strummed electric guitar and mellow electric guitar melody played over playback that has groovy bass, reverberant rimshots, shimmering cymbals and sizzling high pitched synth pad. It sounds emotional, funky and passionate. | 2012-05-09T21:21:59Z | gmcguitar | Get the tabs, backings and scales here: http://bit.ly/1fVenNd More Sinisa lessons: http://bit.ly/18qf2o8 Techniques covered in this solo: - hammer on (video part 1) - 5:20 - pull off (video part 1) - 5:20 - alternate picking (video part 2) - 5:48 - strumming (video part 3) - 6:26 - natural harmonics (video part 4) - 6:50 - artificial harmonics (video part 4) - 6:50 - finger picking chords (video part 5) - 7:26 - octave playing (video part 6) - 8:04 - normal legato (video part 7) - 8:41 - strict legato (video part 7) - 8:41 - pre bends (video part 8) - 9:17 - normal bending (video part 8) - 9:17 - micro bending (video part 9) - 9:45 - trills (video part 10) - 10:02 - thumb thang (video part 11) - 10:22 - double stops (video part 12) - 10:41 - vertical vibrato (video part 13) - 11:02 - horizontal vibrato (video part 13) - 11:02 - circular vibrato (video part 13) - 11:02 - wild vibrato (video part 13) - 11:02 - one hand tapping (video part 14) - 11:31 - 2 hand tapping (video part 14) - 11:31 - sweep picking (video part 15) - 12:08 - funk scratching (video part 16) - 12:32 - slapping & popping (video parts 17, 18, 19) - 13:24 , 13:37 , 13:57 - banjo roll (video parts 20, 21) - 14:17 , 14:45 - chicken picking (video part 22) - 15:14 - volume knob/violin effect (video part 23) - 15:45 - tremolo picking (video part 24) - 16:17 - slides (video part 24) - 16:17 - heavy downpicking (video part 25) - 16:58 - palm muting (video part 25) - 16:58 - pinch harmonics (video part 26) - 17:40 - tapped harmonics (video part 27) - 18:05 - switch toggling (video part 27) - 18:05 - Greg Howe Style/glissando vibrato (video part 28) - 18:36 - nut/neck/whammy vibrato (video part 29) - 19:02 - hybrid picking (video part 30) - 19:25 - string skipping (video part 30) - 19:25 - fast picking and mixed techniques (video parts 31-40) - 20:04 + | ["Guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["low quality", "playback", "cover", "soft rock", "groovy bass", "strummed electric guitar", "mellow electric guitar melody", "reverberant rimshot", "shimmering cymbals", "sizzling high pitched synth pad", "emotional", "passionate", "funky"] | 4 | 4M_k01zIbVM | 561 | |
5 year old singing Taylor Swift and playing custom made Taylor guitar | The low quality recording features a raw innocent girl vocal singing over sloppy acoustic rhythm guitar chords. It sounds passionate and the recording is noisy and in mono. | 2011-04-05T22:28:53Z | txfire76 | this is my 5 year old singing a Taylor Swift song and playing the Taylor guitar I made for her sister. | ["Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument", "Child singing"] | ["low quality", "mono", "noisy", "raw innocent girl vocal", "sloppy acoustic rhythm guitar", "passionate"] | 4 | 5pIdH6p3kuo | 696 | |
How to play acoustic guitar songs classic rock style with new rhythm patterns lesson super easy! | The low quality recording features a tutorial that contains a flat male vocal talking over acoustic guitar strummed chords. The recording is noisy and in mono. | 2010-05-03T19:03:13Z | rockongoodpeople | http://www.david-lessons.com/egi/beginner_strumming.html Click the link for a free video lesson where you will learn six critical tips to exceptional strumming. You will also learn five amazing strum patterns that can be utilized for countless songs and also receive a killer free eBook from Next Level Guitar. And check out our full on video instructional website at http://www.nextlevelguitar.com - its a full on structured curriculum for all level players and all styles of music - FREE 3-day all access site pass on the home - so check out the site and give it a good test drive - enjoy! Questions? - email us at thenextlevelguitar@yahoo.com Facebook - https://www.facebook.com/pages/Free-Guitar-Lessons-From-Next-Level-Guitar/162335850468702?fref=ts How to play acoustic guitar songs classic rock style with new rhythm patterns lesson super easy! - In this video we teach a very easy beginner chord progression in a classic rock style of many bands from that classic rock era. We also teach some new strum patterns broken down into easily digestible pieces. Its easy, fast and fun - with strum patterns and chord close ups. | ["Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Speech", "Plucked string instrument"] | ["low quality", "noisy", "mono", "flat male vocal", "acoustic guitar strummed chords", "tutorial"] | 4 | 8UhdwnsckJ8 | 922 | |
Como tocar Yo Quisiera REIK en Guitarra FACIL Tutorial Guitarra Acordes y ritmo clase | The low quality recording features an acoustic rhythm guitar playing over a pop song played on playback in the background. It sounds joyful and happy, while the recording is in mono and noisy. | 2014-09-14T00:30:26Z | guitarraviva2 | Como tocar Yo Quisiera REIK en Guitarra facil Tutorial Guitarra tutorial y clase Acordes y ritmo suscríbete: http://goo.gl/Ldrmr5 vídeo de la Clase: http://youtu.be/QBujO3gJQmM cursos de guitarraviva : http://www.guitarraviva.com/cursos acústica o criolla eléctrica... en todas las guitarra se puede tocar | ["Country", "Music", "Strum", "Bluegrass"] | ["low quality", "playback", "pop", "passionate male vocal", "snappy snare", "synth pad", "acoustic rhythm guitar", "noisy", "mono", "joyful", "happy"] | 4 | Aro-HcWNsHI | 1175 | |
Here Comes the Sun: Beatles on the Autoharp: Hal Weeks | The low quality recording features a cover of a rock song and it consists of a passionate male vocal singing over an auto harp melody. It sounds passionate, emotional and mellow, despite the fact that the recording is noisy and in mono. | 2014-09-02T00:08:17Z | Hal Weeks | Hal Weeks teaches autoharp in the Denver Colorado area, and also online via Skype. To purchase Digital Downloads and CD's, go to: http://halweeksmusic.bandcamp.com/ | ["Acoustic guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["low quality", "mono", "noisy", "passionate male vocal", "auto harp melody", "passionate", "emotional", "mellow", "cover", "rock"] | 4 | ET7yQfaiF_8 | 1561 | |
Jam Track - Jazzy Funk Blues - Bm7 (rhythm guitar track) | The Low quality recording features a groovy acoustic rhythm guitar melody that occasionally has some audio cuts out in the stereo image - making it sound unbalanced. | 2013-11-28T08:13:31Z | Randy Struble Backing Tracks | A play on the Bm7 chord in a funk, jazz, blues kinda way!! Listen! Be inspired! Create! Improvise! Enjoy!! You can DOWNLOAD this and any of my other Jam/Backing Tracks @ https://bluegrassbackingtracks.bandcamp.com/track/jam-track-jazzy-funky-blues-bm7-rhythm-guitar-track Thanks for using a Backing Track by Randy Struble Produced with CyberLink PowerDirector 10 | ["Blues", "Funk", "Guitar", "Jazz", "Acoustic guitar", "Music", "Strum"] | ["unbalanced stereo", "audio cutout", "groovy acoustic rhythm guitar melody", "low quality"] | 4 | VOWGbyg4KZY | 2998 | |
TC ELECTRONIC / チューナー PolyTune2 Noir | The low quality recording features an electric guitar changing pitch as it is being tuned, string by string. The recording is very noisy. | 2014-12-04T01:45:42Z | サウンドハウス | http://www.soundhouse.co.jp/products/detail/item/197304/ #サウンドハウス #チューナー #TCELECTRONIC #Polytune2NOIR #PolyTuneシリーズ #バッファー #エフェクター #チューニング #ギター #ベース #フットペダル #スタジオ #ライブ #音家 | ["Guitar", "Music", "Strum", "Electronic tuner", "Plucked string instrument"] | ["low quality", "noisy", "electric guitar tuning", "pitch changing"] | 4 | VjbRot21Hq0 | 3025 | |
Fender Princeton chorus | The low quality recording features an emotional electric guitar melody. The recording is noisy and in mono as it was probably recorded with a poor quality microphone. | 2011-11-07T02:12:15Z | TheGuitarOutlet | Fender Princeton chorus | ["Guitar", "Music", "Musical instrument", "Steel guitar, slide guitar", "Chorus effect", "Strum", "Plucked string instrument"] | ["low quality", "mono", "noisy", "emotional electric guitar melody"] | 4 | WjPHxUtF9go | 3131 | |
AQUALUNG JETHRO TULL : 70's Acoustic Guitar Cover : REFLECTIVE STYLE | The low quality recording features a cover of a rock song and it consists of acoustic rhythm guitar and nasal, echoing male vocals. The recording is noisy and in mono and it sounds emotional. | 2014-08-10T10:43:37Z | STePH SANCiA | My REFLECTIVE acoustic guitar cover of Aqualung by Jethro Tull released in 1971 with the 6 leading guitar notes that most folks only have to hear the once to know it "IS" Aqualung and 6 notes that would launch me into a musical hyper drive. But today I've opted for an off key reflective acoustic version and have NOT adhered to the original format regarding lyrics and verse and have done a Steph Style tribute to Jethro Tull. | ["Country", "Music", "Strum"] | ["rock", "cover", "low quality", "nasal echoing male vocal", "acoustic rhythm guitar", "noisy", "emotional", "mono"] | 4 | XvyaEbEpAMc | 3237 | |
Tìm lại bầu trời - hướng dẫn guitarist CHop Bi (phần 2 - chơi mẫu) | The low quality song features a cover of a ballad song and it consists of arpeggiated acoustic guitar melody and passionate male vocal singing over it. The recording is very noisy and in mono, like it was recorded with a phone, but regardless it sounds emotional and passionate. | 2012-03-10T11:35:16Z | thachsungabc | Lớp guitar - CLB nghệ thuật trẻ Hà Nội - link: http://enbac.com/Ha-Noi/Tong-hop/p1174061/Lop-guitar-CLB-nghe-thuat-tre-chieu-sinh-Thong-bao-chuong-trinh-tang-dan-guitar-cho-hoc-vien-moi.html | ["Country", "Acoustic guitar", "Music", "Steel guitar, slide guitar", "Strum"] | ["low quality", "arpeggiated acoustic guitar melody", "noisy", "passionate male vocal", "cover", "ballad", "passionate", "emotional", "mono"] | 4 | cOgNXgF21u4 | 3702 | |
Top 30 Indie Folk and Acoustic (Playlist #5) | The low quality recording features an indie folk song that consists of wide harmonizing male vocals and acoustic rhythm guitar. In the second half of the loop, the lead female vocal appears, creating a perfect harmony with the previously mentioned male vocals. It sounds passionate, emotional and sad. | 2014-02-28T23:48:23Z | Indie & Folky Me | Indie Folk Playlist of march 2014 by the Indie and Folky Me Team Website: http://IndieFolkyMe.tk Follow us on twitter : @IndieFolkyMe Join us on facebook : https://www.facebook.com/IndieFolkyMe Photo by Antsa Rvl (Fickr) : http://www.flickr.com/people/10663187... Go here to watch the EXCLUSIVE Top 20 Indie Pop Charts : http://t.co/Isqtvo2FQ5 TRACKLIST Fall At Your Feet - Boy & Bear Just For Now - Cloud Control Where We Gonna Go From Here - Mat Kearney More Than Life - Whitley Message - Xavier Rudd Big Black Car - Gregory Alan Isakov Wolves - The Accidental Something Better - Ecclectic Approach Horses - The Be Good Tanyas Follow Fires - Matthew & The Atlas Move mountains - Roo Panes Without You - Keith Urban Night Bus - Lucy Rose David - Noah Gundersen The Romance Of Wolves - Roma Di Luna Send Me On My Way - Rusted Root Stereo Heart - Collin Mcloughlin Willow Tree March - THe Paper Kites Where Is My Mind - Tramped By Turtles Girl - Lovedrug Riverbanks - Charlie Simpson Sunday best - Augustana The Story I Heard - Blind Pilot Karen O - The Moon Song People - Sharon Nutzati Hidden Edelweiss - Spark Alaska Always Remember Me - Ry Cuming ft Sara Bareilles Worry - Rhodes Rosemary - Ghost & Gale Sons & Daughters - Allman Brown ft Liz Lawrence Bonus: I Lived - One Republic * Copyright Disclaimer * Under Section 107 of the Copyright Act 1976, allowance is made for "fair use" for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favor of fair use." | ["Folk music", "Acoustic guitar", "Music", "Independent music", "Song", "Strum", "Plucked string instrument"] | ["low quality", "wide harmonizing male vocals", "indie folk", "acoustic rhythm guitar", "lead female vocal", "passionate", "emotional", "sad"] | 4 | hTlIqICkbW8 | 4110 | |
The Entertainer (S.Joplin) Advanced Slide Guitar Version - Marc Athlan | The low quality recording features a cover of a ragtime song and it consists of arpeggiated acoustic guitar melody. The recording is noisy, but it sounds happy and fun regardless. | 2014-07-27T15:55:10Z | Marc Athlan | This is an attempt to adapt the famous Scott Joplin tune (whole version) on slide guitar. If it has been said that it's a challenge to play this song on guitar, it's even more challenging on slide guitar ! I tried to be as close as possible to the original version. Played on resonator guitar with Diamond Bottleneck (The BEST in the world !). Thanks to Nathalie Athlan, Ian McWee and others at Diamond Bottlenecks.com. Thanks to Keni Lee Burgess for having inspired me with his video (https://youtu.be/X0VL_js9sWs) to do my version of this tune. Thanks for watching ! | ["Banjo", "Guitar", "Music", "Mandolin", "Musical instrument", "Strum", "Plucked string instrument"] | ["low quality", "cover", "arpeggiated acoustic guitar melody", "noisy", "happy", "fun", "ragtime"] | 4 | iCIa_pmLDqs | 4168 | |
vicente de montpellier | The low quality recording features a cover of a regional Mexican song and it consists of a passionate male vocalist singing over acoustic rhythm guitar. There are some crowd chattering and asphalt sounds in the background. The recording is noisy, in mono and it sounds passionate and emotional. | 2009-11-09T14:59:52Z | bentana100 | aqui el vicente de montpelier cantando en su barrio monteberou | ["Acoustic guitar", "Music", "Steel guitar, slide guitar", "Strum", "Plucked string instrument"] | ["low quality", "mono", "regional mexican", "passionate male vocal", "cover", "noisy", "acoustic rhythm guitar", "crowd chattering", "asphalt sounds", "low quality", "emotional", "passionate"] | 4 | lI8aGjIb8Jg | 4389 | |
"Dueling Banjos" - Beginning Banjo Lesson (With Tab) | The low quality recording features an arpeggiated and strummed banjo melody. The recording is noisy, in mono and the melody sounds happy and fun. | 2012-04-02T18:31:36Z | happybanjodude | Link to tab: http://www.happybanjodude.com Tab for Part 2 available now! Follow me on twitter: http://www.twitter.com/happybanjodude | ["Banjo", "Music", "Mandolin", "Musical instrument", "Strum", "Plucked string instrument"] | ["live performance", "noisy", "arpeggiated and strummed banjo melody", "happy", "fun", "low quality", "mono"] | 4 | srEOZzpdhs8 | 4983 | |
Breathing Underwater - Metric (COVER) | The low quality recording features a sad soft rock song that consists of an acoustic rhythm guitar chord progression over which the reverberant female vocalist sings. The recording is very noisy and it sounds sad and emotional. | 2012-09-02T00:44:27Z | Hustlerae | greg's piano playing made it in the background of this video. thanks gary. http://www.youtube.com/watch?v=m2cDFU_Q5Z8 https://www.facebook.com/pages/Rae-Corcoran/202694913206278 | ["Country", "Acoustic guitar", "Music", "Steel guitar, slide guitar", "Strum", "Plucked string instrument"] | ["noisy", "low quality", "reverberant female vocal", "sad acoustic rhythm guitar chord progression", "soft rock", "sad", "emotional"] | 4 | w-YAUcPl-HU | 5225 |
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;