query-83e8f90b1a5ed0e6a3cb2434593378b6

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT  ?item ?itemLabel (year(?time) as ?year) ?number 
WHERE 
{
  ?item wdt:P31/wdt:P279* wd:Q62447 .
  ?item wdt:P17 wd:Q408 .
  ?item p:P3872 ?statement .
    ?statement pq:P585 ?time .
    ?statement pq:P518 ?applies_to .
    ?statement ps:P3872 ?number .
  filter(year(?time)=2016)
  filter(?applies_to=wd:Q2165236)
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} order by desc(?number)

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v2("?applies_to") v4("?item"):::projected v1("?number"):::projected v5("?statement") v3("?time"):::projected v6("?year") a1((" ")) c7(["wd:Q408"]):::iri c5(["wd:Q62447"]):::iri c13(["bd:serviceParam"]):::iri c15(["#91;AUTO_LANGUAGE#93;,en"]):::literal f0[["?applies_to = 'wd:Q2165236'"]] f0 --> v2 f1[["year-from-dateTime(?time) = '2016^^xsd:integer'"]] f1 --> v3 v4 --"p:direct/P31"--> a1 a1 --"p:direct/P279"--> c5 v4 --"p:direct/P17"--> c7 v4 --"p:P3872"--> v5 v5 --"p:qualifier/P585"--> v3 v5 --"p:qualifier/P518"--> v2 v5 --"p:statement/P3872"--> v1 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c13 --"wikibase:language"--> c15 end bind2[/"year-from-dateTime(?time)"/] v3 --o bind2 bind2 --as--o v6