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 :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
	Surp Sarkis-Aram Asatryan	The song is a middle eastern pop ballad with a singer who sounds emotional and reflective. The song is at a medium tempo. There is a violin embellishment, piano, and some relaxed pop drumming. This song would be heard in a middle eastern movie.	2007-08-04T05:32:54Z	marish123		["Folk music", "Music"]	["middle eastern pop music", "ballad", "romantic", "relaxed", "emotional middle eastern male singer", "simple pop style drumming", "violin", "piano", "electric bass guitar"]	3	chw8sAKOM5k	3732