query-4d3b9d533f1c2f3544f837eb2f421067
Coses travessades per més ponts
SELECT ?travessa ?travessaLabel (COUNT(DISTINCT(?pont)) AS ?totponts) WHERE {
?pont wdt:P31/wdt:P279* wd:Q12280.
?pont wdt:P177 ?travessa.
SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],ca,en,es,fr".}
}
GROUP BY ?travessa ?travessaLabel
ORDER BY DESC(?totponts) ?travessaLabel
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 bd: <http://www.bigdata.com/rdf#>
# Coses travessades per més ponts
SELECT ?travessa ?travessaLabel (COUNT(DISTINCT(?pont)) AS ?totponts) WHERE {
?pont wdt:P31/wdt:P279* wd:Q12280.
?pont wdt:P177 ?travessa.
SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],ca,en,es,fr".}
}
GROUP BY ?travessa ?travessaLabel
ORDER BY DESC(?totponts) ?travessaLabel
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v3("?pont"):::projected
v5("?totponts")
v4("?travessa"):::projected
v2("?travessaLabel"):::projected
a1((" "))
c6(["bd:serviceParam"]):::iri
c3(["wd:Q12280"]):::iri
c8(["#91;AUTO_LANGUAGE#93;,ca,en,es,fr"]):::literal
v3 --"wdt:P31"--> a1
a1 --"wdt:P279"--> c3
v3 --"wdt:P177"--> v4
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c6 --"wikibase:language"--> c8
end
bind1[/"count(?pont)"/]
v3 --o bind1
bind1 --as--o v5