musiccaps_details (view)
1 row where musiccaps_aspects contains "christian pop", musiccaps_aspects contains "gratitude", musiccaps_aspects contains "sentimental" and musiccaps_author = 7
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 |
---|---|---|---|---|---|---|---|---|---|---|
God Must be Loved / Rich Moore - Praise Song / Lyrics | A male vocalist sings this emotional Christian Worship Song. The tempo is medium with energetic drumming,harmonious electric guitar , acoustic Guiana keyboard accompaniment and subtle bass. The song is a soft, mellow, emotional, pensive, devotional, Christian music. | 2014-01-15T17:06:38Z | Christian Sermons and Audio Books | God Must be Loved / Rich Moore - Praise Song / Lyrics My original Christian music facebook page: https://www.facebook.com/richmoorechristianmusic I am a singer, guitarist, and songwriter. This is a new original contemporary Christian song I recently wrote and recorded. May those who listen find it a great blessing, to the glory of the Lord Jesus Christ...praise God. (Music and video owned and copyrighted by stack45ny) My Original Contemporary Christian Songs (playlist): http://www.youtube.com/playlist?list=PLzOwqed_gET0JkRfjd1-xm_BGrCYaJqVR Christian Praise and Worship Songs playlist: https://www.youtube.com/playlist?list=PL4D0533BC00E40EA4 Matthew 10:34 "Do not think that I came to bring peace on earth. I did not come to bring peace but a sword. 35 For I have come to 'set a man against his father, a daughter against her mother, and a daughter-in-law against her mother-in-law'; 36 and 'a man's enemies will be those of his own household.' 37 He who loves father or mother more than Me is not worthy of Me. And he who loves son or daughter more than Me is not worthy of Me. 38 And he who does not take his cross and follow after Me is not worthy of Me. -~-~~-~~~-~~-~- Please watch: "A Call to Separation - A. W. Pink Christian Audio Books / Don't be Unequally Yoked / Be Ye Separate" https://www.youtube.com/watch?v=CBDg7u21cKY -~-~~-~~~-~~-~- | ["Christmas music", "Jingle (music)", "Music", "Psychedelic rock", "Rock music", "Song", "Soul music"] | ["male vocalist", "medium", "emotional", "sentimental", "soft", "subtle bass", "mellow", "pensive", "poignant", "repentance", "gratitude", "worship", "reverence", "church", "humility", "tempo", "slick drumming", "acoustic guitar harmony", "keyboard accompaniment", "christian song", "christian gospel music", "christian praise and worship", "christian worship song", "gospel music", "christian pop", "christian rock", "electric guitar", "christian music"] | 7 | RceCfg1FQq4 | 2713 |
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;