query-4ada5647b65881b2ea7dad5feede68c0

rq turtle/ttl

title: Longest rivers in France SELECT DISTINCT ?item ?itemLabel ?length ?unit ?unitLabel ?length_in_km WHERE { ?item (wdt:P31/(wdt:P279*)) wd:Q55659167; wdt:P17 wd:Q142; p:P2043 ?length_statement. ?length_statement psv:P2043 ?length_value. ?length_value wikibase:quantityAmount ?length; wikibase:quantityUnit ?unit. ?unit p:P2370 ?unit_statement. ?unit_statement psv:P2370 ?unit_value. ?unit_value wikibase:quantityAmount ?conversion; wikibase:quantityUnit wd:Q11573. BIND(?length * ?conversion / 1000 AS ?length_in_km) SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en". } } ORDER BY DESC (?length_in_km) LIMIT 100

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX psv: <http://www.wikidata.org/prop/statement/value/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#title: Longest rivers in France
SELECT DISTINCT ?item ?itemLabel ?length ?unit ?unitLabel ?length_in_km WHERE {
  ?item (wdt:P31/(wdt:P279*)) wd:Q55659167;
    wdt:P17 wd:Q142;
    p:P2043 ?length_statement.
  ?length_statement psv:P2043 ?length_value.
  ?length_value wikibase:quantityAmount ?length;
    wikibase:quantityUnit ?unit.
  ?unit p:P2370 ?unit_statement.
  ?unit_statement psv:P2370 ?unit_value.
  ?unit_value wikibase:quantityAmount ?conversion;
    wikibase:quantityUnit wd:Q11573.
  BIND(?length * ?conversion / 1000 AS ?length_in_km)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en". }
}
ORDER BY DESC (?length_in_km)
LIMIT 100

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v9("?conversion") v2("?item"):::projected v5("?length"):::projected v10("?length_in_km"):::projected v3("?length_statement") v4("?length_value") v6("?unit"):::projected v7("?unit_statement") v8("?unit_value") a1((" ")) c16(["#91;AUTO_LANGUAGE#93;, en"]):::literal c12(["wd:Q11573"]):::iri c3(["wd:Q55659167"]):::iri c14(["bd:serviceParam"]):::iri c5(["wd:Q142"]):::iri v2 --"p:direct/P31"--> a1 a1 --"p:direct/P279"--> c3 v2 --"p:direct/P17"--> c5 v2 --"p:P2043"--> v3 v3 --"p:statement/value/P2043"--> v4 v4 --"wikibase:quantityAmount"--> v5 v4 --"wikibase:quantityUnit"--> v6 v6 --"p:P2370"--> v7 v7 --"p:statement/value/P2370"--> v8 v8 --"wikibase:quantityAmount"--> v9 v8 --"wikibase:quantityUnit"--> c12 bind0[/"?length * ?conversion / '1000^^xsd:integer'"/] v5 --o bind0 v9 --o bind0 bind0 --as--o v10 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c14 --"wikibase:language"--> c16 end