query-7dea378f8c5f9cc065b2e93d6e5cd414

PREFIX wikibase: <http://wikiba.se/ontology#>
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
(sample(?number) as ?number)
WHERE {
 ?item p:P131/ps:P131 wd:Q30971.
 ?item p:P3872 ?statement.
 ?statement pq:P585 ?time.
 ?statement ps:P3872 ?number.
 BIND (YEAR(?time) AS ?year)
 FILTER(?year>=1979) .
 SERVICE wikibase:label { bd:serviceParam wikibase:language "fr". }
 MINUS { ?statement wikibase:rank wikibase:DeprecatedRank }
} group by ?year ?item ?itemLabel
order by ?item desc (?year)

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v1("?item"):::projected v6("?number"):::projected v3("?statement") v4("?time") v6("?year"):::projected a1((" ")) c13(["wikibase:DeprecatedRank"]):::iri c11(["fr"]):::literal c9(["bd:serviceParam"]):::iri c4(["wd:Q30971"]):::iri f0[["?year >= '1979^^xsd:integer'"]] f0 --> v6 v1 --"p:P131"--> a1 a1 --"p:statement/P131"--> c4 v1 --"p:P3872"--> v3 v3 --"p:qualifier/P585"--> v4 v3 --"p:statement/P3872"--> v6 bind1[/"year-from-dateTime(?time)"/] v4 --o bind1 bind1 --as--o v6 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c9 --"wikibase:language"--> c11 end subgraph minus2["MINUS"] style minus2 stroke-width:6px,fill:pink,stroke:red; v3 --"wikibase:rank"--> c13 end bind4[/"sample(?number)"/] v6 --o bind4 bind4 --as--o v6