query-fae5dd50b3d8b5f74f25dcea53d7c00e

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX prov: <http://www.w3.org/ns/prov#>
PREFIX pr: <http://www.wikidata.org/prop/reference/>
PREFIX p: <http://www.wikidata.org/prop/>
SELECT ?item ?authorAbbrev (SUBSTR(?birthdate1, 1, 4) as ?birthyear) (SUBSTR(?deathdate1, 1, 4) as ?deathyear) WHERE {
    ?item wdt:P428 ?authorAbbrev .
    ?item p:P428 ?authorabbrev1 .
    ?authorabbrev1 ps:P428 ?authorabbrevValue .
    ?authorabbrev1 prov:wasDerivedFrom ?ref .
    OPTIONAL {?ref pr:P586 ?authorId} .
    OPTIONAL {?item wdt:P569 ?birthdate1} .
    OPTIONAL {?item wdt:P570 ?deathdate1} .
    FILTER (!bound(?authorId))
}
ORDER BY ASC(?authorAbbrev)

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v1("?authorAbbrev"):::projected v2("?authorId") v4("?authorabbrev1") v5("?authorabbrevValue") v7("?birthdate1"):::projected v9("?birthyear") v8("?deathdate1"):::projected v10("?deathyear") v3("?item"):::projected v6("?ref") f0[["not bound(?authorId)"]] f0 --> v2 v3 --"p:direct/P428"--> v1 v3 --"p:P428"--> v4 v4 --"p:statement/P428"--> v5 v4 --"prov:wasDerivedFrom"--> v6 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v6 -."p:reference/P586".-> v2 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v3 -."p:direct/P569".-> v7 end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v3 -."p:direct/P570".-> v8 end bind1[/"substring(?birthdate1,'1^^xsd:integer','4^^xsd:integer')"/] v7 --o bind1 bind1 --as--o v9 bind2[/"substring(?deathdate1,'1^^xsd:integer','4^^xsd:integer')"/] v8 --o bind2 bind2 --as--o v10