Template talk

Difference between revisions of "Speaker of the month"

(update)
(+)
Line 226: Line 226:
 
|1089
 
|1089
 
|}
 
|}
 +
 +
== 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 10:17, 1 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

SPARQL Request for the most prolific speaker of each month

... Loading ...