query-c1ee8df953b65d1482dd5f723c923d7c

rq turtle/ttl

Affluents du Missouri . SELECT DISTINCT ?id ?title ?idLabel ?len ?oriLabel ?geo ?loc1 ?geo2 ?loc2 WHERE {
{?id wdt:P403 wd:Q5419} ?id wdt:P625 ?geo . OPTIONAL {?id wdt:P3871 ?ori} {?id p:P625 [ ps:P625 ?geo; pq:P518 ?appl ] } OPTIONAL {?id p:P625 [ ps:P625 ?geo; pq:P131 ?loc1 ] } FILTER (?appl != wd:Q7376362).
{?id p:P625 [ ps:P625 ?geo2; pq:P518 ?cren ] } OPTIONAL {?id p:P625 [ ps:P625 ?geo2; pq:P131 ?loc2 ] } FILTER (?cren = wd:Q7376362). OPTIONAL {?id wdt:P2043 ?len } OPTIONAL {?id wdt:P4614 ?bass } SERVICE wikibase:label {bd:serviceParam wikibase:language "fr,en" . } OPTIONAL { ?link schema:about ?id . ?link schema:isPartOf https://en.wikipedia.org/ . ?link schema:name ?title. } } ORDER BY ?idLabel

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 ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
# Affluents du Missouri .
SELECT DISTINCT ?id ?title ?idLabel ?len ?oriLabel ?geo ?loc1 ?geo2 ?loc2 WHERE {  
  {?id wdt:P403 wd:Q5419} 
  ?id wdt:P625 ?geo .
  OPTIONAL {?id wdt:P3871 ?ori}
  {?id p:P625 [ ps:P625 ?geo; pq:P518 ?appl ] }
  OPTIONAL {?id p:P625 [ ps:P625 ?geo; pq:P131 ?loc1 ] }
  FILTER (?appl != wd:Q7376362).  
  {?id p:P625 [ ps:P625 ?geo2; pq:P518 ?cren ] }
  OPTIONAL {?id p:P625 [ ps:P625 ?geo2; pq:P131 ?loc2 ] }
  FILTER (?cren = wd:Q7376362).
  OPTIONAL {?id wdt:P2043 ?len }
  OPTIONAL {?id wdt:P4614 ?bass }
  SERVICE wikibase:label {bd:serviceParam wikibase:language "fr,en" . }
  OPTIONAL {
            ?link schema:about ?id .
            ?link schema:isPartOf <https://en.wikipedia.org/> .
            ?link schema:name ?title.
  }
}
ORDER BY ?idLabel

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v3("?appl") v11("?bass") v2("?cren") v5("?geo"):::projected v8("?geo2"):::projected v4("?id"):::projected v1("?idLabel"):::projected v10("?len"):::projected v12("?link") v7("?loc1"):::projected v9("?loc2"):::projected v6("?ori") v13("?title"):::projected a1((" ")) a2((" ")) a3((" ")) a4((" ")) c3(["wd:Q5419"]):::iri c18([https://en.wikipedia.org/]):::iri c13(["bd:serviceParam"]):::iri c15(["fr,en"]):::literal f0[["?cren = 'wd:Q7376362'"]] f0 --> v2 f1[["?appl != 'wd:Q7376362'"]] f1 --> v3 v4 --"p:direct/P403"--> c3 v4 --"p:direct/P625"--> v5 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v4 -."p:direct/P3871".-> v6 end a1 --"p:statement/P625"--> v5 a1 --"p:qualifier/P518"--> v3 v4 --"p:P625"--> a1 subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; a2 -."p:statement/P625".-> v5 a2 --"p:qualifier/P131"--> v7 v4 --"p:P625"--> a2 end a3 --"p:statement/P625"--> v8 a3 --"p:qualifier/P518"--> v2 v4 --"p:P625"--> a3 subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; a4 -."p:statement/P625".-> v8 a4 --"p:qualifier/P131"--> v9 v4 --"p:P625"--> a4 end subgraph optional3["(optional)"] style optional3 fill:#bbf,stroke-dasharray: 5 5; v4 -."p:direct/P2043".-> v10 end subgraph optional4["(optional)"] style optional4 fill:#bbf,stroke-dasharray: 5 5; v4 -."p:direct/P4614".-> v11 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c13 --"wikibase:language"--> c15 end subgraph optional5["(optional)"] style optional5 fill:#bbf,stroke-dasharray: 5 5; v12 -."schema:about".-> v4 v12 --"schema:isPartOf"--> c18 v12 --"schema:name"--> v13 end