musiccaps_details (view)

1 row where musiccaps_aspects contains "movie music", musiccaps_aspects contains "slow tempo" and musiccaps_names contains "Lullaby"

✎ 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
Lullaby for a Princess Professionally recorded music featuring an intimate female vocal, delicate piano, and orchestral string accompaniment. The tempo is slow, the production is high fidelity and the mood is an introspective one. Would be perfect in an animated kids movie. 2012-09-18T11:46:19Z ponyphonic Just as she promised, Luna stood her ground and refused to lower the moon. Faced with the collapse of the delicate order they had worked so hard to build, Celestia was forced to do the unthinkable. Unable to fully utilize of the elements of harmony by herself, she used a fraction of their power to imprison her sister in the moon, saving the world, but at a terrible cost. The harmonic bond between sun and moon was broken forever; now, the elements lie dormant, awaiting new bearers. In time, the darkness in Luna's heart will begin to wane, but with it, so will the sealing spell that holds her in the moon. In a thousand years, she will escape, weakened but still powerful, and the world can only hope that new ponies will be found who can wield the elements and save Luna from herself. But Celestia's thoughts turn again to the present. It will be centuries before she can see her sister again, and for that, she blames herself. Surely she had seen the signs? She thinks over and over of the things she might have said and done differently. But despite her own sadness, she also longs to reach out and comfort Luna, and in this mix of bitterness, tenderness, and very distant hope, she looks to the moon and begins to sing. -------------------------------------------------------- High-quality (and remastered!) download: http://ponyphonic.bandcamp.com/ Well... it's been a while, and in light of the 5 (!) month hiatus, I wanted to make sure the wait was worth it. I've taken a few of the comments on "The Moon Rises" into consideration: this song is quite a bit longer and it features a female vocal! *yay* Please welcome the newest member of ponyphonic: Christina! -------------------------------------------------------- Intro: Fate has been cruel and order unkind How can I have sent you away? The blame was my own; the punishment, yours The harmony's silent today But into the stillness I'll bring you a song And I will your company keep Till your tired eyes and my lullabies Have carried you softly to sleep Verse 1: Once did a … ["Music", "Lullaby"] ["high fidelity production", "professionally recorded", "movie music", "intimate female vocal", "fairy tale", "delicate piano", "slow tempo", "orchestral string accompaniment", "introspective", "animated kids movie"] 8 H4tyvJJzSDk 1773

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;