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_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
	The Lone Bellow "Slip Slidin' Away"	This is an acoustic ballad that is sung in a melancholic manner by two male vocalists and a female vocalist. There is an acoustic guitar in the background playing a simple tune. The tempo and the general atmosphere of the song is relatively calm. The music could be played at a coffee shop in the background.	2015-04-27T14:02:56Z	Ron Paris	The Lone Bellow doing a fantastic cover of Paul Simon's "Slip Slidin' Away". Recorded live at Virginia Arts Recording Studio in Charlottesville VA. A special Corner Lounge for 106.1 WCNR. Video by Ron Paris.	["Music", "A capella"]	["acoustic guitar", "male vocal", "female vocal", "melancholic", "calming", "downtempo", "mellow"]	9	8r1y_Bz4VfQ	955