🔀 How one line was translated

t (s)	English	es · fr · de · ru…
23.000	You're a jerk, Thom.	de=Du bist ein Vollid…
25.000	Look Celia, we have t…	fr=Celia, on doit pou…
27.000	...you have your robo…	fr=...toi t'as la rob…
30.800	Why don't you just ad…	fr=Pourquoi est ce qu…

Run this query → no server · no download · no account

caviri.github.io/rete

Run this query in the playground → 12 rows · 105 ms · no server, no download — the query runs in your browser.

The query

PREFIX su: <https://w3id.org/rete/subtitles#> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> SELECT ?time ?english (GROUP_CONCAT(CONCAT(?lg,"=",?tx); separator=" · ") AS ?translations) WHERE { ?line a su:Line ; su:start ?time ; rdfs:label ?english ; su:text ?tx . BIND(LANG(?tx) AS ?lg) FILTER(?lg IN ("es","fr","de","ru","ja")) } GROUP BY ?line ?time ?english ORDER BY ?time LIMIT 12

rete playground · documentation · github.com/caviri/rete