query-208a3adabecad9d68d677b94df6bfcce
SPARQL and js-file
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#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX value: <http://www.wikidata.org/prop/statement/value/>
SELECT ?item ?itemLabel ?p ?pLabel WHERE {
VALUES ?p {wd:Q111 wd:Q405 wd:Q313 wd:Q308 wd:Q3169 wd:Q3134 wd:Q3123 wd:Q3143 wd:Q2565} # mars, moon, venus, mercury, ganymede, callisto, io, europa, titan
?item wdt:P376 ?p .
?item p:P625 ?coordStatement .
?coordStatement value:P625 ?coordValue .
?coordValue wikibase:geoGlobe wd:Q2 .
SERVICE wikibase:label {bd:serviceParam wikibase:language "en".}
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v3("?coordStatement")
v4("?coordValue")
v2("?item"):::projected
v1("?p"):::projected
c7(["bd:serviceParam"]):::iri
c5(["wd:Q2"]):::iri
c9(["en"]):::literal
bind0[/VALUES ?p/]
bind0-->v1
bind00(["wd:Q111"])
bind00 --> bind0
bind01(["wd:Q405"])
bind01 --> bind0
bind02(["wd:Q313"])
bind02 --> bind0
bind03(["wd:Q308"])
bind03 --> bind0
bind04(["wd:Q3169"])
bind04 --> bind0
bind05(["wd:Q3134"])
bind05 --> bind0
bind06(["wd:Q3123"])
bind06 --> bind0
bind07(["wd:Q3143"])
bind07 --> bind0
bind08(["wd:Q2565"])
bind08 --> bind0
v2 --"p:direct/P376"--> v1
v2 --"p:P625"--> v3
v3 --"p:statement/value/P625"--> v4
v4 --"wikibase:geoGlobe"--> c5
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c7 --"wikibase:language"--> c9
end