query-5eb7346796a4570f6407dcc2ce40e029
Help wanted on humans having ISNI but no VIAFThe query shows humans that have an ISNI but no VIAF. Some are not in the VIAF DB, but those that have a GND ID or LC ID very likely are in the VIAF system.
Use at
- https://query.wikidata.org/sparql
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 ?item ?itemLabel ?isni ?gnd ?loc
WHERE {
?item wdt:P31 wd:Q5 .
?item wdt:P213 ?isni .
MINUS {?item wdt:P214 [] .}
OPTIONAL {?item wdt:P227 ?gnd.}
OPTIONAL {?item wdt:P244 ?loc.}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE]". }
}
ORDER BY DESC(?gnd) DESC(?loc)
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v1("?gnd"):::projected
v4("?isni"):::projected
v3("?item"):::projected
v2("?loc"):::projected
a1((" "))
c8(["bd:serviceParam"]):::iri
c10(["#91;AUTO_LANGUAGE#93;"]):::literal
c2(["wd:Q5"]):::iri
v3 --"wdt:P31"--> c2
v3 --"wdt:P213"--> v4
subgraph minus0["MINUS"]
style minus0 stroke-width:6px,fill:pink,stroke:red;
v3 --"wdt:P214"--> a1
end
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v3 -."wdt:P227".-> v1
end
subgraph optional1["(optional)"]
style optional1 fill:#bbf,stroke-dasharray: 5 5;
v3 -."wdt:P244".-> v2
end
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c8 --"wikibase:language"--> c10
end