query-2c1ff6dbaa863d2c1c7b3032498c5d5c

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
PREFIX v: <http://www.wikidata.org/prop/statement/>
SELECT ?countryLabel ?player ?playerLabel ?number ?positionLabel ?birth ((?begin-?birth)/365.25 AS ?age) WHERE {
  BIND("2024-06-14"^^<http://www.w3.org/2001/XMLSchema#date> as ?begin) .
  ?team wdt:P31 wd:Q123856553 .
  ?team p:P710 ?playerSet . ?playerSet v:P710 ?player
  OPTIONAL{?playerSet pq:P413 ?position FILTER(?position != wd:Q715772)}
  OPTIONAL{?playerSet pq:P1618 ?number}
  OPTIONAL{?player wdt:P569 ?birth}
  ?team wdt:P31 ?nationalTeam . ?nationalTeam wdt:P31 wd:Q6979593 . ?nationalTeam wdt:P1532 ?country
  SERVICE wikibase:label{bd:serviceParam wikibase:language "en,de"}
}
ORDER BY ?countryLabel ASC(xsd:integer(?number))

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v11("?age") v4("?begin"):::projected v8("?birth"):::projected v10("?country") v1("?countryLabel"):::projected v9("?nationalTeam") v2("?number"):::projected v7("?player"):::projected v6("?playerSet") v3("?position") v5("?team") c3(["wd:Q123856553"]):::iri c14(["en,de"]):::literal c9(["wd:Q6979593"]):::iri c12(["bd:serviceParam"]):::iri bind0[/"'2024-06-14^^xsd:date'"/] bind0 --as--o v4 v5 --"p:direct/P31"--> c3 v5 --"p:P710"--> v6 v6 --"p:statement/P710"--> v7 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v6 -."p:qualifier/P413".-> v3 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v6 -."p:qualifier/P1618".-> v2 end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v7 -."p:direct/P569".-> v8 end v5 --"p:direct/P31"--> v9 v9 --"p:direct/P31"--> c9 v9 --"p:direct/P1532"--> v10 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c12 --"wikibase:language"--> c14 end bind1[/"?begin - ?birth / '365.25^^xsd:decimal'"/] v4 --o bind1 v8 --o bind1 bind1 --as--o v11