query-5ef21748df4743150b3251524cab4724

rq turtle/ttl

Propertiesinstance of (P31)dissertation submitted to (P4101)full work available at URL (P953)author (P50)

Use at

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 ?thesis ?thesisDescription ?authorLabel ?authorwp ?ora_url WHERE {
?thesis wdt:P31 wd:Q187685;  # doctoral theses
        wdt:P4101 wd:Q34433;  # submitted to University of Oxford
        wdt:P953 ?ora_url     # with open access link
OPTIONAL {?thesis wdt:P50 ?author
OPTIONAL{ ?authorwp schema:about ?author. ?authorwp schema:isPartOf <https://en.wikipedia.org/> } }
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" }
} ORDER BY DESC(?authorwp)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?author") v1("?authorwp"):::projected v3("?ora_url"):::projected v2("?thesis"):::projected c13(["#91;AUTO_LANGUAGE#93;,mul,en"]):::literal c2(["wd:Q187685"]):::iri c9([https://en.wikipedia.org/]):::iri c11(["bd:serviceParam"]):::iri c4(["wd:Q34433"]):::iri v2 --"wdt:P31"--> c2 v2 --"wdt:P4101"--> c4 v2 --"wdt:P953"--> v3 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P50".-> v4 subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v1 -."schema:about".-> v4 v1 --"schema:isPartOf"--> c9 end end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c11 --"wikibase:language"--> c13 end