Template talk
Difference between revisions of "Speaker of the month"
WikiLucas00 (talk | contribs) (→Most prolific speaker of each month: + April 22) |
WikiLucas00 (talk | contribs) (+May) |
||
(23 intermediate revisions by 4 users not shown) | |||
Line 12: | Line 12: | ||
|2018-06 | |2018-06 | ||
|{{u|Jules78120}} | |{{u|Jules78120}} | ||
− | |1140 | + | |{{formatnum:1140}} |
|- | |- | ||
|2018-07 | |2018-07 | ||
|{{u|Davidgrosclaude}} | |{{u|Davidgrosclaude}} | ||
− | |11068 | + | |{{formatnum:11068}} |
|- | |- | ||
|2018-08 | |2018-08 | ||
|{{u|Davidgrosclaude}} | |{{u|Davidgrosclaude}} | ||
− | |8067 | + | |{{formatnum:8067}} |
|- | |- | ||
|2018-09 | |2018-09 | ||
|{{u|Davidgrosclaude}} | |{{u|Davidgrosclaude}} | ||
− | |4963 | + | |{{formatnum:4963}} |
|- | |- | ||
|2018-10 | |2018-10 | ||
|{{u|Xabier Cañas}} | |{{u|Xabier Cañas}} | ||
− | |2540 | + | |{{formatnum:2540}} |
|- | |- | ||
|2018-11 | |2018-11 | ||
Line 36: | Line 36: | ||
|2018-12 | |2018-12 | ||
|{{u|Lepticed7}} | |{{u|Lepticed7}} | ||
− | |4423 | + | |{{formatnum:4423}} |
|- | |- | ||
|2019-01 | |2019-01 | ||
|{{u|Robin van der Vliet}} | |{{u|Robin van der Vliet}} | ||
− | |2148 | + | |{{formatnum:2148}} |
|- | |- | ||
|2019-02 | |2019-02 | ||
|{{u|Lyokoï}} | |{{u|Lyokoï}} | ||
− | |2914 | + | |{{formatnum:2914}} |
|- | |- | ||
|2019-03 | |2019-03 | ||
|{{u|Lepticed7}} | |{{u|Lepticed7}} | ||
− | |5898 | + | |{{formatnum:5898}} |
|- | |- | ||
|2019-04 | |2019-04 | ||
|{{u|WikiLucas00}} | |{{u|WikiLucas00}} | ||
− | |4328 | + | |{{formatnum:4328}} |
|- | |- | ||
|2019-05 | |2019-05 | ||
|{{u|Sebastian Wallroth}} | |{{u|Sebastian Wallroth}} | ||
− | |7424 | + | |{{formatnum:7424}} |
|- | |- | ||
|2019-06 | |2019-06 | ||
|{{u|WikiLucas00}} | |{{u|WikiLucas00}} | ||
− | |8100 | + | |{{formatnum:8100}} |
|- | |- | ||
|2019-07 | |2019-07 | ||
|{{u|WikiLucas00}} | |{{u|WikiLucas00}} | ||
− | |5288 | + | |{{formatnum:5288}} |
|- | |- | ||
|2019-08 | |2019-08 | ||
|{{u|WikiLucas00}} | |{{u|WikiLucas00}} | ||
− | |4537 | + | |{{formatnum:4537}} |
|- | |- | ||
|2019-09 | |2019-09 | ||
|{{u|Tatiana Kerbush}} | |{{u|Tatiana Kerbush}} | ||
− | |1758 | + | |{{formatnum:1758}} |
|- | |- | ||
|2019-10 | |2019-10 | ||
|{{u|WikiLucas00}} | |{{u|WikiLucas00}} | ||
− | |3130 | + | |{{formatnum:3130}} |
|- | |- | ||
|2019-11 | |2019-11 | ||
Line 84: | Line 84: | ||
|2019-12 | |2019-12 | ||
|{{u|LoquaxFR}} | |{{u|LoquaxFR}} | ||
− | |12027 | + | |{{formatnum:12027}} |
|- | |- | ||
|2020-01 | |2020-01 | ||
|{{u|LoquaxFR}} | |{{u|LoquaxFR}} | ||
− | |13097 | + | |{{formatnum:13097}} |
|- | |- | ||
|2020-02 | |2020-02 | ||
|{{u|WikiLucas00}} | |{{u|WikiLucas00}} | ||
− | |1205 | + | |{{formatnum:1205}} |
|- | |- | ||
|2020-03 | |2020-03 | ||
|{{u|Poslovitch}} | |{{u|Poslovitch}} | ||
− | |3883 | + | |{{formatnum:3883}} |
|- | |- | ||
|2020-04 | |2020-04 | ||
|{{u|Vealhurl}} | |{{u|Vealhurl}} | ||
− | |1597 | + | |{{formatnum:1597}} |
|- | |- | ||
|2020-05 | |2020-05 | ||
|{{u|Luilui6666}} | |{{u|Luilui6666}} | ||
− | |3751 | + | |{{formatnum:3751}} |
|- | |- | ||
|2020-06 | |2020-06 | ||
|{{u|DenisdeShawi}} | |{{u|DenisdeShawi}} | ||
− | |6782 | + | |{{formatnum:6782}} |
|- | |- | ||
|2020-07 | |2020-07 | ||
|{{u|Luilui6666}} | |{{u|Luilui6666}} | ||
− | |1338 | + | |{{formatnum:1338}} |
|- | |- | ||
|2020-08 | |2020-08 | ||
|{{u|Titodutta}} | |{{u|Titodutta}} | ||
− | |14325 | + | |{{formatnum:14325}} |
|- | |- | ||
|2020-09 | |2020-09 | ||
|{{u|Titodutta}} | |{{u|Titodutta}} | ||
− | |9116 | + | |{{formatnum:9116}} |
|- | |- | ||
|2020-10 | |2020-10 | ||
|{{u|Titodutta}} | |{{u|Titodutta}} | ||
− | |10056 | + | |{{formatnum:10056}} |
|- | |- | ||
|2020-11 | |2020-11 | ||
|{{u|Titodutta}} | |{{u|Titodutta}} | ||
− | |4683 | + | |{{formatnum:4683}} |
|- | |- | ||
|2020-12 | |2020-12 | ||
|{{u|Titodutta}} | |{{u|Titodutta}} | ||
− | |9001 | + | |{{formatnum:9001}} |
|- | |- | ||
|2021-01 | |2021-01 | ||
|{{u|Tohaomg}} | |{{u|Tohaomg}} | ||
− | |8494 | + | |{{formatnum:8494}} |
|- | |- | ||
|2021-02 | |2021-02 | ||
|{{u|Tohaomg}} | |{{u|Tohaomg}} | ||
− | |9271 | + | |{{formatnum:9271}} |
|- | |- | ||
|2021-03 | |2021-03 | ||
|{{u|KlaudiuMihaila}} | |{{u|KlaudiuMihaila}} | ||
− | |1948 | + | |{{formatnum:1948}} |
|- | |- | ||
|2021-04 | |2021-04 | ||
Line 152: | Line 152: | ||
|2021-05 | |2021-05 | ||
|{{u|KlaudiuMihaila}} | |{{u|KlaudiuMihaila}} | ||
− | |7496 | + | |{{formatnum:7496}} |
|- | |- | ||
|2021-06 | |2021-06 | ||
|{{u|Lyokoï}} | |{{u|Lyokoï}} | ||
− | |7554 | + | |{{formatnum:7554}} |
|- | |- | ||
|2021-07 | |2021-07 | ||
|{{u|Psubhashish}} | |{{u|Psubhashish}} | ||
− | |5960 | + | |{{formatnum:5960}} |
|- | |- | ||
|2021-08 | |2021-08 | ||
|{{u|Psubhashish}} | |{{u|Psubhashish}} | ||
− | |8381 | + | |{{formatnum:8381}} |
|- | |- | ||
|2021-09 | |2021-09 | ||
|{{u|Olaf}} | |{{u|Olaf}} | ||
− | |8444 | + | |{{formatnum:8444}} |
|- | |- | ||
|2021-10 | |2021-10 | ||
|{{u|Psubhashish}} | |{{u|Psubhashish}} | ||
− | |5464 | + | |{{formatnum:5464}} |
|- | |- | ||
|2021-11 | |2021-11 | ||
|{{u|Psubhashish}} | |{{u|Psubhashish}} | ||
− | |5536 | + | |{{formatnum:5536}} |
|- | |- | ||
|2021-12 | |2021-12 | ||
|{{u|Olaf}} | |{{u|Olaf}} | ||
− | |10690 | + | |{{formatnum:10690}} |
|- | |- | ||
|2022-01 | |2022-01 | ||
|{{u|Psubhashish}} | |{{u|Psubhashish}} | ||
− | |7259 | + | |{{formatnum:7259}} |
|- | |- | ||
|2022-02 | |2022-02 | ||
|{{u|Jest Spoczko}} | |{{u|Jest Spoczko}} | ||
− | |1307 | + | |{{formatnum:1307}} |
|- | |- | ||
|2022-03 | |2022-03 | ||
|{{u|Olaf}} | |{{u|Olaf}} | ||
− | |1568 | + | |{{formatnum:1568}} |
|- | |- | ||
|2022-04 | |2022-04 | ||
|{{u|Olaf}} | |{{u|Olaf}} | ||
− | |1088 | + | |{{formatnum:1088}} |
+ | |- | ||
+ | |2022-05 | ||
+ | |{{u|Titodutta}} | ||
+ | |723 | ||
+ | |- | ||
+ | |2022-06 | ||
+ | |{{u|Mathieu Kappler}} | ||
+ | |{{formatnum:3660}} | ||
+ | |- | ||
+ | |2022-07 | ||
+ | |{{u|Tahmid}} | ||
+ | |{{formatnum:1314}} | ||
+ | |- | ||
+ | |2022-08 | ||
+ | |{{u|Psubhashish}} | ||
+ | |{{formatnum:5003}} | ||
+ | |- | ||
+ | |2022-09 | ||
+ | |{{u|Sagnamadr}} | ||
+ | |{{formatnum:1245}} | ||
+ | |- | ||
+ | |2022-10 | ||
+ | |{{u|Fake estate}} | ||
+ | |{{formatnum:1289}} | ||
+ | |- | ||
+ | |2022-11 | ||
+ | |{{u|Jest Spoczko}} | ||
+ | |{{formatnum:1089}} | ||
+ | |- | ||
+ | |2022-12 | ||
+ | |{{u|XANA000}} | ||
+ | |{{formatnum:4761}} | ||
+ | |- | ||
+ | |2023-01 | ||
+ | |{{u|Marvives}} | ||
+ | |{{formatnum:7196}} | ||
+ | |- | ||
+ | |2023-02 | ||
+ | |{{u|XANA000}} | ||
+ | |{{formatnum:14812}} | ||
+ | |- | ||
+ | |2023-03 | ||
+ | |{{u|Psubhashish}} | ||
+ | |{{formatnum:3346}} | ||
+ | |- | ||
+ | |2023-04 | ||
+ | |{{u|Xabier Cañas}} | ||
+ | |{{formatnum:2344}} | ||
+ | |- | ||
+ | |2023-05 | ||
+ | |{{u|Po ukraińsku (Andriana)}} | ||
+ | |{{formatnum:6595}} | ||
+ | |- | ||
+ | |2023-06 | ||
+ | |{{u|Psubhashish}} | ||
+ | |{{formatnum:3974}} | ||
+ | |- | ||
+ | |2023-07 | ||
+ | |{{u|Ssgapu22}} (Sangram Keshari Senapati) | ||
+ | |{{formatnum:56456}} | ||
+ | |- | ||
+ | |2023-08 | ||
+ | |{{u|V Bhavya}} | ||
+ | |{{formatnum:15152}} | ||
+ | |- | ||
+ | |2023-09 | ||
+ | |{{u|V Bhavya}} | ||
+ | |{{formatnum:22101}} | ||
+ | |- | ||
+ | |2023-10 | ||
+ | |{{u|V Bhavya}} | ||
+ | |{{formatnum:35253}} | ||
+ | |- | ||
+ | |2023-11 | ||
+ | |{{u|Jérémy-Günther-Heinz Jähnick}} | ||
+ | |32662 | ||
+ | |- | ||
+ | |2023-12 | ||
+ | |{{u|Jérémy-Günther-Heinz Jähnick}} | ||
+ | |28425 | ||
+ | |- | ||
+ | |2024-01 | ||
+ | |{{u|Jérémy-Günther-Heinz Jähnick}} | ||
+ | |24026 | ||
+ | |- | ||
+ | |2024-02 | ||
+ | |{{u|V Bhavya}} | ||
+ | |1484 | ||
+ | |- | ||
+ | |2024-03 | ||
+ | |{{u|Grendelkhan}} | ||
+ | |2327 | ||
+ | |- | ||
+ | |2024-04 | ||
+ | |{{u|Mighty Wire}} | ||
+ | |1016 | ||
+ | |- | ||
+ | |2024-05 | ||
+ | |{{u|Wodencafe}} | ||
+ | |1568 | ||
|} | |} | ||
+ | |||
+ | == 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> |
Latest revision as of 18:46, 11 June 2024
Most prolific speaker of each month
Month | Speaker | Recordings |
---|---|---|
2018-05 | 0x010C | 452 |
2018-06 | Jules78120 | 1,140 |
2018-07 | Davidgrosclaude | 11,068 |
2018-08 | Davidgrosclaude | 8,067 |
2018-09 | Davidgrosclaude | 4,963 |
2018-10 | Xabier Cañas | 2,540 |
2018-11 | Lepticed7 | 361 |
2018-12 | Lepticed7 | 4,423 |
2019-01 | Robin van der Vliet | 2,148 |
2019-02 | Lyokoï | 2,914 |
2019-03 | Lepticed7 | 5,898 |
2019-04 | WikiLucas00 | 4,328 |
2019-05 | Sebastian Wallroth | 7,424 |
2019-06 | WikiLucas00 | 8,100 |
2019-07 | WikiLucas00 | 5,288 |
2019-08 | WikiLucas00 | 4,537 |
2019-09 | Tatiana Kerbush | 1,758 |
2019-10 | WikiLucas00 | 3,130 |
2019-11 | Spotless Mind1988 | 722 |
2019-12 | LoquaxFR | 12,027 |
2020-01 | LoquaxFR | 13,097 |
2020-02 | WikiLucas00 | 1,205 |
2020-03 | Poslovitch | 3,883 |
2020-04 | Vealhurl | 1,597 |
2020-05 | Luilui6666 | 3,751 |
2020-06 | DenisdeShawi | 6,782 |
2020-07 | Luilui6666 | 1,338 |
2020-08 | Titodutta | 14,325 |
2020-09 | Titodutta | 9,116 |
2020-10 | Titodutta | 10,056 |
2020-11 | Titodutta | 4,683 |
2020-12 | Titodutta | 9,001 |
2021-01 | Tohaomg | 8,494 |
2021-02 | Tohaomg | 9,271 |
2021-03 | KlaudiuMihaila | 1,948 |
2021-04 | Mecanautes | 878 |
2021-05 | KlaudiuMihaila | 7,496 |
2021-06 | Lyokoï | 7,554 |
2021-07 | Psubhashish | 5,960 |
2021-08 | Psubhashish | 8,381 |
2021-09 | Olaf | 8,444 |
2021-10 | Psubhashish | 5,464 |
2021-11 | Psubhashish | 5,536 |
2021-12 | Olaf | 10,690 |
2022-01 | Psubhashish | 7,259 |
2022-02 | Jest Spoczko | 1,307 |
2022-03 | Olaf | 1,568 |
2022-04 | Olaf | 1,088 |
2022-05 | Titodutta | 723 |
2022-06 | Mathieu Kappler | 3,660 |
2022-07 | Tahmid | 1,314 |
2022-08 | Psubhashish | 5,003 |
2022-09 | Sagnamadr | 1,245 |
2022-10 | Fake estate | 1,289 |
2022-11 | Jest Spoczko | 1,089 |
2022-12 | XANA000 | 4,761 |
2023-01 | Marvives | 7,196 |
2023-02 | XANA000 | 14,812 |
2023-03 | Psubhashish | 3,346 |
2023-04 | Xabier Cañas | 2,344 |
2023-05 | Po ukraińsku (Andriana) | 6,595 |
2023-06 | Psubhashish | 3,974 |
2023-07 | Ssgapu22 (Sangram Keshari Senapati) | 56,456 |
2023-08 | V Bhavya | 15,152 |
2023-09 | V Bhavya | 22,101 |
2023-10 | V Bhavya | 35,253 |
2023-11 | Jérémy-Günther-Heinz Jähnick | 32662 |
2023-12 | Jérémy-Günther-Heinz Jähnick | 28425 |
2024-01 | Jérémy-Günther-Heinz Jähnick | 24026 |
2024-02 | V Bhavya | 1484 |
2024-03 | Grendelkhan | 2327 |
2024-04 | Mighty Wire | 1016 |
2024-05 | Wodencafe | 1568 |