query-93e33f74d4a590ba28a5f0dce93aca37
Approximate equivalent of the DNB No WP on WikisourceThis query returns Wikisource pages where at least one of the main subjects is missing an English Wikipedia article. Right now this excludes DNB redirect pages; many of these are missing main subjects entirely.
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 schema: <http://schema.org/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?subject ?subjectLabel ?ws WHERE
{
?item wdt:P1433 wd:Q15987216.
?item wdt:P31 wd:Q19389637.
?ws schema:about ?item.
?item wdt:P921 ?subject.
MINUS {
?wp schema:about ?subject.
?wp schema:isPartOf <https://en.wikipedia.org/>.
}
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;
v1("?item")
v3("?subject"):::projected
v4("?wp")
v2("?ws"):::projected
c8([https://en.wikipedia.org/]):::iri
c10(["bd:serviceParam"]):::iri
c4(["wd:Q19389637"]):::iri
c12(["#91;AUTO_LANGUAGE#93;,en"]):::literal
c2(["wd:Q15987216"]):::iri
v1 --"wdt:P1433"--> c2
v1 --"wdt:P31"--> c4
v2 --"schema:about"--> v1
v1 --"wdt:P921"--> v3
subgraph minus0["MINUS"]
style minus0 stroke-width:6px,fill:pink,stroke:red;
v4 --"schema:about"--> v3
v4 --"schema:isPartOf"--> c8
end
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c10 --"wikibase:language"--> c12
end