query-347e56c22f615e3e1ca7641279668914

rq turtle/ttl

Objekte in Torgau ohne englisches Label

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>
PREFIX schema: <http://schema.org/>
#-------------------------------------------------------------------------------
# Objekte in Torgau ohne englisches Label
#-------------------------------------------------------------------------------
#defaultView:Table
SELECT DISTINCT 
?item ?label_en ?itemLabel ?itemDescription ?article ?image ?coordinates  
WHERE {  
?item wdt:P131 wd:Q12062. # in Torgau
#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. }
  # kein englisches Label
  OPTIONAL {
      ?item rdfs:label ?label_en.                                  # Label abspeichern
      filter (lang(?label_en) = "en").                             # Label nur auf Englisch filtern
  }
  FILTER(!BOUND(?label_en))                                        # Filter Objekte, die kein englisches Label haben

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,de,ru,es,fr,cs,pl,nl,dk" }     # Label in anderen Sprachen anzeigen
}
order by ?itemLabel ?itemDescription  ?article ?coordinates ?image

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v3("?article"):::projected v8("?commons") v4("?coordinates"):::projected v5("?image"):::projected v7("?item"):::projected v2("?itemDescription"):::projected v1("?itemLabel"):::projected v6("?label_en"):::projected c6([https://de.wikipedia.org/]):::iri c7([https://commons.wikimedia.org/]):::iri c12(["bd:serviceParam"]):::iri c3(["wd:Q12062"]):::iri c14(["#91;AUTO_LANGUAGE#93;,en,de,ru,es,fr,cs,pl,nl,dk"]):::literal f0[["not bound(?label_en)"]] f0 --> v6 v7 --"wdt:P131"--> c3 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v3 -."schema:about".-> v7 v3 --"schema:isPartOf"--> c6 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v8 -."schema:about".-> v7 v8 --"schema:isPartOf"--> c7 end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v7 -."wdt:P18".-> v5 end subgraph optional3["(optional)"] style optional3 fill:#bbf,stroke-dasharray: 5 5; v7 -."wdt:P625".-> v4 end subgraph optional4["(optional)"] style optional4 fill:#bbf,stroke-dasharray: 5 5; v7 -."rdfs:label".-> v6 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c12 --"wikibase:language"--> c14 end