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 "musiccaps_author" = :p1 and :p2 in (select value from json_each([musiccaps_details].[musiccaps_names])) 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
	Ouverture de l'opéra-ballet Pygmalion	This is a French opera/opera-ballet music piece. There is no singer in this piece. The only instrument that is being played is a harpsichord. The sound and the tunes are reminiscent of the medieval era. There is a theatrical feel to the piece. This piece could be used in the soundtrack of a historical drama that takes place in the medieval era. It could also be used as an accompaniment piece for a theater play or a ballet dance performance.	2011-07-25T21:59:45Z	Jory Vinikour	Jean-Philippe Rameau, composer (transcribed by Claude Balbâtre) Jory Vinikour, harpsichord French double harpsichord by Cucchiara and Pierce Recorded April 13, 2011 in Shaker Heights, Ohio USA	["Harpsichord", "Keyboard (musical)"]	["french opera", "opera-ballet", "no singer", "instrumental", "harpsichord", "medieval sounding", "theatrical", "ballet dance"]	9	Iz611KubW70	1957