query-e2d20bd77baee3132d85a4bab98e28fe
TODO
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX schema: <http://schema.org/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?itemLabel ?ORCID where
{
{select ?item ?ORCID
WHERE
{
SERVICE bd:slice {
?item wdt:P496 ?ORCID.
bd:serviceParam bd:slice.offset 1300000 . # Start at item number (not to be confused with QID)
bd:serviceParam bd:slice.limit 500000 . } # List this many items
minus {?item schema:description ?itemDescription . filter(lang(?itemDescription)="en") }
} }
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v2("?ORCID"):::projected
v1("?item"):::projected
v3("?itemDescription")
c7(["500000^^xsd:integer"]):::literal
c3(["bd:serviceParam"]):::iri
c12(["#91;AUTO_LANGUAGE#93;,en"]):::literal
c5(["1300000^^xsd:integer"]):::literal
subgraph s1["http://www.bigdata.com/rdf#slice"]
style s1 stroke-width:4px;
v1 --"wdt:P496"--> v2
c3 --"bd:slice.offset"--> c5
c3 --"bd:slice.limit"--> c7
end
subgraph minus0["MINUS"]
style minus0 stroke-width:6px,fill:pink,stroke:red;
f1[["?itemDescription = 'en'"]]
f1 --> v3
v1 --"schema:description"--> v3
end
subgraph s2["http://wikiba.se/ontology#label"]
style s2 stroke-width:4px;
c3 --"wikibase:language"--> c12
end