User:Crazy1880

SELECT ?item ?en_description {
  ?item wdt:P31 wd:Q13442814; schema:description ?en_description .
  FILTER( LANG( ?en_description ) = 'en' ) .
  OPTIONAL {
    ?item schema:description ?de_description .
    FILTER( LANG( ?de_description ) = 'de' ) .
  } .
  FILTER( !BOUND( ?de_description ) ) .
}
LIMIT 100

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 . hint:Prior hint:gearing "forward". }
   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 .}
}
ORDER BY ASC(?itemLabel)