query-2330b62aed6004eb041e79de81ff3a54

rq turtle/ttl

military branch, most are still in recent centuries: (P241)military branch P410 has currently 155k uses. While there are 82k uses that lack

Use at

https://query.wikidata.org/sparql

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
SELECT ?cen (COUNT(*) AS ?count) WHERE {
  ?item wdt:P410 ?value;
    wdt:P570 ?d.
  BIND(ROUND((YEAR(?d)) / 100 ) AS ?cen)
  MINUS { ?item wdt:P241 _:b19. }
}
GROUP BY ?cen
ORDER BY DESC (?cen)

Query found at

https://www.wikidata.org/wiki/Property_talk:P410

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v5("?cen"):::projected v5("?count") v4("?d") v2("?item") v3("?value") a1((" ")) v2 --"wdt:P410"--> v3 v2 --"wdt:P570"--> v4 bind0[/"numeric-round(year-from-dateTime(?d) / '100^^xsd:integer')"/] v4 --o bind0 bind0 --as--o v5 subgraph minus1["MINUS"] style minus1 stroke-width:6px,fill:pink,stroke:red; v2 --"wdt:P241"--> a1 end bind3[/"count(*)"/] bind3 --as--o v5