Template
Difference between revisions of "Speaker of the year"
WikiLucas00 (talk | contribs) (Creation of SOTY) |
WikiLucas00 (talk | contribs) |
||
| Line 1: | Line 1: | ||
{{BUser | {{BUser | ||
|border= gold | |border= gold | ||
| − | |title=<center>[[Template | + | |title=<center>[[Template:Speaker of the year|{{LangSwitch |
|default = SPEAKER OF THE YEAR | |default = SPEAKER OF THE YEAR | ||
|fr = LOCUTEUR DE L'ANNÉE | |fr = LOCUTEUR DE L'ANNÉE | ||
| Line 19: | Line 19: | ||
<noinclude> | <noinclude> | ||
{{Clr}} | {{Clr}} | ||
| − | + | == Usage == | |
| − | |||
{{PedagoWikiCode}} | {{PedagoWikiCode}} | ||
|- | |- | ||
| {{templ|Speaker of the year|2025|90000}} || {{Speaker of the year|2025|90000}} | | {{templ|Speaker of the year|2025|90000}} || {{Speaker of the year|2025|90000}} | ||
|} | |} | ||
| + | == List of all Speakers of the Year == | ||
| + | [[File:Lingua Libre Barnstar.svg|thumb]] | ||
| + | === SPARQL query (dynamic) === | ||
| + | <query _pagination="10" year1="Year" speaker2="Item (locutor Qid)" speakerLabel2="Speaker" max ="Number of records"> | ||
| + | SELECT ?year1 ?speakerLabel2 ?max WHERE { | ||
| + | { | ||
| + | SELECT ?year1 (MAX (?records1) as ?max) WHERE { | ||
| + | SELECT ?year1 ?speaker1 (COUNT (DISTINCT ?record1) AS ?records1) WHERE { | ||
| + | ?record1 prop:P2 entity:Q2 . | ||
| + | ?record1 prop:P6 ?date1 . | ||
| + | ?record1 prop:P5 ?speaker1 . | ||
| + | BIND( SUBSTR(str(?date1), 0, 5) as ?year1 ) | ||
| + | } | ||
| + | GROUP BY ?year1 ?speaker1 | ||
| + | } | ||
| + | GROUP BY ?year1 | ||
| + | } | ||
| + | { | ||
| + | SELECT ?year2 ?speaker2 (COUNT (DISTINCT ?record2) AS ?records2) WHERE { | ||
| + | ?record2 prop:P2 entity:Q2 . | ||
| + | ?record2 prop:P6 ?date2 . | ||
| + | ?record2 prop:P5 ?speaker2 . | ||
| + | BIND( SUBSTR(str(?date2), 0, 5) as ?year2 ) | ||
| + | } | ||
| + | GROUP BY ?year2 ?speaker2 | ||
| + | } | ||
| + | FILTER(?year1 = ?year2) | ||
| + | FILTER(?max = ?records2) | ||
| + | SERVICE wikibase:label { | ||
| + | bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . | ||
| + | ?speaker2 rdfs:label ?speakerLabel2 . | ||
| + | } | ||
| + | } | ||
| + | ORDER BY DESC(?year1) | ||
| + | </query> | ||
| + | |||
| + | === Fixed backup === | ||
| + | {{/backup}} | ||
| + | |||
</noinclude> | </noinclude> | ||
Latest revision as of 15:23, 4 January 2025
|
This user was the most active speaker in missing year, with missing nb recordings made during the year.
|
Usage
| Wiki Code | Rendering
| ||
|---|---|---|---|
{{Speaker of the year|2025|90000}} |
|
List of all Speakers of the Year
SPARQL query (dynamic)
Fixed backup
| Year | Speaker | Recordings |
|---|---|---|
| 2024 | Jérémy-Günther-Heinz Jähnick | 24,026 |
| 2023 | Jérémy-Günther-Heinz Jähnick | 75,975 |
| 2022 | Psubhashish | 13,682 |
| 2021 | Olaf | 51,539 |
| 2020 | Titodutta | 47,684 |
| 2019 | WikiLucas00 | 28,444 |
| 2018 | Davidgrosclaude | 24,137 |