query-98bbfb42a5466d48c10c86a9e9f1cfcf

rq turtle/ttl

TODO

Use at

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

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pqv: <http://www.wikidata.org/prop/qualifier/value/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?itemLabel ?date ?count
{
  {
    SELECT ?item ?date (COUNT(?timevalue ) AS ?count)
    WHERE
    {
      ?item wdt:P238 ?airport_code .
      ?item p:P3872 ?statement .
      ?statement pqv:P585 ?timevalue .
      ?statement ps:P3872 ?numberperperiod .
      VALUES ?rank { wikibase:NormalRank wikibase:PreferredRank } 
      ?statement wikibase:rank ?rank.
      ?timevalue wikibase:timeValue ?date .
      ?timevalue wikibase:timePrecision 10 . # Precicison is month
    }
    GROUP BY ?item ?itemLabel ?date
    HAVING (?count > 1)
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr". }
}

Query found at

• https://www.wikidata.org/wiki/User_talk:Dipsacus_fullonum