Benutzer:Queryzo/Alpenraum

SELECT ?item (GROUP_CONCAT(DISTINCT(?delabel)) as ?delabels) WHERE {  
  ?item wdt:P31 wd:Q11424 .  
  ?item wdt:P921 wd:Q1286 .
  BIND(xsd:integer(STRAFTER(str(?item), "Q")) AS ?qid) . 
  OPTIONAL { ?sitelink <http://schema.org/about> ?item } .
  FILTER NOT EXISTS { ?wde <http://schema.org/about> ?item . ?wde <http://schema.org/inLanguage> "de" } 
  OPTIONAL { ?item rdfs:label ?delabel . FILTER(lang(?delabel)="de")  }  
} GROUP BY ?item