Wikisida: Én sideversjon ble importert

2026-02-08T18:15:07Z

Én sideversjon ble importert

← Eldre sideversjon		Sideversjonen fra 8. feb. 2026 kl. 18:15
(Ingen forskjell)

nb>Bouzinac: FILTER (?prec =10)# precision = month

2024-02-27T16:19:38Z

FILTER (?prec =10)# precision = month

Ny side

<includeonly>
{{Graph:Lines
| tabletype=query | table=# Scroll down and hit blue arrow down to run and see the results + the sources
SELECT ?year ?item ?itemLabel (MAX(?number) AS ?passengers)
(SAMPLE(COALESCE(?reference_URL, ?monthly_reference_URL2)) AS ?sample_reference_URL)
WITH
{
SELECT ?item ?statement ?date ?year ?timevalue ?numberperperiod ?reference_URL
WHERE
{
?item wdt:{{#if: {{{iata|}}} |P238|}}{{#if: {{{icao|}}} |P239|}}{{#if: {{{faa|}}} |P240|}} ?airport_code
VALUES ?airport_code
{
"{{#invoke:String|replace|{{{iata|}}}{{{icao|}}}{{{faa|}}}| |" "||}}"
}
?item p:P3872 ?statement.
?statement pqv:P585 ?timevalue;
ps:P3872 ?numberperperiod.
?timevalue wikibase:timeValue ?date.
OPTIONAL { ?statement pq:P518 ?applies. }
OPTIONAL { ?statement prov:wasDerivedFrom / (pr:P854{{!}}pr:P4656) ?reference_URL. }
FILTER (BOUND(?applies)=false {{!!}} ?applies = wd:Q2165236 )
MINUS { ?statement wikibase:rank wikibase:DeprecatedRank }
BIND (YEAR(?date) AS ?year)
FILTER (?year >{{{début|1949}}}).
FILTER (?year < YEAR(NOW()))
}
} AS %airport
WHERE
{
{
# Get the sum of monthly values within a year
SELECT ?item ?year (SUM(?max_numberperperiod) AS ?number) (SAMPLE(?monthly_reference_URL) AS ?monthly_reference_URL2)
WHERE
{
# Get the maximal value and a sample reference URL for each unique month
{
SELECT ?item ?year (MAX(?numberperperiod) AS ?max_numberperperiod) (SAMPLE(?reference_URL) AS ?monthly_reference_URL)
WHERE
{
INCLUDE %airport
?timevalue wikibase:timePrecision ?prec.
FILTER (?prec =10)# precision = month
}
GROUP BY ?item ?year ?date
}
}
GROUP BY ?item ?year
}
UNION
{
?timevalue wikibase:timePrecision 9 .
BIND (?numberperperiod AS ?number)
BIND (?reference_URL AS ?sample_reference_URL)
INCLUDE %airport
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "{{CONTENTLANGUAGE}}". }
}
GROUP BY ?item ?itemLabel ?year
ORDER BY ?item DESC (?year)
|yGrid=true
|legend={{#ifexpr:{{#invoke:String|len|{{{iata|}}}{{{icao|}}}{{{faa|}}}}}>4|-|}}
|group=itemLabel
|yAxis={{#invoke:TNT|msg|I18n/Template:Airport-Statistics.tab|passengers}}
|yAxisFormat=.1s
| yZero=true
| value=passengers| type=year | xField=year|width={{{width|540}}}
| title={{#if: {{{titre|}}} |{{{titre|}}}|
{{#invoke:TNT|msg|I18n/Template:Airport-Statistics.tab|title_start}} {{#ifexpr:{{#invoke:String|len|{{{iata|}}}{{{icao|}}}{{{faa|}}}}}>4|
{{#if: {{#invoke:TNT|msg|I18n/Template:Airport-Statistics.tab|middle_title_if_airports}}|
{{#invoke:TNT|msg|I18n/Template:Airport-Statistics.tab|middle_title_if_airports}} {{{iata|}}}{{{icao|}}}{{{faa|}}} {{#invoke:TNT|msg|I18n/Template:Airport-Statistics.tab|end_title_if_airports}} |
{{#invoke:TNT|msg|I18n/Template:Airport-Statistics.tab|end_title_if_airports}} {{{iata|}}}{{{icao|}}}{{{faa|}}} }} |
{{#if: {{#invoke:TNT|msg|I18n/Template:Airport-Statistics.tab|middle_title_if_one_airport}}|
{{#invoke:TNT|msg|I18n/Template:Airport-Statistics.tab|middle_title_if_one_airport}} {{{iata|}}}{{{icao|}}}{{{faa|}}} {{#invoke:TNT|msg|I18n/Template:Airport-Statistics.tab|end_title_if_one_airport}} |
{{#invoke:TNT|msg|I18n/Template:Airport-Statistics.tab|end_title_if_one_airport}} {{{iata|}}}{{{icao|}}}{{{faa|}}} }}
}}}}
}}</includeonly><noinclude>{{Documentation}}</noinclude>

Mal:Flyplass-statistikk - Sideversjonshistorikk

Wikisida: Én sideversjon ble importert

nb>Bouzinac: FILTER (?prec =10)# precision = month