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_aspects])) and :p3 in (select value from json_each([musiccaps_details].[musiccaps_aspects])) and :p4 in (select value from json_each([musiccaps_details].[musiccaps_aspects])) and "musiccaps_author" = :p5 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
	Cecilia Bartoli's Operatic Vocal Range (in about a minute!)	This piece is a compilation of an opera singer's high-pitched singing that shows how high of a pitch she can reach. For the most part, she is holding a single high note as the strings in the orchestra provide the harmonic background.	2010-12-23T17:05:25Z	SsteinwayS	US: http://amzn.to/2itVgnr Canada: http://amzn.to/2iRUtNK Cecilia Bartoli’s vocal range: from low E below middle C to high E-flat above soprano high C!	["Singing", "Music", "Opera"]	["opera", "classical", "orchestra", "strings", "female vocal", "high-pitched singing", "compilation", "vocal range"]	9	AElgGuUSSKE	1088