Template talk
Difference between revisions of "Speaker of the month"
WikiLucas00 (talk | contribs) (→Most prolific speaker of each month: Update and links) |
|||
(17 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
+ | [[File:Lingua Libre Barnstar.svg|thumb]] | ||
== Most prolific speaker of each month == | == Most prolific speaker of each month == | ||
{| class="sortable wikitable" style="text-align: center;" | {| class="sortable wikitable" style="text-align: center;" | ||
Line 114: | Line 115: | ||
|- | |- | ||
|2020-08 | |2020-08 | ||
− | |{{u|Titodutta | + | |{{u|Titodutta}} |
|14325 | |14325 | ||
|- | |- | ||
Line 156: | Line 157: | ||
|{{u|Lyokoï}} | |{{u|Lyokoï}} | ||
|7554 | |7554 | ||
+ | |- | ||
+ | |2021-07 | ||
+ | |{{u|Psubhashish}} | ||
+ | |5960 | ||
+ | |- | ||
+ | |2021-08 | ||
+ | |{{u|Psubhashish}} | ||
+ | |8381 | ||
+ | |- | ||
+ | |2021-09 | ||
+ | |{{u|Olaf}} | ||
+ | |8444 | ||
+ | |- | ||
+ | |2021-10 | ||
+ | |{{u|Psubhashish}} | ||
+ | |5464 | ||
+ | |- | ||
+ | |2021-11 | ||
+ | |{{u|Psubhashish}} | ||
+ | |5536 | ||
+ | |- | ||
+ | |2021-12 | ||
+ | |{{u|Olaf}} | ||
+ | |10690 | ||
+ | |- | ||
+ | |2022-01 | ||
+ | |{{u|Psubhashish}} | ||
+ | |7259 | ||
+ | |- | ||
+ | |2022-02 | ||
+ | |{{u|Jest Spoczko}} | ||
+ | |1307 | ||
+ | |- | ||
+ | |2022-03 | ||
+ | |{{u|Olaf}} | ||
+ | |1568 | ||
+ | |- | ||
+ | |2022-04 | ||
+ | |{{u|Olaf}} | ||
+ | |1088 | ||
+ | |- | ||
+ | |2022-05 | ||
+ | |{{u|Titodutta}} | ||
+ | |723 | ||
+ | |- | ||
+ | |2022-06 | ||
+ | |{{u|Mathieu Kappler}} | ||
+ | |3660 | ||
+ | |- | ||
+ | |2022-07 | ||
+ | |{{u|Tahmid}} | ||
+ | |1314 | ||
+ | |- | ||
+ | |2022-08 | ||
+ | |{{u|Psubhashish}} | ||
+ | |5003 | ||
+ | |- | ||
+ | |2022-09 | ||
+ | |{{u|Sagnamadr}} | ||
+ | |1245 | ||
+ | |- | ||
+ | |2022-10 | ||
+ | |{{u|Fake estate}} | ||
+ | |1289 | ||
+ | |- | ||
+ | |2022-11 | ||
+ | |{{u|Jest Spoczko}} | ||
+ | |1089 | ||
+ | |- | ||
+ | |2022-12 | ||
+ | |{{u|XANA000}} | ||
+ | |4761 | ||
|} | |} | ||
+ | |||
+ | == SPARQL Request for the most prolific speaker of each month == | ||
+ | <query _pagination="10" yearmonth1="Date" speaker2="Item (locutor Qid)" speakerLabel2="Speaker" max ="Number of records"> | ||
+ | SELECT ?yearmonth1 ?speakerLabel2 ?max WHERE { | ||
+ | { | ||
+ | SELECT ?yearmonth1 (MAX (?records1) as ?max) WHERE { | ||
+ | SELECT ?yearmonth1 ?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, 8) as ?yearmonth1 ) | ||
+ | } | ||
+ | GROUP BY ?yearmonth1 ?speaker1 | ||
+ | } | ||
+ | GROUP BY ?yearmonth1 | ||
+ | } | ||
+ | { | ||
+ | SELECT ?yearmonth2 ?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, 8) as ?yearmonth2 ) | ||
+ | } | ||
+ | GROUP BY ?yearmonth2 ?speaker2 | ||
+ | } | ||
+ | FILTER(?yearmonth1 = ?yearmonth2) | ||
+ | FILTER(?max = ?records2) | ||
+ | SERVICE wikibase:label { | ||
+ | bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . | ||
+ | ?speaker2 rdfs:label ?speakerLabel2 . | ||
+ | } | ||
+ | } | ||
+ | ORDER BY DESC(?yearmonth1) | ||
+ | </query> |
Revision as of 11:10, 13 January 2023
Most prolific speaker of each month
Month | Speaker | Recordings |
---|---|---|
2018-05 | 0x010C | 452 |
2018-06 | Jules78120 | 1140 |
2018-07 | Davidgrosclaude | 11068 |
2018-08 | Davidgrosclaude | 8067 |
2018-09 | Davidgrosclaude | 4963 |
2018-10 | Xabier Cañas | 2540 |
2018-11 | Lepticed7 | 361 |
2018-12 | Lepticed7 | 4423 |
2019-01 | Robin van der Vliet | 2148 |
2019-02 | Lyokoï | 2914 |
2019-03 | Lepticed7 | 5898 |
2019-04 | WikiLucas00 | 4328 |
2019-05 | Sebastian Wallroth | 7424 |
2019-06 | WikiLucas00 | 8100 |
2019-07 | WikiLucas00 | 5288 |
2019-08 | WikiLucas00 | 4537 |
2019-09 | Tatiana Kerbush | 1758 |
2019-10 | WikiLucas00 | 3130 |
2019-11 | Spotless Mind1988 | 722 |
2019-12 | LoquaxFR | 12027 |
2020-01 | LoquaxFR | 13097 |
2020-02 | WikiLucas00 | 1205 |
2020-03 | Poslovitch | 3883 |
2020-04 | Vealhurl | 1597 |
2020-05 | Luilui6666 | 3751 |
2020-06 | DenisdeShawi | 6782 |
2020-07 | Luilui6666 | 1338 |
2020-08 | Titodutta | 14325 |
2020-09 | Titodutta | 9116 |
2020-10 | Titodutta | 10056 |
2020-11 | Titodutta | 4683 |
2020-12 | Titodutta | 9001 |
2021-01 | Tohaomg | 8494 |
2021-02 | Tohaomg | 9271 |
2021-03 | KlaudiuMihaila | 1948 |
2021-04 | Mecanautes | 878 |
2021-05 | KlaudiuMihaila | 7496 |
2021-06 | Lyokoï | 7554 |
2021-07 | Psubhashish | 5960 |
2021-08 | Psubhashish | 8381 |
2021-09 | Olaf | 8444 |
2021-10 | Psubhashish | 5464 |
2021-11 | Psubhashish | 5536 |
2021-12 | Olaf | 10690 |
2022-01 | Psubhashish | 7259 |
2022-02 | Jest Spoczko | 1307 |
2022-03 | Olaf | 1568 |
2022-04 | Olaf | 1088 |
2022-05 | Titodutta | 723 |
2022-06 | Mathieu Kappler | 3660 |
2022-07 | Tahmid | 1314 |
2022-08 | Psubhashish | 5003 |
2022-09 | Sagnamadr | 1245 |
2022-10 | Fake estate | 1289 |
2022-11 | Jest Spoczko | 1089 |
2022-12 | XANA000 | 4761 |