Template talk

Difference between revisions of "Speaker of the month"

(20 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="wikitable" style="text-align: center;"
+
{| class="sortable wikitable" style="text-align: center;"
 
!Month
 
!Month
 
!Speaker
 
!Speaker
Line 6: Line 7:
 
|-
 
|-
 
|2018-05
 
|2018-05
|0x010C
+
|{{u|0x010C}}
 
|452
 
|452
 
|-
 
|-
 
|2018-06
 
|2018-06
|Jules78120
+
|{{u|Jules78120}}
 
|1140
 
|1140
 
|-
 
|-
 
|2018-07
 
|2018-07
|Davidgrosclaude
+
|{{u|Davidgrosclaude}}
 
|11068
 
|11068
 
|-
 
|-
 
|2018-08
 
|2018-08
|Davidgrosclaude
+
|{{u|Davidgrosclaude}}
 
|8067
 
|8067
 
|-
 
|-
 
|2018-09
 
|2018-09
|Davidgrosclaude
+
|{{u|Davidgrosclaude}}
 
|4963
 
|4963
 
|-
 
|-
 
|2018-10
 
|2018-10
|Xabier Cañas
+
|{{u|Xabier Cañas}}
 
|2540
 
|2540
 
|-
 
|-
 
|2018-11
 
|2018-11
|Lepticed7
+
|{{u|Lepticed7}}
 
|361
 
|361
 
|-
 
|-
 
|2018-12
 
|2018-12
|Lepticed7
+
|{{u|Lepticed7}}
 
|4423
 
|4423
 
|-
 
|-
 
|2019-01
 
|2019-01
|Robin van der Vliet
+
|{{u|Robin van der Vliet}}
 
|2148
 
|2148
 
|-
 
|-
 
|2019-02
 
|2019-02
|Lyokoï
+
|{{u|Lyokoï}}
 
|2914
 
|2914
 
|-
 
|-
 
|2019-03
 
|2019-03
|Lepticed7
+
|{{u|Lepticed7}}
 
|5898
 
|5898
 
|-
 
|-
 
|2019-04
 
|2019-04
|WikiLucas00
+
|{{u|WikiLucas00}}
 
|4328
 
|4328
 
|-
 
|-
 
|2019-05
 
|2019-05
|Sebastian Wallroth
+
|{{u|Sebastian Wallroth}}
 
|7424
 
|7424
 
|-
 
|-
 
|2019-06
 
|2019-06
|WikiLucas00
+
|{{u|WikiLucas00}}
 
|8100
 
|8100
 
|-
 
|-
 
|2019-07
 
|2019-07
|WikiLucas00
+
|{{u|WikiLucas00}}
 
|5288
 
|5288
 
|-
 
|-
 
|2019-08
 
|2019-08
|WikiLucas00
+
|{{u|WikiLucas00}}
 
|4537
 
|4537
 
|-
 
|-
 
|2019-09
 
|2019-09
|Tatiana Kerbush
+
|{{u|Tatiana Kerbush}}
 
|1758
 
|1758
 
|-
 
|-
 
|2019-10
 
|2019-10
|WikiLucas00
+
|{{u|WikiLucas00}}
 
|3130
 
|3130
 
|-
 
|-
 
|2019-11
 
|2019-11
|Spotless Mind1988
+
|{{u|Spotless Mind1988}}
 
|722
 
|722
 
|-
 
|-
 
|2019-12
 
|2019-12
|LoquaxFR
+
|{{u|LoquaxFR}}
 
|12027
 
|12027
 
|-
 
|-
 
|2020-01
 
|2020-01
|LoquaxFR
+
|{{u|LoquaxFR}}
 
|13097
 
|13097
 
|-
 
|-
 
|2020-02
 
|2020-02
|WikiLucas00
+
|{{u|WikiLucas00}}
 
|1205
 
|1205
 
|-
 
|-
 
|2020-03
 
|2020-03
|Poslovitch
+
|{{u|Poslovitch}}
 
|3883
 
|3883
 
|-
 
|-
 
|2020-04
 
|2020-04
|Vealhurl
+
|{{u|Vealhurl}}
 
|1597
 
|1597
 
|-
 
|-
 
|2020-05
 
|2020-05
|Luilui6666
+
|{{u|Luilui6666}}
 
|3751
 
|3751
 
|-
 
|-
 
|2020-06
 
|2020-06
|DenisdeShawi
+
|{{u|DenisdeShawi}}
 
|6782
 
|6782
 
|-
 
|-
 
|2020-07
 
|2020-07
|Luilui6666
+
|{{u|Luilui6666}}
 
|1338
 
|1338
 
|-
 
|-
 
|2020-08
 
|2020-08
|Titodutta
+
|{{u|Titodutta}}
 
|14325
 
|14325
 
|-
 
|-
 
|2020-09
 
|2020-09
|Titodutta
+
|{{u|Titodutta}}
 
|9116
 
|9116
 
|-
 
|-
 
|2020-10
 
|2020-10
|Titodutta
+
|{{u|Titodutta}}
 
|10056
 
|10056
 
|-
 
|-
 
|2020-11
 
|2020-11
|Titodutta
+
|{{u|Titodutta}}
 
|4683
 
|4683
 
|-
 
|-
 
|2020-12
 
|2020-12
|Titodutta
+
|{{u|Titodutta}}
 
|9001
 
|9001
 
|-
 
|-
 
|2021-01
 
|2021-01
|Tohaomg
+
|{{u|Tohaomg}}
 
|8494
 
|8494
 
|-
 
|-
 
|2021-02
 
|2021-02
|Tohaomg
+
|{{u|Tohaomg}}
 
|9271
 
|9271
 
|-
 
|-
 
|2021-03
 
|2021-03
|KlaudiuMihaila
+
|{{u|KlaudiuMihaila}}
 
|1948
 
|1948
 
|-
 
|-
 
|2021-04
 
|2021-04
|Mecanautes
+
|{{u|Mecanautes}}
 
|878
 
|878
 
|-
 
|-
 
|2021-05
 
|2021-05
|???
+
|{{u|KlaudiuMihaila}}
|???
+
|7496
 +
|-
 +
|2021-06
 +
|{{u|Lyokoï}}
 +
|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

Lingua Libre Barnstar.svg

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

SPARQL Request for the most prolific speaker of each month

... Loading ...