query-2b8034b1d54353b0865df17191e1460f

rq turtle/ttl

World War I fighter pilots (P1366)replaced by , (P1365)replaces , (P156)followed by , (P155)follows The query has several holes. The military branch may not be specified or it may be too generic. Or it may be wrong. from 1941 to 1947(Q741723)United States Army Air Forces from 1926 to 1947(Q2140008)United States Army Air Corps started 24 May 1918 to 1926(Q2096700)United States Army Air Service dissolved 20 May 1918(Q3510406)Aviation Section, U.S. Signal Corps (Q9212)United States Army Same with started 1935(Q2564009)Luftwaffe 1913 to 1918(Q678503)Imperial German Air Service Pilots (Q550707)Eddie Rickenbacker

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#>
SELECT ?pilot ?pilotLabel ?branch ?branchLabel ?awardLabel
{
  # instance of human
  ?pilot wdt:P31 wd:Q5 .

  # occupation is fighter pilot
  ?pilot wdt:P106 wd:Q618694 .

  OPTIONAL {
    # military branch
    ?pilot wdt:P241 ?branch .
  }

  # conflict is WW I
  ?pilot wdt:P607 wd:Q361 .

  OPTIONAL {
    # award
    ?pilot wdt:P166 ?award .
  }

  SERVICE wikibase:label {
     bd:serviceParam wikibase:language "en" .
  }

} ORDER BY ?pilotLabel

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?award") v3("?branch"):::projected v2("?pilot"):::projected v1("?pilotLabel"):::projected c10(["bd:serviceParam"]):::iri c2(["wd:Q5"]):::iri c7(["wd:Q361"]):::iri c12(["en"]):::literal c4(["wd:Q618694"]):::iri v2 --"wdt:P31"--> c2 v2 --"wdt:P106"--> c4 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P241".-> v3 end v2 --"wdt:P607"--> c7 subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P166".-> v4 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c10 --"wikibase:language"--> c12 end