query-c38606973badf6cff2293e55e4f4c0bb

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:ImageGrid
SELECT ?name (GROUP_CONCAT(DISTINCT ?class; SEPARATOR = ", ") AS ?klassen) ?title ?article (GROUP_CONCAT(DISTINCT ?lang; SEPARATOR = ", ") AS ?sprachen) ?item ?bild ?coordinates WHERE {
  {
    ?item wdt:P31 wd:Q179700;
      wdt:P17 wd:Q183;
      wdt:P31 ?klasse.
  }
  UNION
  {
    ?item wdt:P31 wd:Q860861;
      wdt:P17 wd:Q183;
      wdt:P31 ?klasse.
  }
  OPTIONAL {
    ?dawiki schema:about ?item;
      schema:isPartOf <https://da.wikipedia.org/>;
      schema:name ?da_title.
  }
  OPTIONAL {
    ?dewiki schema:about ?item;
      schema:isPartOf <https://de.wikipedia.org/>;
      schema:name ?de_title.
  }
  OPTIONAL {
    ?enwiki schema:about ?item;
      schema:isPartOf <https://en.wikipedia.org/>;
      schema:name ?en_title.
  }
  OPTIONAL {
    ?page schema:about ?item;
      schema:inLanguage ?lang.
  }
  OPTIONAL { ?item wdt:P18 ?bild. }
  BIND(IF(BOUND(?dewiki), ?dewiki, IF(BOUND(?dawiki), ?dawiki, ?enwiki)) AS ?article)
  BIND(IF(BOUND(?de_title), ?de_title, ?da_title) AS ?title)
  OPTIONAL { ?item wdt:P625 ?coordinates. }
  FILTER(?lang IN("fr", "de", "tr", "it", "pl", "es", "fi", "en", "pt", "hr", "nl", "ro", "bg", "sv", "da", "lb", "cs", "sk", "sl", "hu", "et", "lv", "lt", "el", "fo", "sr"))
  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "[AUTO_LANGUAGE],da,en".
    ?item rdfs:label ?name.
    ?klasse rdfs:label ?class.
  }
}
GROUP BY ?item ?name ?title ?article ?bild ?coordinates

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v12("?article"):::projected v11("?bild"):::projected v16("?class"):::projected v14("?coordinates"):::projected v5("?da_title") v4("?dawiki") v7("?de_title") v6("?dewiki") v9("?en_title") v8("?enwiki") v2("?item"):::projected v3("?klasse") v17("?klassen") v1("?lang"):::projected v15("?name"):::projected v10("?page") v18("?sprachen") v13("?title"):::projected c36([https://de.wikipedia.org/]):::iri c37([https://en.wikipedia.org/]):::iri c42(["bd:serviceParam"]):::iri c44(["#91;AUTO_LANGUAGE#93;,da,en"]):::literal c31(["wd:Q860861"]):::iri c30(["wd:Q183"]):::iri c34([https://da.wikipedia.org/]):::iri c28(["wd:Q179700"]):::iri list0c2(["de"]):::literal list0c7(["fi"]):::literal list0c9(["pt"]):::literal list0c13(["bg"]):::literal list0c23(["lt"]):::literal list0c25(["fo"]):::literal list0c10(["hr"]):::literal list0c22(["lv"]):::literal list0c1(["fr"]):::literal list0c20(["hu"]):::literal list0c18(["sk"]):::literal list0c19(["sl"]):::literal list0c26(["sr"]):::literal list0c14(["sv"]):::literal list0c24(["el"]):::literal list0c8(["en"]):::literal list0c4(["it"]):::literal list0c6(["es"]):::literal list0c21(["et"]):::literal list0c17(["cs"]):::literal list0c16(["lb"]):::literal list0c5(["pl"]):::literal list0c12(["ro"]):::literal list0c15(["da"]):::literal list0c3(["tr"]):::literal list0c11(["nl"]):::literal list0c1 --o f0 list0c2 --o f0 list0c3 --o f0 list0c4 --o f0 list0c5 --o f0 list0c6 --o f0 list0c7 --o f0 list0c8 --o f0 list0c9 --o f0 list0c10 --o f0 list0c11 --o f0 list0c12 --o f0 list0c13 --o f0 list0c14 --o f0 list0c15 --o f0 list0c16 --o f0 list0c17 --o f0 list0c18 --o f0 list0c19 --o f0 list0c20 --o f0 list0c21 --o f0 list0c22 --o f0 list0c23 --o f0 list0c24 --o f0 list0c25 --o f0 list0c26 --o f0 f0[[" in "]] f0 --> v1 subgraph union0[" Union "] subgraph union0l[" "] style union0l fill:#abf,stroke-dasharray: 3 3; v2 --"wdt:P31"--> c31 v2 --"wdt:P17"--> c30 v2 --"wdt:P31"--> v3 end subgraph union0r[" "] style union0r fill:#abf,stroke-dasharray: 3 3; v2 --"wdt:P31"--> c28 v2 --"wdt:P17"--> c30 v2 --"wdt:P31"--> v3 end union0r <== or ==> union0l end subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v4 -."schema:about".-> v2 v4 --"schema:isPartOf"--> c34 v4 --"schema:name"--> v5 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v6 -."schema:about".-> v2 v6 --"schema:isPartOf"--> c36 v6 --"schema:name"--> v7 end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v8 -."schema:about".-> v2 v8 --"schema:isPartOf"--> c37 v8 --"schema:name"--> v9 end subgraph optional3["(optional)"] style optional3 fill:#bbf,stroke-dasharray: 5 5; v10 -."schema:about".-> v2 v10 --"schema:inLanguage"--> v1 end subgraph optional4["(optional)"] style optional4 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P18".-> v11 end bind1[/"if(bound(?dewiki),?dewiki,if(bound(?dawiki),?dawiki,?enwiki))"/] v6 --o bind1 v4 --o bind1 v8 --o bind1 bind1 --as--o v12 bind2[/"if(bound(?de_title),?de_title,?da_title)"/] v7 --o bind2 v5 --o bind2 bind2 --as--o v13 subgraph optional5["(optional)"] style optional5 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P625".-> v14 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c42 --"wikibase:language"--> c44 v2 --"rdfs:label"--> v15 v3 --"rdfs:label"--> v16 end bind5[/"?class"/] v16 --o bind5 bind5 --as--o v17 bind6[/"?lang"/] v1 --o bind6 bind6 --as--o v18