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 "musiccaps_author" = :p3 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
	Iran folk music & opera by soprano, Darya Dadvar	This is a Persian folk music piece in the style of an opera. The female vocalist is singing at a high-pitch in a manner that is filled with emotion. There is a piano in the background that occasionally supports the melody. This is a heart-touching piece. This piece could be used in the soundtracks of tragedy/drama movies, especially the ones that take place in the Middle East. It could also be used in a video game to create an aura of suspense and anticipation.	2006-10-18T19:14:45Z	darya dadvar	A blend of opera and traditional music of Iran,Guilan, Khorasan,... Hotel Negresco, Nice, France, 2003	["Music", "Opera"]	["persian folk music", "opera", "female vocal", "high-pitch singing", "piano", "emotional", "heart-touching", "goosebumps"]	9	ow7xqVk8Wjs	4668