query-36fa94f255d5b9840a521768998b2c13
Standard
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 rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?item ?item_label ?range_label (GROUP_CONCAT(DISTINCT ?entity_label; SEPARATOR=", ") AS ?entities) ?peakbaggerID ?coordinate ?elev ?iso ?prom
WHERE
{
?item wdt:P4552+ wd:Q1594270.
?item wdt:P31/wdt:P279* wd:Q106589819.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en".
?item rdfs:label ?item_label.
?range rdfs:label ?range_label.
?entity rdfs:label ?entity_label.
}
OPTIONAL { ?item wdt:P4552 ?range . }
OPTIONAL { ?item wdt:P131 ?entity . }
OPTIONAL { ?item wdt:P3109 ?peakbaggerID . }
OPTIONAL { ?item wdt:P625 ?coordinate . }
OPTIONAL { ?item wdt:P2044 ?elev . }
OPTIONAL { ?item wdt:P2659 ?iso . }
OPTIONAL { ?item wdt:P2660 ?prom . }
}
GROUP BY ?item ?item_label ?range_label ?peakbaggerID ?coordinate ?elev ?iso ?prom
ORDER BY DESC(?elev)
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v9("?coordinate"):::projected
v1("?elev"):::projected
v12("?entities")
v6("?entity")
v7("?entity_label"):::projected
v10("?iso"):::projected
v2("?item"):::projected
v3("?item_label"):::projected
v8("?peakbaggerID"):::projected
v11("?prom"):::projected
v4("?range")
v5("?range_label"):::projected
a1((" "))
c2(["wd:Q1594270"]):::iri
c7(["bd:serviceParam"]):::iri
c5(["wd:Q106589819"]):::iri
c9(["#91;AUTO_LANGUAGE#93;,en"]):::literal
v2 --"wdt:P4552"--> c2
v2 --"wdt:P31"--> a1
a1 --"wdt:P279"--> c5
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c7 --"wikibase:language"--> c9
v2 --"rdfs:label"--> v3
v4 --"rdfs:label"--> v5
v6 --"rdfs:label"--> v7
end
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v2 -."wdt:P4552".-> v4
end
subgraph optional1["(optional)"]
style optional1 fill:#bbf,stroke-dasharray: 5 5;
v2 -."wdt:P131".-> v6
end
subgraph optional2["(optional)"]
style optional2 fill:#bbf,stroke-dasharray: 5 5;
v2 -."wdt:P3109".-> v8
end
subgraph optional3["(optional)"]
style optional3 fill:#bbf,stroke-dasharray: 5 5;
v2 -."wdt:P625".-> v9
end
subgraph optional4["(optional)"]
style optional4 fill:#bbf,stroke-dasharray: 5 5;
v2 -."wdt:P2044".-> v1
end
subgraph optional5["(optional)"]
style optional5 fill:#bbf,stroke-dasharray: 5 5;
v2 -."wdt:P2659".-> v10
end
subgraph optional6["(optional)"]
style optional6 fill:#bbf,stroke-dasharray: 5 5;
v2 -."wdt:P2660".-> v11
end
bind1[/"?entity_label"/]
v7 --o bind1
bind1 --as--o v12