musiccaps_details (view)

1 row where musiccaps_aspects contains "synthesizer pad", musiccaps_names contains "Christian music" and musiccaps_names contains "Singing"

✎ 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
Katy Perry - Faith Won't Fail (Lyrics On Screen Video HD) Ex Christian Artist Synthesizer pads are playing long chords with a lot of reverb creating a dreamy and relaxing atmosphere. A piano is sprinkling notes on top while a highly processed voice sample is singing a melody that uses a ping pong effect to move to both sides of the speakers. This song may be playing in between two songs in a DJ set to reset the atmosphere. 2011-08-31T07:17:22Z CHRISTIAN MUSIC Artist: Katy Hudson (Katy Perry) Song: Faith Won't Fail Album: Katy Hudson (2001) Genres: Pop, Pop rock, Christian pop Label: Red Hill Records Katy Hudson is the eponymous, gospel rock debut studio album by American singer-songwriter Katy Hudson, who would later adopt the familiar stage name of Katy Perry. It was released on October 23, 2001, as a Christian music album by Red Hill Records two days before her seventeenth birthday. This would be her only gospel album before she made the switch to mainstream pop music. Hudson is credited as an author of four songs on the album and as a co-author on the remaining six. "Trust in Me" was the lead single. The album received a favorable review from Russ Breimeier of Christianity Today, who applauded her voice and songwriting and called her "a remarkable young talent emerging, a gifted songwriter in her own right who will almost certainly go far in this business". Production and distribution of the album ceased after Red Hill Records folded at the end of 2001. Luckymann's Music High Quality (HQ) & High Definition (HD) Pop rock Cristian en Inglés ["Singing", "Christian music", "Music", "Pop music"] ["atmospheric", "synthesizer pad", "vocal sample", "acoustic piano", "slow tempo", "relaxing"] 6 YE2rN3xknlk 3267

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;