query-b151bd68689e4e2b9d52867ea0c7089f

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?itemLabel ?mdod where
{
   {
select ?item (max(?dod) as ?mdod) where  
{

{ select DISTINCT ?item WHERE 
  {
    ?item wdt:P31/wdt:P279* ?pq . 
    VALUES ?pq { wd:Q386724  wd:Q42848 } 
    ?item wdt:P577 ?dop . 

    FILTER (?dop < "1924-01-01T00:00:01"^^xsd:dateTime)
    FILTER (?dop > "1800-01-01T00:00:01"^^xsd:dateTime)
    FILTER NOT EXISTS { ?item wdt:P6216 [] }  
  } } 
  ?item wdt:P50|wdt:P170|wdt:P655|wdt:P84|wdt:P110|wdt:P287 ?creator .
  ?creator wdt:P570 ?dod .
} group by ?item  }  
  FILTER(?mdod < "1918-01-01T00:00:01"^^xsd:dateTime) .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v5("?creator") v6("?dod") v3("?dop") v2("?item"):::projected v7("?mdod"):::projected v5("?pq") a1((" ")) a2((" ")) c16(["bd:serviceParam"]):::iri c18(["#91;AUTO_LANGUAGE#93;,en"]):::literal f0[["?mdod < '1918-01-01T00:00:01^^xsd:dateTime'"]] f0 --> v7 f1[["not "]] subgraph f1e0["Exists Clause"] e0v1 --"wdt:P6216"--> e0a1 e0v1("?item"):::projected e0a1((" ")):::projected end f1--EXISTS--> f1e0 f1 --> v2 f1 --> c2 f1 --> a1 v2 --"wdt:P6216"--> a1 f2[["?dop > '1800-01-01T00:00:01^^xsd:dateTime'"]] f2 --> v3 f3[["?dop < '1924-01-01T00:00:01^^xsd:dateTime'"]] f3 --> v3 v2 --"wdt:P31"--> a2 a2 --"wdt:P279"--> v5 bind4[/VALUES ?pq/] bind4-->v5 bind40(["wd:Q386724"]) bind40 --> bind4 bind41(["wd:Q42848"]) bind41 --> bind4 v2 --"wdt:P577"--> v3 subgraph union0[" Union "] subgraph union0l[" "] style union0l fill:#abf,stroke-dasharray: 3 3; subgraph union1[" Union "] subgraph union1l[" "] style union1l fill:#abf,stroke-dasharray: 3 3; subgraph union2[" Union "] subgraph union2l[" "] style union2l fill:#abf,stroke-dasharray: 3 3; subgraph union3[" Union "] subgraph union3l[" "] style union3l fill:#abf,stroke-dasharray: 3 3; subgraph union4[" Union "] subgraph union4l[" "] style union4l fill:#abf,stroke-dasharray: 3 3; v2 --"wdt:P287"--> v5 end subgraph union4r[" "] style union4r fill:#abf,stroke-dasharray: 3 3; v2 --"wdt:P110"--> v5 end union4r <== or ==> union4l end end subgraph union3r[" "] style union3r fill:#abf,stroke-dasharray: 3 3; v2 --"wdt:P84"--> v5 end union3r <== or ==> union3l end end subgraph union2r[" "] style union2r fill:#abf,stroke-dasharray: 3 3; v2 --"wdt:P655"--> v5 end union2r <== or ==> union2l end end subgraph union1r[" "] style union1r fill:#abf,stroke-dasharray: 3 3; v2 --"wdt:P170"--> v5 end union1r <== or ==> union1l end end subgraph union0r[" "] style union0r fill:#abf,stroke-dasharray: 3 3; v2 --"wdt:P50"--> v5 end union0r <== or ==> union0l end v5 --"wdt:P570"--> v6 bind6[/"max(?dod)"/] v6 --o bind6 bind6 --as--o v7 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c16 --"wikibase:language"--> c18 end