query-e0c19e8012f1d0605304e26396ef925d

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 ?where
(sample(?number) as ?number)
WHERE {
 values ?item {wd:Q1049719} .
 ?item p:P3872 ?statement.
 ?statement pq:P585 ?time.
 ?statement pq:P518 ?where.
 ?statement ps:P3872 ?number.
 bind (YEAR(?time) AS ?year)
 FILTER(?year>=1979) .
 filter(?where= wd:Q2165236).
 SERVICE wikibase:label { bd:serviceParam wikibase:language "fr". }
 MINUS { ?statement wikibase:rank wikibase:DeprecatedRank }
} group by ?year ?item ?itemLabel ?where ?whereLabel
order by ?item desc (?year)

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?item"):::projected v7("?number"):::projected v4("?statement") v5("?time") v3("?where"):::projected v7("?year"):::projected c8(["bd:serviceParam"]):::iri c12(["wikibase:DeprecatedRank"]):::iri c10(["fr"]):::literal f0[["?where = 'wd:Q2165236'"]] f0 --> v3 f1[["?year >= '1979^^xsd:integer'"]] f1 --> v7 bind2[/VALUES ?item/] bind2-->v4 bind20(["wd:Q1049719"]) bind20 --> bind2 v4 --"p:P3872"--> v4 v4 --"p:qualifier/P585"--> v5 v4 --"p:qualifier/P518"--> v3 v4 --"p:statement/P3872"--> v7 bind3[/"year-from-dateTime(?time)"/] v5 --o bind3 bind3 --as--o v7 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c8 --"wikibase:language"--> c10 end subgraph minus4["MINUS"] style minus4 stroke-width:6px,fill:pink,stroke:red; v4 --"wikibase:rank"--> c12 end bind6[/"sample(?number)"/] v7 --o bind6 bind6 --as--o v7