musiccaps_details (view)

1 row where musiccaps_aspects contains "no percussion" and musiccaps_aspects contains "ukele melody"

✎ View and edit SQL

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
Pancaked Bun of Braids | Cute Girls Hairstyles A female singer sings this song. This section is probably a song fade as only the last bit of the word a can be heard with a mellow ukelele riff. This is followed with some sounds of something hitting a hard surface and then silence. 2014-07-21T00:12:21Z Mindy McKnight If any of you would like to follow this daughter, Kamri, on Instagram {a parent-run account} you can do so at http://www.instagram.com/kamrinoel! * ~ * ~ * ~ * ~ * ~ * You've all loved our Rope Twisted Bun from a few months back {http://youtu.be/jeMFXP6BCiQ}, so we thought it would be fun to show you another of our adorable bun hairstyles! This one is called a Pancaked Bun of Braids! This updo uses a bun maker over a ponytail, and is exactly what the name states... a bun full of pancaked braids! There is a trick to getting this bun just right, and in the video I show you several tips on how to do this. To see your recreation featured below this video in our CGH App, feel free to tag your own photos of this hairstyle on Instagram with: #CGHBunOfBraids Enjoy! 😘 - Mindy Items Needed: Brush, rat-tail comb, spray bottle, bun maker, 1 small hair elastic, 6-8 hair pins, hairspray and accessory {if desired}. Time Requirement: 10-12 minutes Skill Level: Medium To see step-by-step instructions and more photos of this style, please visit... http://www.cutegirlshairstyles.com * ~ * ~ * ~ * ~ * We post a new hairstyle tutorial every Sunday night {7pm CST}! So, please don't forget to subscribe to our YouTube channel... http://bit.ly/VovoC9 Follow CGH on Facebook: http://www.facebook.com/CuteGirlsHairstyles Follow CGH on Twitter: http://www.twitter.com/CuteGirlHair Follow CGH on Pinterest, and see my "Try" board... http://www.pinterest.com/CGHairstyles Follow CGH on Instagram and see unpublished photos of our family: http://www.instagram.com/MindyMcKnight * ~ * ~ * ~ * ~ * Music: "I Adore" by Mindy Gledhill {http://youtube.com/MindyGledhill} iTunes Link: https://itunes.apple.com/us/album/anchor/id384576597?uo=4&at=1l3v7Rs License: Personal emailed permission from Mindy, herself, and her management. ["Music", "Ukulele"] ["female singer", "ukele melody", "silence", "no percussion", "song fade", "dissonant sound", "something hard hitting a surface"] 7 TyMZJqYmrwE 2878

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;