query-2c06425a98704472929853f0977b9bfd
TODO
Use at
- https://query.wikidata.org/sparql
PREFIX prov: <http://www.w3.org/ns/prov#>
PREFIX pr: <http://www.wikidata.org/prop/reference/>
SELECT ?entity ?prop ?ref ?id WHERE {
?entity ?prop ?statement.
?statement prov:wasDerivedFrom ?ref.
?ref pr:P854 ?refURL.
MINUS { ?ref pr:P245 []. }
FILTER REGEX(STR(?refURL), "^https?://(vocab.getty.edu/(page/)?ulan/|www.getty.edu/vow/ULANFullDisplay.*?&subjectid=)")
BIND(REPLACE(STR(?refURL),"^https?://(vocab.getty.edu/(page/)?ulan/|www.getty.edu/vow/ULANFullDisplay.*?&subjectid=)","") AS ?id)
}
LIMIT 500
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v2("?entity"):::projected
v6("?id"):::projected
v3("?prop"):::projected
v5("?ref"):::projected
v1("?refURL")
v4("?statement")
a1((" "))
f0[["regex(str(?refURL),'^https?://(vocab.getty.edu/(page/)?ulan/|www.getty.edu/vow/ULANFullDisplay.*?&subjectid=)')"]]
f0 --> v1
v2 -->v3--> v4
v4 --"prov:wasDerivedFrom"--> v5
v5 --"pr:P854"--> v1
subgraph minus1["MINUS"]
style minus1 stroke-width:6px,fill:pink,stroke:red;
v5 --"pr:P245"--> a1
end
bind2[/"replace(str(?refURL),'^https?://(vocab.getty.edu/(page/)?ulan/|www.getty.edu/vow/ULANFullDisplay.*?&subjectid=)','')"/]
v1 --o bind2
bind2 --as--o v6