query-ddb647c4f5c199ec14e1a55c60ec76ca

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?item ?itemLabel ?Bild ?Bild_Grab ?regiowikiat_id ?regiowiki_url ?deWP WHERE {
  ?item wdt:P31 wd:Q5;
    wdt:P119 wd:Q38130276.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "de,en". }
  OPTIONAL { ?item wdt:P18 ?Bild. }
  OPTIONAL { ?item wdt:P1442 ?Bild_Grab. }
  OPTIONAL {
    ?item wdt:P6228 ?regiowikiat_id.
    BIND(IRI(REPLACE(?regiowikiat_id, "^(.+)$", ?formatterurl)) AS ?regiowiki_url)
    wd:P6228 wdt:P1630 ?formatterurl.
  }
  OPTIONAL {
    ?deWP schema:about ?item;
          schema:isPartOf <https://de.wikipedia.org/>.

    }
}

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v2("?Bild"):::projected v3("?Bild_Grab"):::projected v7("?deWP"):::projected v6("?formatterurl") v1("?item"):::projected v5("?regiowiki_url"):::projected v4("?regiowikiat_id"):::projected c16([https://de.wikipedia.org/]):::iri c12(["wd:P6228"]):::iri c4(["wd:Q38130276"]):::iri c6(["bd:serviceParam"]):::iri c2(["wd:Q5"]):::iri c8(["de,en"]):::literal v1 --"wdt:P31"--> c2 v1 --"wdt:P119"--> c4 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c6 --"wikibase:language"--> c8 end subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v1 -."wdt:P18".-> v2 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v1 -."wdt:P1442".-> v3 end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v1 -."wdt:P6228".-> v4 bind0[/"replace(?regiowikiat_id,'^(.+)$',?formatterurl)"/] v4 --o bind0 v6 --o bind0 bind0 --as--o v5 c12 --"wdt:P1630"--> v6 end subgraph optional3["(optional)"] style optional3 fill:#bbf,stroke-dasharray: 5 5; v7 -."schema:about".-> v1 v7 --"schema:isPartOf"--> c16 end