query-e21e5fc9683dd7dc77f4b9d82cbe61cb

rq turtle/ttl

Human Apollo space missions

Use at

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 v: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>

SELECT ?mission ?missionLabel ?start (ROUND(?seconds/(24*6*6))/100 AS ?days) ?end ?mainPilotLabel ?commanderLabel ?lunarPilotLabel WHERE {
  ?mission wdt:P31 wd:Q752783 .
  ?mission wdt:P361 wd:Q46611 .
  ?mission wdt:P619 ?start .
  ?mission wdt:P620 ?end .
  ?mission wdt:P2047 ?seconds .
  ?mission p:P1029 ?mainPilotLabelBlock . ?mainPilotLabelBlock v:P1029 ?mainPilot . ?mainPilotLabelBlock pq:P39 wd:Q20114066 .
  ?mission p:P1029 ?commanderBlock . ?commanderBlock v:P1029 ?commander . ?commanderBlock pq:P39 wd:Q89585938 .
  ?mission p:P1029 ?lunarPilotBlock . ?lunarPilotBlock v:P1029 ?lunarPilot . ?lunarPilotBlock pq:P39 wd:Q20114009 .
  SERVICE wikibase:label{bd:serviceParam wikibase:language "en"}
} ORDER BY ?start

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v8("?commander") v7("?commanderBlock") v11("?days") v3("?end"):::projected v10("?lunarPilot") v9("?lunarPilotBlock") v6("?mainPilot") v5("?mainPilotLabelBlock") v2("?mission"):::projected v4("?seconds"):::projected v1("?start"):::projected c13(["wd:Q20114009"]):::iri c2(["wd:Q752783"]):::iri c11(["wd:Q20114066"]):::iri c17(["en"]):::literal c4(["wd:Q46611"]):::iri c15(["bd:serviceParam"]):::iri c12(["wd:Q89585938"]):::iri v2 --"p:direct/P31"--> c2 v2 --"p:direct/P361"--> c4 v2 --"p:direct/P619"--> v1 v2 --"p:direct/P620"--> v3 v2 --"p:direct/P2047"--> v4 v2 --"p:P1029"--> v5 v5 --"p:statement/P1029"--> v6 v5 --"p:qualifier/P39"--> c11 v2 --"p:P1029"--> v7 v7 --"p:statement/P1029"--> v8 v7 --"p:qualifier/P39"--> c12 v2 --"p:P1029"--> v9 v9 --"p:statement/P1029"--> v10 v9 --"p:qualifier/P39"--> c13 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c15 --"wikibase:language"--> c17 end bind0[/"numeric-round(?seconds / '24^^xsd:integer' * '6^^xsd:integer' * '6^^xsd:integer') / '100^^xsd:integer'"/] v4 --o bind0 bind0 --as--o v11