query-0ff738dc2a6aee32a80a0ae40e905a6f

rq turtle/ttl

title: Leuchttürme in Dänemark SELECT (GROUP_CONCAT(DISTINCT ?lang; SEPARATOR = ", ") AS ?sprachen) ?item ?itemLabel ?page_title ?article ?coordinates WHERE { { ?item wdt:P31 wd:Q39715; wdt:P17 wd:Q35; wikibase:sitelinks ?sl. } UNION { ?item wdt:P31 wd:Q831515; wdt:P17 wd:Q35; wikibase:sitelinks ?sl. } FILTER(?sl > 0 ) 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. }ery= OPTIONAL { ?page schema:about ?item; schema:inLanguage ?lang. } BIND(IF(BOUND(?dewiki), ?dewiki, ?dawiki) AS ?article) BIND(IF(BOUND(?de_title), ?de_title, ?da_title) AS ?page_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". } } GROUP BY ?item ?itemLabel ?page_title ?article ?coordinates

Use at

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#>
#title: Leuchttürme in Dänemark
SELECT (GROUP_CONCAT(DISTINCT ?lang; SEPARATOR = ", ") AS ?sprachen) ?item ?itemLabel ?page_title ?article ?coordinates WHERE {
  {
    ?item wdt:P31 wd:Q39715;
      wdt:P17 wd:Q35;
      wikibase:sitelinks ?sl.
  }
  UNION
  {
    ?item wdt:P31 wd:Q831515;
      wdt:P17 wd:Q35;
      wikibase:sitelinks ?sl.
  }
  FILTER(?sl > 0 )
  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.
  }ery=
  OPTIONAL {
    ?page schema:about ?item;
      schema:inLanguage ?lang.
  }
  BIND(IF(BOUND(?dewiki), ?dewiki, ?dawiki) AS ?article)
  BIND(IF(BOUND(?de_title), ?de_title, ?da_title) AS ?page_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".
  }
}
GROUP BY ?item ?itemLabel ?page_title ?article ?coordinates

Query found at