query-53f25b688fcbf117c010d1ea719f9b93

rq turtle/ttl

Things described at an Oxford web address but aren't in the collections that have shared with Wikidata

Use at

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 DISTINCT ?item ?itemLabel ?itemDescription  WHERE {
{?item wdt:P973 ?url FILTER (STRSTARTS(STR(?url), ".ox.ac.uk")) } 
UNION {?item wdt:P953 ?fullwork FILTER (CONTAINS(STR(?fullwork), ".ox.ac.uk")) }
?item wdt:P195 ?coll FILTER( ?coll NOT IN (wd:Q636400, wd:Q82133, wd:Q1456119, wd:Q6941088, wd:Q52556635) ).
SERVICE wikibase:label {bd:serviceParam wikibase:language "en" }
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v1("?coll") v4("?fullwork") v3("?item"):::projected v2("?url") c13(["en"]):::literal c11(["bd:serviceParam"]):::iri f0[["?coll != 'wd:Q636400'?coll != 'wd:Q82133'?coll != 'wd:Q1456119'?coll != 'wd:Q6941088'?coll != 'wd:Q52556635'"]] f0 --> v1 subgraph union0[" Union "] subgraph union0l[" "] style union0l fill:#abf,stroke-dasharray: 3 3; f1[["contains(str(?fullwork),'.ox.ac.uk')"]] f1 --> v4 v3 --"wdt:P953"--> v4 end subgraph union0r[" "] style union0r fill:#abf,stroke-dasharray: 3 3; f2[["starts-with(str(?url),'.ox.ac.uk')"]] f2 --> v2 v3 --"wdt:P973"--> v2 end union0r <== or ==> union0l end v3 --"wdt:P195"--> v1 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c11 --"wikibase:language"--> c13 end