query-06cedf994ed0f2d75ce03c73820d1e8d

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?personLabel ?work ?workLabel ?pubyear ?englishwp ?englishws (SAMPLE(?fulltext) AS ?fulltext)
WHERE {
  ?person wdt:P1802 ?emlo.
  ?work wdt:P50 ?person.  
  MINUS {?work wdt:P31 wd:Q3331189}
OPTIONAL{?work wdt:P577 ?pubdate}
BIND(YEAR(?pubdate) as ?pubyear)
OPTIONAL{ ?englishwp schema:about ?work. ?englishwp schema:isPartOf <https://en.wikipedia.org/> }
OPTIONAL{ ?englishws schema:about ?work. ?englishws schema:isPartOf <https://en.wikisource.org/> }
OPTIONAL{ ?work wdt:P953 ?fulltext }
FILTER (BOUND(?fulltext) || BOUND(?englishwp) || BOUND(?englishws))
SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,fr,de,es,it,cz"}
} GROUP BY ?personLabel ?work ?workLabel ?pubyear ?englishwp ?englishws
ORDER BY ?personLabel ?pubyear

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v7("?emlo") v4("?englishwp"):::projected v5("?englishws"):::projected v10("?fulltext"):::projected v6("?person") v1("?personLabel"):::projected v9("?pubdate") v10("?pubyear"):::projected v8("?work"):::projected c4(["wd:Q3331189"]):::iri c14(["#91;AUTO_LANGUAGE#93;,en,fr,de,es,it,cz"]):::literal c8([https://en.wikipedia.org/]):::iri c12(["bd:serviceParam"]):::iri c9([https://en.wikisource.org/]):::iri f0[["(bound(?fulltext) || (bound(?englishwp) || bound(?englishws)))"]] f0 --> v10 f0 --> v4 f0 --> v5 v6 --"wdt:P1802"--> v7 v8 --"wdt:P50"--> v6 subgraph minus1["MINUS"] style minus1 stroke-width:6px,fill:pink,stroke:red; v8 --"wdt:P31"--> c4 end subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v8 -."wdt:P577".-> v9 end bind2[/"year-from-dateTime(?pubdate)"/] v9 --o bind2 bind2 --as--o v10 subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v4 -."schema:about".-> v8 v4 --"schema:isPartOf"--> c8 end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v5 -."schema:about".-> v8 v5 --"schema:isPartOf"--> c9 end subgraph optional3["(optional)"] style optional3 fill:#bbf,stroke-dasharray: 5 5; v8 -."wdt:P953".-> v10 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c12 --"wikibase:language"--> c14 end bind4[/"sample(?fulltext)"/] v10 --o bind4 bind4 --as--o v10