query-82858cc6a335ec3e700e6c111a107696

rq turtle/ttl

title: Longest rivers in the France SELECT DISTINCT ?item ?itemLabel ?length ?unit ?unitLabel ?length_in_m WHERE { ?item (wdt:P31/(wdt:P279*)) wd:Q55659167; wdt:P17 wd:Q142; p:P2043 ?stmnode. ?stmnode psv:P2043 ?valuenode. ?valuenode wikibase:quantityAmount ?length; wikibase:quantityUnit ?unit.

# conversion to SI unit

?unit p:P2370 ?unitstmnode. # conversion to SI unit ?unitstmnode psv:P2370 ?unitvaluenode. ?unitvaluenode wikibase:quantityAmount ?conversion. ?unitvaluenode wikibase:quantityUnit wd:Q11573. # meter BIND(?length * ?conversion AS ?length_in_m). SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en". } } ORDER BY DESC (?length_in_m) 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 the France
SELECT DISTINCT ?item ?itemLabel ?length ?unit ?unitLabel ?length_in_m WHERE {
  ?item (wdt:P31/(wdt:P279*)) wd:Q55659167;
    wdt:P17 wd:Q142;
    p:P2043 ?stmnode.
  ?stmnode psv:P2043 ?valuenode.
  ?valuenode wikibase:quantityAmount ?length;
    wikibase:quantityUnit ?unit.

    # conversion to SI unit
  ?unit          p:P2370                 ?unitstmnode.   # conversion to SI unit
  ?unitstmnode   psv:P2370               ?unitvaluenode. 
  ?unitvaluenode wikibase:quantityAmount ?conversion.
  ?unitvaluenode wikibase:quantityUnit   wd:Q11573.      # meter
  BIND(?length * ?conversion AS ?length_in_m).
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en". }
}
ORDER BY DESC (?length_in_m)
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_m"):::projected v3("?stmnode") v6("?unit"):::projected v7("?unitstmnode") v8("?unitvaluenode") v4("?valuenode") 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"/] 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