query-57da19db0e2a5e5991cc62515209f0ac
Persons with ULAN, and a reference to RKD in ULAN, but no RKDArtistID
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdtn: <http://www.wikidata.org/prop/direct-normalized/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX dcterms: <http://purl.org/dc/terms/>
PREFIX bibo: <http://purl.org/ontology/bibo/>
SELECT ?item ?ulanuri ?rkdartistsid
WHERE {
{
SELECT ?item ?ulanuri ?rkdartistsid WHERE {
?item wdtn:P245 ?ulanuri .
?item p:P245 ?statement0.
?statement0 ps:P245 _:anyValueP245;
wikibase:rank ?rank.
FILTER(?rank != wikibase:DeprecatedRank)
MINUS { ?item wdtn:P650 ?rkdartistsid } .
MINUS { ?item p:P650 ?statement1. ?statement1 (ps:P650) _:anyValueP650. }
}
}
{
SELECT * {
SERVICE <http://vocab.getty.edu/sparql.json> {
SELECT ?ulanuri ?rkdartistsid WHERE {
?ulanuri rdf:type <http://vocab.getty.edu/ontology#PersonConcept> .
?ulanuri dcterms:source ?source .
?source dcterms:isPartOf <http://vocab.getty.edu/ulan/source/2100183444> .
?source bibo:locator ?rkdartistsid
}
}
}
}
} LIMIT 500
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v2("?item"):::projected
v1("?rank")
v5("?rkdartistsid"):::projected
v7("?source")
v4("?statement0")
v6("?statement1")
v3("?ulanuri"):::projected
a1((" "))
a2((" "))
c14([http://vocab.getty.edu/ulan/source/2100183444]):::iri
c11([http://vocab.getty.edu/ontology#PersonConcept]):::iri
f0[["?rank != 'wikibase:DeprecatedRank'"]]
f0 --> v1
v2 --"p:direct-normalized/P245"--> v3
v2 --"p:P245"--> v4
v4 --"p:statement/P245"--> a1
v4 --"wikibase:rank"--> v1
subgraph minus1["MINUS"]
style minus1 stroke-width:6px,fill:pink,stroke:red;
v2 --"p:direct-normalized/P650"--> v5
end
subgraph minus2["MINUS"]
style minus2 stroke-width:6px,fill:pink,stroke:red;
v2 --"p:P650"--> v6
v6 --"p:statement/P650"--> a2
end
subgraph s1["http://vocab.getty.edu/sparql.json"]
style s1 stroke-width:4px;
v3 --"a"--> c11
v3 --http://purl.org/dc/terms/source--> v7
v7 --http://purl.org/dc/terms/isPartOf--> c14
v7 --http://purl.org/ontology/bibo/locator--> v5
end