query-f4687940d677e75eded831cda479bcb5

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
PREFIX schema: <http://schema.org/>
#-------------------------------------------------------------------------------
# Objekte in Dresden ohne deutsche Beschreibung
#-------------------------------------------------------------------------------
#defaultView:Table
SELECT DISTINCT ?item ?itemLabel ?article ?image ?coordinates  WHERE {
  ?item (wdt:P131/wdt:P279*) wd:Q1731. # in Dresden
  #Artikellink
  OPTIONAL {
    ?article schema:about ?item.
    ?article schema:isPartOf <https://de.wikipedia.org/>.
  }
  # Commons-Link
  OPTIONAL {?commons    schema:about ?item ;
           schema:isPartOf <https://commons.wikimedia.org/> .
  } 
  OPTIONAL { ?item wdt:P18 ?image. }
  OPTIONAL { ?item wdt:P625 ?coordinates. }

  filter not exists {?item schema:description ?desc . filter(lang(?desc)="de") } # Beschreibung auf Deutsch ist leer 

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,de,ru,es,fr,cs,pl,nl,dk" }     # Beschreibung in anderen Sprachen anzeigen

}
order by ?itemDescription

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?article"):::projected v5("?commons") v7("?coordinates"):::projected v2("?desc") v6("?image"):::projected v3("?item"):::projected v1("?itemDescription") a1((" ")) c8([https://de.wikipedia.org/]):::iri c9([https://commons.wikimedia.org/]):::iri c13(["bd:serviceParam"]):::iri c15(["#91;AUTO_LANGUAGE#93;,en,de,ru,es,fr,cs,pl,nl,dk"]):::literal c5(["wd:Q1731"]):::iri f0[["not "]] subgraph f0e0["Exists Clause"] e0f0[["?desc = 'de'"]] e0f0 --> e0v1 e0v2 --"schema:description"--> e0v1 e0v1("?desc"):::projected e0v2("?item"):::projected end f0--EXISTS--> f0e0 f0 --> v2 f0 --> v3 f0 --> c2 f1[["?desc = 'de'"]] f1 --> v2 v3 --"schema:description"--> v2 v3 --"wdt:P131"--> a1 a1 --"wdt:P279"--> c5 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v4 -."schema:about".-> v3 v4 --"schema:isPartOf"--> c8 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v5 -."schema:about".-> v3 v5 --"schema:isPartOf"--> c9 end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v3 -."wdt:P18".-> v6 end subgraph optional3["(optional)"] style optional3 fill:#bbf,stroke-dasharray: 5 5; v3 -."wdt:P625".-> v7 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c13 --"wikibase:language"--> c15 end