musiccaps

Custom SQL query returning 2 rows (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 :p3 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
	Sarah Brightman performing 'Music Of the Night' at Queen Mother's 90th Birthday Gala 1990	Dramatic female opera singer accompanied by orchestra and brass and cymbal crash.	2010-06-23T02:57:11Z	tapesalvage	Sarah Brightman performing 'Music Of the Night' from Phantom Of the Opera at Queen Mother's 90th Birthday Gala 1990	["Singing", "Music", "Opera", "Classical music"]	["opera", "dramatic", "cymbal crash", "orchestral brass", "orchestral accompaniment"]	8	XUzaEsoOlWQ	3187
	Amira Willighagen - O Mio Babbino Caro - Andre Rieu - Maastricht - July 2014	A female opera singer accompanied by an orchestra featuring string bass, harp and string ensemble. It sounds like it was performed in a concert hall. Dramatic.	2014-07-13T11:01:00Z	pa1189j		["Singing", "Music", "Opera"]	["opera", "female singer", "orchestral accompaniment", "string bass", "harp", "string ensemble", "concert hall reverb", "dramatic"]	8	Z0htOHTOtHY	3336