query-f64ee3bf317c3d02f918ab6d3248a092

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 ?whereLabel
(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) .
 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; v3("?item"):::projected v7("?number"):::projected v3("?statement") v4("?time") v5("?where") v7("?year"):::projected c7(["bd:serviceParam"]):::iri c11(["wikibase:DeprecatedRank"]):::iri c9(["fr"]):::literal f0[["?year >= '1979^^xsd:integer'"]] f0 --> v7 bind1[/VALUES ?item/] bind1-->v3 bind10(["wd:Q1049719"]) bind10 --> bind1 v3 --"p:P3872"--> v3 v3 --"p:qualifier/P585"--> v4 v3 --"p:qualifier/P518"--> v5 v3 --"p:statement/P3872"--> v7 bind2[/"year-from-dateTime(?time)"/] v4 --o bind2 bind2 --as--o v7 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c7 --"wikibase:language"--> c9 end subgraph minus3["MINUS"] style minus3 stroke-width:6px,fill:pink,stroke:red; v3 --"wikibase:rank"--> c11 end bind5[/"sample(?number)"/] v7 --o bind5 bind5 --as--o v7