query-23622893793ae605bf9824b7f14d908f
TODO
Use at
- https://query.wikidata.org/sparql
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?itemLabel ?wen WHERE {
SERVICE bd:slice {
?item wikibase:sitelinks "1"^^xsd:integer .
bd:serviceParam bd:slice.offset 0 . # Start at item number (not to be confused with QID)
bd:serviceParam bd:slice.limit 100000 . # List this many items
}
?wen schema:about ?item .
?wen schema:isPartOf ?partOf .
?partOf wikibase:wikiGroup "wikipedia" .
FILTER NOT EXISTS { ?item wdt:P31 wd:Q11266439 .}
FILTER NOT EXISTS { ?item wdt:P31 wd:Q15184295 .}
FILTER NOT EXISTS { ?item wdt:P31 wd:Q11753321 .}
FILTER NOT EXISTS { ?item wdt:P31 wd:Q17633526 .}
FILTER NOT EXISTS { ?item wdt:P31 wd:Q19887878 .}
FILTER NOT EXISTS { ?item wdt:P31 wd:Q4167836 .}
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("?item"):::projected
v3("?partOf")
v2("?wen"):::projected
c15(["100000^^xsd:integer"]):::literal
c22(["en"]):::literal
c3(["wd:Q19887878"]):::iri
c4(["wd:Q17633526"]):::iri
c5(["wd:Q11753321"]):::iri
c13(["0^^xsd:integer"]):::literal
c10(["1^^xsd:integer"]):::literal
c11(["bd:serviceParam"]):::iri
c2(["wd:Q4167836"]):::iri
c19(["wikipedia"]):::literal
c6(["wd:Q15184295"]):::iri
c7(["wd:Q11266439"]):::iri
f0[["not "]]
subgraph f0e0["Exists Clause"]
e0v1 --"wdt:P31"--> e0c2
e0v1("?item"):::projected
e0c2(["wd:Q4167836"]):::iri
end
f0--EXISTS--> f0e0
f0 --> v1
f0 --> c1
f0 --> c2
v1 --"wdt:P31"--> c2
f1[["not "]]
subgraph f1e1["Exists Clause"]
e1v1 --"wdt:P31"--> e1c2
e1v1("?item"):::projected
e1c2(["wd:Q19887878"]):::iri
end
f1--EXISTS--> f1e1
f1 --> v1
f1 --> c1
f1 --> c3
v1 --"wdt:P31"--> c3
f2[["not "]]
subgraph f2e2["Exists Clause"]
e2v1 --"wdt:P31"--> e2c2
e2v1("?item"):::projected
e2c2(["wd:Q17633526"]):::iri
end
f2--EXISTS--> f2e2
f2 --> v1
f2 --> c1
f2 --> c4
v1 --"wdt:P31"--> c4
f3[["not "]]
subgraph f3e3["Exists Clause"]
e3v1 --"wdt:P31"--> e3c2
e3v1("?item"):::projected
e3c2(["wd:Q11753321"]):::iri
end
f3--EXISTS--> f3e3
f3 --> v1
f3 --> c1
f3 --> c5
v1 --"wdt:P31"--> c5
f4[["not "]]
subgraph f4e4["Exists Clause"]
e4v1 --"wdt:P31"--> e4c2
e4v1("?item"):::projected
e4c2(["wd:Q15184295"]):::iri
end
f4--EXISTS--> f4e4
f4 --> v1
f4 --> c1
f4 --> c6
v1 --"wdt:P31"--> c6
f5[["not "]]
subgraph f5e5["Exists Clause"]
e5v1 --"wdt:P31"--> e5c2
e5v1("?item"):::projected
e5c2(["wd:Q11266439"]):::iri
end
f5--EXISTS--> f5e5
f5 --> v1
f5 --> c1
f5 --> c7
v1 --"wdt:P31"--> c7
subgraph s1["http://www.bigdata.com/rdf#slice"]
style s1 stroke-width:4px;
v1 --"wikibase:sitelinks"--> c10
c11 --"bd:slice.offset"--> c13
c11 --"bd:slice.limit"--> c15
end
v2 --"schema:about"--> v1
v2 --"schema:isPartOf"--> v3
v3 --"wikibase:wikiGroup"--> c19
subgraph s2["http://wikiba.se/ontology#label"]
style s2 stroke-width:4px;
c11 --"wikibase:language"--> c22
end