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_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
	Daisy (Hey) Music Video (Eng sub)	This is an emotional Japanese pop ballad. The singer has a light, airy and gentle voice that she uses to sing over the deep and full piano arpeggios. The song has a calming and emotional effect.	2012-12-17T13:51:26Z	pachamadresita	✿⊱╮For those we lose and love..	["Music", "Sad music"]	["piano arpeggio", "gentle ballad", "soothing ballad", "calm", "beautiful", "emotional", "love song", "airy soothing female voice", "gentle female vocal", "japanese pop"]	3	2M-CFCo-rkY	357