musiccaps: musiccaps_details: 6 rows where musiccaps_author = 3 and musiccaps

6 rows where musiccaps_author = 3 and musiccaps_names contains "Folk music"

descending

youtube_link	musiccaps_caption	youtube_published	youtube_channel	youtube_description	musiccaps_names	musiccaps_aspects	musiccaps_author	youtube_id	musiccaps_rowid
Vamsam - Tamil Serial \| Episode 556 \| 02/05/2015	This is a traditional south asian dance song with a cheerful affect. We have a group of female singers singing in unison - a melody that matches with the one being played on the sitar.	2015-05-02T16:00:00Z	Vision Time Tamil	Will Madan succeed in brainwashing Supriya to get married to him and will Archana be able to stop this marriage in time by arresting Madan for killing Bhoomika? Is Bhoomika really dead or alive?? Keep watching this space for more updates on your favorite serial VAMSAM. Cast: Ramya Krishnan, Sai Kiran, Vijayakumar, Seema, Vadivukkarasi	["Folk music"]	["south asian music", "indian music", "tamil music", "dance", "group female vocals", "sitar", "groovy rhythmic percussion", "cheerful"]	3	5aCDam9_Ps4	671
Bangla Folk Song By Momotaz : Baba Mohiuddin	Along with the vintage south asian vocal performance from an emotive female vocalist, this song features enchanting melodies from the bansuri. For percussion, we have tablas and tambourines. This is a live performance in a concert venue.	2010-04-25T05:46:17Z	S D	Singer : MomoTaz, sang at Baul charity show in 2007.	["Singing", "Folk music", "Music"]	["indian music", "south asian music", "vintage indian music", "classical indian music", "live recording", "live performance", "passionate female vocalist", "tabla", "shaker", "bansuri melody"]	3	GuJdy864xWM	1759
Faraon - Flamenco Rumba_20/11/2011@Barceloan	This is a recording of two flamenco guitarists playing a captivating latin american rhythm. It's upbeat and suitable for dancing. The one guitarist strums chords in the percussive flamenco style, while the other guitarist plays flamenco lead with arpeggios and licks. The performance is live and outside. There is reverb applied to the lead guitar. Both are playing on nylon strings.	2011-11-24T17:50:51Z	Julian Kan	Spanish Guitar - Adrian Roman & Martin Sazandeh's performance at Cathedral, Gothic Quarter, Barcelona	["Folk music", "Flamenco", "Guitar", "Music", "Musical instrument", "Plucked string instrument"]	["live performance", "flamenco guitarists", "acoustic guitar", "nylon string guitar", "latin american music", "upbeat", "energetic", "dance", "reverb"]	3	KChjW89XOF0	2064
Surp Sarkis-Aram Asatryan	The song is a middle eastern pop ballad with a singer who sounds emotional and reflective. The song is at a medium tempo. There is a violin embellishment, piano, and some relaxed pop drumming. This song would be heard in a middle eastern movie.	2007-08-04T05:32:54Z	marish123		["Folk music", "Music"]	["middle eastern pop music", "ballad", "romantic", "relaxed", "emotional middle eastern male singer", "simple pop style drumming", "violin", "piano", "electric bass guitar"]	3	chw8sAKOM5k	3732
schöne arabische musik	This is a middle eastern song with a rapid and intricate accordion melody as the main basis. The song would be suitable as a backing track for a belly dancer. There's a traditional percussion instrument in the background.	2011-06-27T13:50:49Z	ChandaniRani	...	["Folk music", "Music"]	["arabic music", "middle eastern", "accordion", "upbeat", "dance", "belly dance", "intricate percussion", "traditional percussion instruments"]	3	vrNQbCbBlLY	5212
Om Mantra Chant (Meditation Music)	This is a soothing traditional Indian or Eastern song that can be used as music for meditation. It is relaxing and features layered female vocals chanting "om". There is a bansuri melody, some rhythmic tabla playing, and an intermittent manjeera being percussively played.	2015-01-06T09:15:41Z	Dr. Kumar Amit	A serene piece of music for ushering peace around. This 'Om Mantra Chant' does have a very uplifting effect while listening to it during meditation or while achieving some mental silence. The whole performance is as divine as the holy syllable itself. Prominent beats, subtle strings and blows by different Indian musical instruments alleviates the soundstage to a whole ecstatic experience. Blessings ! Album : Meditation Music - Chintan Artist : Ved Prakash Phodani Visit me at : http://www.amitwrites.com Like me at : https://www.facebook.com/amitwritesdotcom Also, subscribe to my channel to receive various upload notifications ! The song here is meant for promotional purpose and I encourage to buy original music at: Amazon: http://amzn.to/14gupjV iTunes India: http://bit.ly/1vXurDv iTunes US: http://bit.ly/14rzmXE iTunes UK: http://bit.ly/1AkbB0P	["Carnatic music", "Mantra", "Chant", "Folk music", "Music", "Sitar"]	["meditation music", "south asian music", "indian music", "tabla", "om chanting", "mantra", "bansuri", "manjeera", "calming", "soothing", "relaxing", "tranquil"]	3	yPou7kokTgA	5406

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;

musiccaps_details (view)

6 rows where musiccaps_author = 3 and musiccaps_names contains "Folk music"

Advanced export