query-e198a566c890574bc6ba5e9e6bbf6ae9

rq turtle/ttl

Tatortfolgen mit anderem deutschen als englischem Label

Use at

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX v: <http://www.wikidata.org/prop/statement/>
SELECT ?film ?ordinal ?deLabel ?enLabel WHERE {
  ?film p:P179 ?series . ?series v:P179 wd:Q689438 . ?series pq:P1545 ?ordinal
  OPTIONAL{?film rdfs:label ?deLabel . FILTER(lang(?deLabel) = "de")}
  OPTIONAL{?film rdfs:label ?enLabel . FILTER(lang(?enLabel) = "en")}
  BIND (COALESCE(STR(?deLabel)=STR(?enLabel),FALSE) AS ?comp)
  FILTER(?comp=FALSE)
}
ORDER BY DESC(xsd:integer(?ordinal))

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v7("?comp") v4("?deLabel"):::projected v3("?enLabel"):::projected v5("?film"):::projected v1("?ordinal"):::projected v6("?series") c6(["wd:Q689438"]):::iri f0[["?comp = 'false^^xsd:boolean'"]] f0 --> v7 v5 --"p:P179"--> v6 v6 --"p:statement/P179"--> c6 v6 --"p:qualifier/P1545"--> v1 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v5 -."rdfs:label".-> v4 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v5 -."rdfs:label".-> v3 end bind1[/"str(?deLabel) = str(?enLabel)'false^^xsd:boolean'"/] v4 --o bind1 v3 --o bind1 bind1 --as--o v7