query-105bf6e8eecbbac845815f78bcce2016
Tatort episode labels
Use at
- https://query.wikidata.org/sparql
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX v: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
SELECT ?film ?ordinal ?title ?deLabel ?enLabel WHERE {
?film p:P179 ?series . ?series v:P179 wd:Q689438 . ?series pq:P1545 ?ordinal . FILTER(xsd:integer(?ordinal)<10000)
OPTIONAL{?film wdt:P1476 ?title}
OPTIONAL{?film rdfs:label ?deLabel . FILTER(lang(?deLabel) = "de")}
OPTIONAL{?film rdfs:label ?enLabel . FILTER(lang(?enLabel) = "en")}
}
ORDER BY DESC(xsd:integer(?ordinal))
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v3("?deLabel"):::projected
v2("?enLabel"):::projected
v4("?film"):::projected
v1("?ordinal"):::projected
v5("?series")
v6("?title"):::projected
c6(["wd:Q689438"]):::iri
f0[["http://www.w3.org/2001/XMLSchema#integer(?ordinal) < '10000^^xsd:integer'"]]
f0 --> v1
v4 --"p:P179"--> v5
v5 --"p:statement/P179"--> c6
v5 --"p:qualifier/P1545"--> v1
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v4 -."p:direct/P1476".-> v6
end
subgraph optional1["(optional)"]
style optional1 fill:#bbf,stroke-dasharray: 5 5;
v4 -."rdfs:label".-> v3
end
subgraph optional2["(optional)"]
style optional2 fill:#bbf,stroke-dasharray: 5 5;
v4 -."rdfs:label".-> v2
end