query-42cf0b355883ea3502612ecda545a478

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?d ?cast ?castLabel ?dob ?age ?sitelinks ?img ?role1 ?role1Label ?role2
{
    BIND( wd:Q328695 as ?film)
    ?film wdt:P577|wdt:P580 ?d
    FILTER NOT EXISTS { ?film wdt:P577 ?d1 FILTER( ?d1 < ?d) }
    ?film ( wdt:P161| wdt:P57 )  ?cast . ?cast wikibase:sitelinks ?sitelinks.
    OPTIONAL { ?cast wdt:P569 ?dob }
    BIND( YEAR(?d)-YEAR(?dob) as ?age)
    OPTIONAL { ?cast wdt:P18 ?img}
    OPTIONAL { ?film p:P161 [ps:P161 ?cast; pq:P453 ?role1] }
    OPTIONAL { ?film p:P161 [ps:P161 ?cast; pq:P4633 ?role2] }
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} order by desc(?sitelinks) LIMIT 10

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v7("?age"):::projected v5("?cast"):::projected v3("?d"):::projected v2("?d1") v6("?dob"):::projected v5("?film") v8("?img"):::projected v9("?role1"):::projected v10("?role2"):::projected v1("?sitelinks"):::projected a1((" ")) a2((" ")) c13(["bd:serviceParam"]):::iri c15(["#91;AUTO_LANGUAGE#93;,en"]):::literal f0[["not "]] subgraph f0e0["Exists Clause"] e0f0[["?d1 < ?d"]] e0f0 --> e0v1 e0f0 --> e0v2 e0v3 --"p:direct/P577"--> e0v1 e0v2("?d"):::projected e0v1("?d1"):::projected e0v3("?film"):::projected end f0--EXISTS--> f0e0 f0 --> v2 f0 --> v3 f0 --> v5 f0 --> c1 f1[["?d1 < ?d"]] f1 --> v2 f1 --> v3 v5 --"p:direct/P577"--> v2 bind2[/"'wd:Q328695'"/] bind2 --as--o v5 subgraph union0[" Union "] subgraph union0l[" "] style union0l fill:#abf,stroke-dasharray: 3 3; v5 --"p:direct/P580"--> v3 end subgraph union0r[" "] style union0r fill:#abf,stroke-dasharray: 3 3; v5 --"p:direct/P577"--> v3 end union0r <== or ==> union0l end subgraph union1[" Union "] subgraph union1l[" "] style union1l fill:#abf,stroke-dasharray: 3 3; v5 --"p:direct/P57"--> v5 end subgraph union1r[" "] style union1r fill:#abf,stroke-dasharray: 3 3; v5 --"p:direct/P161"--> v5 end union1r <== or ==> union1l end v5 --"wikibase:sitelinks"--> v1 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v5 -."p:direct/P569".-> v6 end bind3[/"year-from-dateTime(?d) - year-from-dateTime(?dob)"/] v3 --o bind3 v6 --o bind3 bind3 --as--o v7 subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v5 -."p:direct/P18".-> v8 end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; a1 -."p:statement/P161".-> v5 a1 --"p:qualifier/P453"--> v9 v5 --"p:P161"--> a1 end subgraph optional3["(optional)"] style optional3 fill:#bbf,stroke-dasharray: 5 5; a2 -."p:statement/P161".-> v5 a2 --"p:qualifier/P4633"--> v10 v5 --"p:P161"--> a2 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c13 --"wikibase:language"--> c15 end