scotrail

Custom SQL query returning 8 rows (hide)

with phrases as ( select key, value from json_each('["' || replace(:terms, ',', '","') || '"]') ), matches as (select phrases.key, phrases.value, ( select File from announcements where announcements.Transcription like '%' || trim(phrases.value) || '%' order by length(announcements.Transcription) limit 1 ) as File from phrases ), results as ( select key, announcements.Transcription, announcements.mp3 from announcements join matches on announcements.File = matches.File order by key ) select 'Combined sentence:' as mp3, group_concat(Transcription, ' ') as Transcription, -1 as key from results union select mp3, Transcription, key from results order by key

Query parameters

terms