query-5924ea6b745edd650c1f4359cdacb23b

rq turtle/ttl

Patronage of (x) airport(s) in a country

Use at

• https://query.wikidata.org/sparql

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 {
&nbsp;values ?item {wd:Q17430 wd:Q642313 wd:Q17431} .
&nbsp;?item p:P3872 ?statement.
&nbsp;?statement pq:P585 ?time.
&nbsp;?statement ps:P3872 ?number.
&nbsp;BIND (YEAR(?time) AS ?year)
 FILTER(?year>=1979) .
&nbsp;SERVICE wikibase:label { bd:serviceParam wikibase:language "fr". }
&nbsp;MINUS { ?statement wikibase:rank wikibase:DeprecatedRank }
} group by ?year ?item ?itemLabel
order by ?item desc (?year)

Query found at

• https://www.wikidata.org/wiki/User:Bouzinac/Fr%C3%A9quentations