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 "musiccaps_author" = :p2 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
	Aleko - Aria Of Zemfira	The low quality recording features a female opera vocalist singing over sustained strings. There is tinny metallic percussive foley at one point in the loop. It is a bit quiet, but it also sounds dynamic, emotional and passionate.	2010-12-11T22:14:16Z	Joe Fenech		["Music", "Opera"]	["low quality", "orchestra", "opera", "female opera vocal", "sustained strings section", "quiet", "metallic percussive foley", "passionate", "emotional", "dynamic"]	4	bxoJOfGx3hM	3668