query-1a32f9e993df2b5d82ad1666a715efaa

rq turtle/ttl

TODO

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?itemLabel WHERE 
{
  SERVICE bd:slice {
    ?article schema:isPartOf <https://de.wikipedia.org/> .       
    bd:serviceParam bd:slice.offset 0 . # Start at item number (not to be confused with QID)
    bd:serviceParam bd:slice.limit 70000 . # List this many items
  }
   ?article schema:about ?item .
   optional {?item rdfs:label ?itemLabel . filter(lang(?itemLabel)="de") }
   FILTER NOT EXISTS {?item schema:description ?itemDescription . filter(lang(?itemDescription)="de") }
   FILTER NOT EXISTS { ?item wdt:P31/wdt:P279* wd:Q4167836 .  }
   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 .}
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?article") v1("?item"):::projected v2("?itemDescription") v3("?itemLabel"):::projected a1((" ")) c13([https://de.wikipedia.org/]):::iri c18(["70000^^xsd:integer"]):::literal c2(["wd:Q19887878"]):::iri c3(["wd:Q17633526"]):::iri c4(["wd:Q11753321"]):::iri c16(["0^^xsd:integer"]):::literal c14(["bd:serviceParam"]):::iri c8(["wd:Q4167836"]):::iri c5(["wd:Q15184295"]):::iri c6(["wd:Q11266439"]):::iri f0[["not "]] subgraph f0e0["Exists Clause"] e0v1 --"wdt:P31"--> e0c2 e0v1("?item"):::projected e0c2(["wd:Q19887878"]):::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:Q17633526"]):::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:Q11753321"]):::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:Q15184295"]):::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:Q11266439"]):::iri end f4--EXISTS--> f4e4 f4 --> v1 f4 --> c1 f4 --> c6 v1 --"wdt:P31"--> c6 f5[["not "]] subgraph f5e5["Exists Clause"] e5v1 --"wdt:P31"--> e5a1 e5a1 --"wdt:P279"--> e5c3 e5v1("?item"):::projected e5a1((" ")):::projected e5c3(["wd:Q4167836"]):::iri end f5--EXISTS--> f5e5 f5 --> v1 f5 --> c1 f5 --> a1 f5 --> c7 f5 --> c8 v1 --"wdt:P31"--> a1 a1 --"wdt:P279"--> c8 f6[["not "]] subgraph f6e6["Exists Clause"] e6f0[["?itemDescription = 'de'"]] e6f0 --> e6v1 e6v2 --"schema:description"--> e6v1 e6v2("?item"):::projected e6v1("?itemDescription"):::projected end f6--EXISTS--> f6e6 f6 --> v2 f6 --> v1 f6 --> c10 f7[["?itemDescription = 'de'"]] f7 --> v2 v1 --"schema:description"--> v2 subgraph s1["http://www.bigdata.com/rdf#slice"] style s1 stroke-width:4px; v4 --"schema:isPartOf"--> c13 c14 --"bd:slice.offset"--> c16 c14 --"bd:slice.limit"--> c18 end v4 --"schema:about"--> v1 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v1 -."rdfs:label".-> v3 end