query-090a059f50a2ba361042361be8c39a73

rq turtle/ttl

Labels fr de stations à rajouter

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#>
select  ?item (group_concat(?partieLabel;separator=", ") as ?partieLabelFr) (group_concat(?ligneLabel;separator=", ") as ?ligneLabelFr)
where {SELECT ?item ?ligne ?ligneLabel ?partieLabel ?partie WHERE { 
  ?item wdt:P31 wd:Q928830.
  OPTIONAL { ?item wdt:P361 ?partie. }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr". }
  FILTER(NOT EXISTS {
    ?item schema:description ?itemdesc.
    FILTER((LANG(?itemdesc)) = "fr")  })
  OPTIONAL { ?item wdt:P81 ?ligne. }   MINUS { ?item (wdt:P576|wdt:P582|wdt:P3999) ?dispar. }
  MINUS { 
    ?item wdt:P5817 ?interdit.    VALUES ?interdit {
      wd:Q811683
      wd:Q63065035 
      wd:Q12377751 
      wd:Q55653430  
      wd:Q30108381 
      wd:Q55570340 
      wd:Q11639308    }
  } }  } group by ?item

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v5("?dispar") v7("?interdit") v2("?item"):::projected v1("?itemdesc") v4("?ligne") v8("?ligneLabel"):::projected v10("?ligneLabelFr") v3("?partie") v7("?partieLabel"):::projected v9("?partieLabelFr") c1(["fr"]):::literal c4(["wd:Q928830"]):::iri c7(["bd:serviceParam"]):::iri f0[["not "]] subgraph f0e0["Exists Clause"] e0f0[["?itemdesc = 'fr'"]] e0f0 --> e0v1 e0v2 --"schema:description"--> e0v1 e0v2("?item"):::projected e0v1("?itemdesc"):::projected end f0--EXISTS--> f0e0 f0 --> v1 f0 --> v2 f0 --> c2 f1[["?itemdesc = 'fr'"]] f1 --> v1 v2 --"schema:description"--> v1 v2 --"wdt:P31"--> c4 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P361".-> v3 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c7 --"wikibase:language"--> c1 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P81".-> v4 end subgraph minus2["MINUS"] style minus2 stroke-width:6px,fill:pink,stroke:red; subgraph union0[" Union "] subgraph union0l[" "] style union0l fill:#abf,stroke-dasharray: 3 3; subgraph union1[" Union "] subgraph union1l[" "] style union1l fill:#abf,stroke-dasharray: 3 3; v2 --"wdt:P3999"--> v5 end subgraph union1r[" "] style union1r fill:#abf,stroke-dasharray: 3 3; v2 --"wdt:P582"--> v5 end union1r <== or ==> union1l end end subgraph union0r[" "] style union0r fill:#abf,stroke-dasharray: 3 3; v2 --"wdt:P576"--> v5 end union0r <== or ==> union0l end end subgraph minus3["MINUS"] style minus3 stroke-width:6px,fill:pink,stroke:red; v2 --"wdt:P5817"--> v7 bind4[/VALUES ?interdit/] bind4-->v7 bind40(["wd:Q811683"]) bind40 --> bind4 bind41(["wd:Q63065035"]) bind41 --> bind4 bind42(["wd:Q12377751"]) bind42 --> bind4 bind43(["wd:Q55653430"]) bind43 --> bind4 bind44(["wd:Q30108381"]) bind44 --> bind4 bind45(["wd:Q55570340"]) bind45 --> bind4 bind46(["wd:Q11639308"]) bind46 --> bind4 end bind7[/"?partieLabel"/] v7 --o bind7 bind7 --as--o v9 bind8[/"?ligneLabel"/] v8 --o bind8 bind8 --as--o v10