musiccaps_details (view)

1 row where musiccaps_aspects contains "acoustic guitar", musiccaps_author = 9 and "youtube_published" is on date 2013-10-05

✎ 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
Phil Laeger — Let Your Glory Shine (Lyric Video) This is a Christian gospel music piece. There is a male vocalist singing melodically in the lead. The tune is being played by the acoustic guitar and the piano while the bass guitar is following with the root notes. The rhythm is played with brushes on the acoustic drums. The atmosphere is mellow. This piece could be playing in the background at Christian religious events. 2013-10-05T08:13:57Z Phil Laeger Lyric video for "Let Your Glory Shine", from the album Return. Lyrics below: All these dreams I believe You have placed inside of me Even what's good can be abused All this time I believed You'd make something great of me Seems my focus shifted Now I want You to know All I want is for You to be lifted high Be lifted high Hide me behind Your cross, Lord I want You to be seen and lifted high Hide me now and let Your glory shine Shine brighter Hide me now and let Your glory shine So much praise of mine is so pretentious Take my quote unquote good intentions Take all I say that I believe Make it real, make it so unquestionable Make Your mark on my life so un-second-guess-able Like those hands and feet Scarred by love for eternity Oh, Love, make Your mark in me Hide me behind Your cross, Lord I want You to be seen and lifted high Hide me now and let Your glory shine Shine brighter Hide me now and let Your glory shine Author of my faith Lord, let Your glory increase And as Your story unfolds in me I know I am but one thought You have conceived Just one word on the pages of Your history Hide me behind Your cross, Lord I want You to be seen and lifted high Hide me now and let Your glory shine Shine brighter Hide me now and let Your glory shine ------------------------ words & music by Phil Laeger © 2013 Weathered Music www.phillaeger.com ["Music", "Independent music"] ["gospel", "christian", "male vocal", "melodic singing", "acoustic guitar", "bass guitar", "piano", "acoustic drums", "mellow", "religious"] 9 APSbmhJam74 1112

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;