query-390171554c49d5e7ccc4f8057bc928bc
title: Åer (Flüsse) in Dänemark SELECT ?itemLabel ?page_title ?article ?länge ?item WHERE { ?item wdt:P31 wd:Q3529419; wdt:P17 wd:Q35. OPTIONAL { ?item p:P2043/psn:P2043/wikibase:quantityAmount ?length. } BIND(IF(BOUND(?length), ?length/1000, "n/a" ) AS ?länge) 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. } BIND(IF(BOUND(?dewiki), ?dewiki, ?dawiki) AS ?article) BIND(IF(BOUND(?de_title), ?de_title, ?da_title) AS ?page_title) SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],da,en". } } ORDER BY (?länge)
Use at
- https://query.wikidata.org/sparql
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 psn: <http://www.wikidata.org/prop/statement/value-normalized/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#title: Åer (Flüsse) in Dänemark
SELECT ?itemLabel ?page_title ?article ?länge ?item WHERE {
?item wdt:P31 wd:Q3529419;
wdt:P17 wd:Q35.
OPTIONAL { ?item p:P2043/psn:P2043/wikibase:quantityAmount ?length. }
BIND(IF(BOUND(?length), ?length/1000, "n/a" ) AS ?länge)
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.
}
BIND(IF(BOUND(?dewiki), ?dewiki, ?dawiki) AS ?article)
BIND(IF(BOUND(?de_title), ?de_title, ?da_title) AS ?page_title)
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],da,en". }
}
ORDER BY (?länge)