query-62c615686323e80c7f4d5e817577550d

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 ?originalTitle ?germanTitle (GROUP_CONCAT(DISTINCT(?directorName);separator=", ") AS ?director) (SAMPLE(?duration) AS ?duration) ?imdb ((MIN(?pub)) AS ?publication) WHERE {
    ?film p:P179 ?series .
    ?series v:P179 wd:Q642878 .
    ?series pq:P1545 ?ordinal .
    ?film wdt:P1476 ?originalTitle .
    ?film rdfs:label ?germanTitle . FILTER(lang(?germanTitle) = "de") .
    ?film wdt:P345 ?imdb .
    OPTIONAL{?film wdt:P57 ?dir . ?dir rdfs:label ?directorName . FILTER(lang(?directorName) = "en")}
    OPTIONAL {?film wdt:P2047 ?duration}
    OPTIONAL {?film wdt:P577 ?pub}
}
GROUP BY ?film ?germanTitle ?originalTitle ?imdb ?ordinal
ORDER BY ASC(xsd:integer(?ordinal))

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v8("?dir") v11("?director") v3("?directorName"):::projected v12("?duration"):::projected v4("?film"):::projected v2("?germanTitle"):::projected v7("?imdb"):::projected v1("?ordinal"):::projected v6("?originalTitle"):::projected v10("?pub"):::projected v12("?publication") v5("?series") c5(["wd:Q642878"]):::iri f0[["?germanTitle = 'de'"]] f0 --> v2 v4 --"p:P179"--> v5 v5 --"p:statement/P179"--> c5 v5 --"p:qualifier/P1545"--> v1 v4 --"p:direct/P1476"--> v6 v4 --"rdfs:label"--> v2 v4 --"p:direct/P345"--> v7 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v4 -."p:direct/P57".-> v8 v8 --"rdfs:label"--> v3 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v4 -."p:direct/P2047".-> v12 end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v4 -."p:direct/P577".-> v10 end bind4[/"?directorName"/] v3 --o bind4 bind4 --as--o v11 bind5[/"sample(?duration)"/] v12 --o bind5 bind5 --as--o v12 bind6[/"min(?pub)"/] v10 --o bind6 bind6 --as--o v12