query-090a059f50a2ba361042361be8c39a73
Labels fr de stations à rajouter
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 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