query-b9025b97433e1a53b3c19050eae79a0b

rq turtle/ttl

Oxford doctoral theses by their main topic

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?subject ?url ?qLabel ?attrib (YEAR(?inception) AS ?year) WHERE {
?q wdt:P4101 wd:Q34433; wdt:P921 ?subject; wdt:P953 ?url.
OPTIONAL {?q wdt:P50 ?author. ?author rdfs:label ?authorname FILTER(lang(?authorname)= "en") }
OPTIONAL {?q wdt:P2093 ?authorstring}
OPTIONAL {?q wdt:P571 ?inception}
BIND(IF(BOUND(?authorname),?authorname, ?authorstring) AS ?attrib).
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" }
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v8("?attrib"):::projected v5("?author") v1("?authorname") v6("?authorstring") v7("?inception"):::projected v2("?q") v3("?subject"):::projected v4("?url"):::projected v9("?year") c13(["#91;AUTO_LANGUAGE#93;,mul,en"]):::literal c11(["bd:serviceParam"]):::iri c3(["wd:Q34433"]):::iri v2 --"wdt:P4101"--> c3 v2 --"wdt:P921"--> v3 v2 --"wdt:P953"--> v4 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P50".-> v5 v5 --"rdfs:label"--> v1 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P2093".-> v6 end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P571".-> v7 end bind0[/"if(bound(?authorname),?authorname,?authorstring)"/] v1 --o bind0 v6 --o bind0 bind0 --as--o v8 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c11 --"wikibase:language"--> c13 end bind1[/"year-from-dateTime(?inception)"/] v7 --o bind1 bind1 --as--o v9