musiccaps_details (view)

2 rows where musiccaps_aspects contains "glam metal"

✎ 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
Extreme - More Than Words - piano cover This is a piano cover of a glam metal music piece. The piece is being played gently on a keyboard with a grand piano sound. There is a calming, relaxing atmosphere in this piece. It could be playing in the background at a coffee shop. 2012-06-04T15:15:36Z vkgoeswild You can learn how to play some of my arrangements on flowkey: http://tinyurl.com/p3m7e37 https://www.facebook.com/pages/Viktoriya-Yermolyeva-vkgoeswild/134411767159 my FB page, with gigs announcements and stuff like that. another of my favorite songs. Very tough to cover though. I hope you'll enjoy! "It is built around acoustic guitar work by Nuno Bettencourt and the vocals of Gary Cherone (with harmony vocals from Bettencourt). Released in 1990 on the album Extreme II: Pornograffiti, the song marked a departure from the funk metal that had permeated the band's style previous to its release. The song was described by Bettencourt as a song warning that the phrase "I love you" was becoming meaningless: "People use it so easily and so lightly that they think you can say that and fix everything, or you can say that and everything's OK. Sometimes you have to do more and you have to show it -- there's other ways to say 'I love you.'" ["Electric piano", "Keyboard (musical)", "Piano"] ["piano cover", "glam metal", "keyboard", "piano sound", "gentle playing", "calming", "relaxing"] 9 R5KBk76b9HE 2667
Poison- I Won't Forget you Lyrics This is a glam metal/heavy metal ballad. There is a male vocal and male back vocals singing melodically. The melody is being played on an electric guitar with a chorus effect applied alongside a bass guitar. The rhythmic background consists of a rock acoustic drum beat.The atmosphere is both hard-hitting and sentimental at the same time. This piece could be playing in the background of a rock/metal bar. It could also be included in the soundtrack of an 80s themed romance movie. 2009-08-26T19:16:57Z GenreLyrics Thank you MaSSaChRoNiC for suggesting this song to me. ["Music", "Roll", "Rock and roll"] ["glam metal", "heavy metal", "ballad", "male vocal", "male back vocals", "electric guitar", "bass guitar", "acoustic drums", "hard-hitting", "sentimental", "medium tempo"] 9 uiHyWdYkBvY 5133

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;