musiccaps_details (view)

1 row where musiccaps_aspects contains "reggae song", musiccaps_names contains "Drum and bass" and musiccaps_names contains "Music"

✎ 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
TWILIGHT CIRCUS DUB SOUND SYSTEM - BINGHI RIDDIM (VARIOUS ARTISTS) This reggae song features a male voice singing the main melody. Another voice is singing in harmony with the main voice. This is accompanied by reggae percussion. A timbale is played on every third count. Jam blocks are also played in the background. The bass plays a funky bassline with a reggae feel. Synth sounds are played in the background. This song can be played in a bar. 2008-07-21T12:16:12Z Ryonik One-riddim album on the Red-Hot 'Binghi Riddim' featuring Jamaican legends Sly Dunbar, Skully & Dean Fraser. Available now on Itunes and http://www.ebreggae.com TRACKLISTING Sugar Minott "Take It Slow" Tampanae "Musical Journey" Lutan Fyah "We Can Make It Work" Gregory Isaacs & Big Star "Touch Not" R.Mony & Johnny Builder "Only Time Will Tell" Daddy Shark "Earth Foundation" Mykal Rose "A Little Bit More" X-Facta "Welcome To The Garrison" Keke-I "Why Do You Fight" Anju Kumbz "Stand Up On Your Feet" Al Pancho & Ken Bob "Last Night" Flourgon "This World" Skully "Binghi Riddim" Check us out at: http://www.myspace.com/twilightcircus http://www.twilightcircus.com 'Wrestles with history's titans & leaves the ring commanding 'nuff respect' - SPIN Mag / Jeff Chang 'Among the best of any current reggae producers in the World' - Tape Op Mag / Larry Crane Ryan Moore has participated in nearly 100 album projects in various genres including work with The Legendary Pink Dots, Skinny Puppy, various Nettwerk Records albums, Sarah McLachlan, The Tear Garden, Keith Levine (P.I.L.), Ted Parsons (Prong), DJ Spooky, Single Gun Theory, Final Cut (Jeff Mills).. The following have worked with Twilight Circus: Sly Dunbar, Robbie Shakespeare, Dean Fraser, Michael Rose (Black Uhuru), Luciano, Mikey General, Big Youth, Skully, Vin Gordon (Bob Marley), Chinna Smith (Ziggy Marley), Eddie 'Tan Tan' Thornton (Aswad), Buttons (UB40), Ansel Collins, Style Scott (Dub Syndicate), Bobby Ellis (Studio One), Admiral Tibet, Jah Stitch, Sugar Minott, Queen Ifrica, Fred Locks, Max Romeo, Gregory Isaacs, Mafia&Fluxy, Cevin Key (Skinny Puppy), DJ Spooky, Mad Professor, Mike Pelanconi (Lily Allen), Steven Stanley, Jack Dangers ["Drum and bass", "Music", "Reggae"] ["reggae song", "male voice", "vocal harmony", "reggae drums", "funky bass", "moderate tempo", "shaker", "timbale", "jam block"] 0 s1JHUf3Q_F0 4911

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;