query-37c39ec38d5c620afd52335ee28e7772

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 rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>
#defaultView:Map
#title Bilderwünsche für Orkney-Inseln
SELECT ?item ?article (GROUP_CONCAT(DISTINCT ?class; SEPARATOR = ", ") AS ?ist_ein) (GROUP_CONCAT(DISTINCT ?unit; SEPARATOR = ", ") AS ?einheit) ?coordinates WHERE {
  VALUES ?item {
    wd:Q1479228
    wd:Q1393146
    wd:Q1307351
    wd:Q2130032
    wd:Q2565599
    wd:Q1138920
    wd:Q1460146
    wd:Q859660
    wd:Q892987
    wd:Q2341080
    wd:Q1777535
    wd:Q1353433
    wd:Q15108475
    wd:Q15126579
    wd:Q15135047
    wd:Q15124647
    wd:Q15120173
    wd:Q16294773
    wd:Q17576945
    wd:Q18026303
    wd:Q19835769
    wd:Q25377751
    wd:Q25377856
    wd:Q25377890
    wd:Q21089344
    wd:Q22949136
    wd:Q26791763
    wd:Q28764235
    wd:Q28467982
    wd:Q28928578
    wd:Q60846963
    wd:Q56668086
    wd:Q56668322
    wd:Q56668094
    wd:Q63861219
    wd:Q19585439
  }
  ?article schema:about ?item;
    schema:isPartOf <https://de.wikipedia.org/>;
    schema:name ?page_title.
  OPTIONAL { ?item wdt:P31 ?instance. }
  OPTIONAL { ?item wdt:P131 ?verwaltungseinheit. }
  OPTIONAL { ?item wdt:P625 ?coordinates. }
  FILTER(!(?instance IN(wd:Q18019452, wd:Q46622, wd:Q89021600, wd:Q27971968, wd:Q152450, wd:Q40231)))
  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en".
    ?instance rdfs:label ?class.
    ?verwaltungseinheit rdfs:label ?unit.
  }
}
GROUP BY ?item ?article ?coordinates
ORDER BY (?article)

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v1("?article"):::projected v7("?class"):::projected v6("?coordinates"):::projected v10("?einheit") v2("?instance") v9("?ist_ein") v3("?item"):::projected v4("?page_title") v8("?unit"):::projected v5("?verwaltungseinheit") c9([https://de.wikipedia.org/]):::iri c15(["bd:serviceParam"]):::iri c17(["#91;AUTO_LANGUAGE#93;,en"]):::literal list0c3(["wd:Q89021600"]):::iri list0c1(["wd:Q18019452"]):::iri list0c4(["wd:Q27971968"]):::iri list0c6(["wd:Q40231"]):::iri list0c2(["wd:Q46622"]):::iri list0c5(["wd:Q152450"]):::iri list0c1 --o f0 list0c2 --o f0 list0c3 --o f0 list0c4 --o f0 list0c5 --o f0 list0c6 --o f0 f0[["not in "]] f0 --> v2 bind1[/VALUES ?item/] bind1-->v3 bind10(["wd:Q1479228"]) bind10 --> bind1 bind11(["wd:Q1393146"]) bind11 --> bind1 bind12(["wd:Q1307351"]) bind12 --> bind1 bind13(["wd:Q2130032"]) bind13 --> bind1 bind14(["wd:Q2565599"]) bind14 --> bind1 bind15(["wd:Q1138920"]) bind15 --> bind1 bind16(["wd:Q1460146"]) bind16 --> bind1 bind17(["wd:Q859660"]) bind17 --> bind1 bind18(["wd:Q892987"]) bind18 --> bind1 bind19(["wd:Q2341080"]) bind19 --> bind1 bind110(["wd:Q1777535"]) bind110 --> bind1 bind111(["wd:Q1353433"]) bind111 --> bind1 bind112(["wd:Q15108475"]) bind112 --> bind1 bind113(["wd:Q15126579"]) bind113 --> bind1 bind114(["wd:Q15135047"]) bind114 --> bind1 bind115(["wd:Q15124647"]) bind115 --> bind1 bind116(["wd:Q15120173"]) bind116 --> bind1 bind117(["wd:Q16294773"]) bind117 --> bind1 bind118(["wd:Q17576945"]) bind118 --> bind1 bind119(["wd:Q18026303"]) bind119 --> bind1 bind120(["wd:Q19835769"]) bind120 --> bind1 bind121(["wd:Q25377751"]) bind121 --> bind1 bind122(["wd:Q25377856"]) bind122 --> bind1 bind123(["wd:Q25377890"]) bind123 --> bind1 bind124(["wd:Q21089344"]) bind124 --> bind1 bind125(["wd:Q22949136"]) bind125 --> bind1 bind126(["wd:Q26791763"]) bind126 --> bind1 bind127(["wd:Q28764235"]) bind127 --> bind1 bind128(["wd:Q28467982"]) bind128 --> bind1 bind129(["wd:Q28928578"]) bind129 --> bind1 bind130(["wd:Q60846963"]) bind130 --> bind1 bind131(["wd:Q56668086"]) bind131 --> bind1 bind132(["wd:Q56668322"]) bind132 --> bind1 bind133(["wd:Q56668094"]) bind133 --> bind1 bind134(["wd:Q63861219"]) bind134 --> bind1 bind135(["wd:Q19585439"]) bind135 --> bind1 v1 --"schema:about"--> v3 v1 --"schema:isPartOf"--> c9 v1 --"schema:name"--> v4 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v3 -."wdt:P31".-> v2 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v3 -."wdt:P131".-> v5 end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v3 -."wdt:P625".-> v6 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c15 --"wikibase:language"--> c17 v2 --"rdfs:label"--> v7 v5 --"rdfs:label"--> v8 end bind4[/"?class"/] v7 --o bind4 bind4 --as--o v9 bind5[/"?unit"/] v8 --o bind5 bind5 --as--o v10