query-13e331f72622a5b4cd16cfe17f3d4f64

rq turtle/ttl

display item and label SELECT ?item ?enLabel ?enDescription ?deLabel ?deDescr WHERE { # instance of standard Unix utility ?item wdt:P31 wd:Q18343316. # missing description in english filter not exists { ?item schema:description ?enDescription FILTER(LANG(?enDescription) = "en") . ?item rdfs:label ?enLabel FILTER(LANG(?enLabel) = "en") ?item schema:description ?deDescription FILTER(LANG(?deDescription) = "de") . ?item rdfs:label ?deLabel FILTER(LANG(?deLabel) = "de") } # at least one sitelink is a WP article in any language filter exists { ?article schema:about ?item FILTER (SUBSTR(str(?article), 11, 15) = ".wikipedia.org/") . }

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#>
# display item and label
SELECT ?item ?enLabel ?enDescription ?deLabel ?deDescr
WHERE {
  # instance of standard Unix utility
  ?item wdt:P31 wd:Q18343316. 
  # missing description in english
  filter not exists {
    ?item schema:description ?enDescription FILTER(LANG(?enDescription) = "en") .
    ?item rdfs:label ?enLabel FILTER(LANG(?enLabel) = "en") 
    ?item schema:description ?deDescription FILTER(LANG(?deDescription) = "de") .
    ?item rdfs:label ?deLabel FILTER(LANG(?deLabel) = "de") 
  }
  # at least one sitelink is a WP article in any language
  filter exists { ?article schema:about ?item FILTER (SUBSTR(str(?article), 11, 15) = ".wikipedia.org/") . }

Query found at