musiccaps

Custom SQL query returning 1 row (hide)

select video, youtube_link, musiccaps_caption, youtube_published, youtube_channel, youtube_description, musiccaps_names, musiccaps_aspects, musiccaps_author, youtube_id, musiccaps_rowid from musiccaps_details where :p0 in (select value from json_each([musiccaps_details].[musiccaps_aspects])) and :p1 in (select value from json_each([musiccaps_details].[musiccaps_aspects])) and :p2 in (select value from json_each([musiccaps_details].[musiccaps_names])) and musiccaps_rowid in (select rowid from musiccaps_fts where musiccaps_fts match escape_fts(:search)) limit 101

Query parameters

This data as json, CSV

video	youtube_link	musiccaps_caption	youtube_published	youtube_channel	youtube_description	musiccaps_names	musiccaps_aspects	musiccaps_author	youtube_id	musiccaps_rowid
	Theremin player Armen Ra	Someone is playing an acoustic piano repeating a phrase of a chord with single notes in the mid-range while a voice-like synthesizer sound is being played in a higher register. The instrument does sound like a female opera singer with a lot of vibrato. This song may be playing in a theater.	2006-06-28T06:42:04Z	Klara Palotai	Armen Ra at a benefit concert on April 4, 2006 at the Angel Orensanz Foundation in New York	["Music", "Theremin"]	["piano/opera", "acoustic piano", "synthesizer", "vocal sound", "amateur recording"]	6	Wd5l_FHGWfE	3112