|
|
| (21 intermediate revisions by 4 users not shown) |
| Line 1: |
Line 1: |
| − | [[File:Lingua Libre Barnstar.svg|thumb]]
| |
| − | == Most prolific speaker of each month ==
| |
| − | {| class="sortable wikitable" style="text-align: center;"
| |
| − | !Month
| |
| − | !Speaker
| |
| − | !Recordings
| |
| − | |-
| |
| − | |2018-05
| |
| − | |{{u|0x010C}}
| |
| − | |452
| |
| − | |-
| |
| − | |2018-06
| |
| − | |{{u|Jules78120}}
| |
| − | |1140
| |
| − | |-
| |
| − | |2018-07
| |
| − | |{{u|Davidgrosclaude}}
| |
| − | |11068
| |
| − | |-
| |
| − | |2018-08
| |
| − | |{{u|Davidgrosclaude}}
| |
| − | |8067
| |
| − | |-
| |
| − | |2018-09
| |
| − | |{{u|Davidgrosclaude}}
| |
| − | |4963
| |
| − | |-
| |
| − | |2018-10
| |
| − | |{{u|Xabier Cañas}}
| |
| − | |2540
| |
| − | |-
| |
| − | |2018-11
| |
| − | |{{u|Lepticed7}}
| |
| − | |361
| |
| − | |-
| |
| − | |2018-12
| |
| − | |{{u|Lepticed7}}
| |
| − | |4423
| |
| − | |-
| |
| − | |2019-01
| |
| − | |{{u|Robin van der Vliet}}
| |
| − | |2148
| |
| − | |-
| |
| − | |2019-02
| |
| − | |{{u|Lyokoï}}
| |
| − | |2914
| |
| − | |-
| |
| − | |2019-03
| |
| − | |{{u|Lepticed7}}
| |
| − | |5898
| |
| − | |-
| |
| − | |2019-04
| |
| − | |{{u|WikiLucas00}}
| |
| − | |4328
| |
| − | |-
| |
| − | |2019-05
| |
| − | |{{u|Sebastian Wallroth}}
| |
| − | |7424
| |
| − | |-
| |
| − | |2019-06
| |
| − | |{{u|WikiLucas00}}
| |
| − | |8100
| |
| − | |-
| |
| − | |2019-07
| |
| − | |{{u|WikiLucas00}}
| |
| − | |5288
| |
| − | |-
| |
| − | |2019-08
| |
| − | |{{u|WikiLucas00}}
| |
| − | |4537
| |
| − | |-
| |
| − | |2019-09
| |
| − | |{{u|Tatiana Kerbush}}
| |
| − | |1758
| |
| − | |-
| |
| − | |2019-10
| |
| − | |{{u|WikiLucas00}}
| |
| − | |3130
| |
| − | |-
| |
| − | |2019-11
| |
| − | |{{u|Spotless Mind1988}}
| |
| − | |722
| |
| − | |-
| |
| − | |2019-12
| |
| − | |{{u|LoquaxFR}}
| |
| − | |12027
| |
| − | |-
| |
| − | |2020-01
| |
| − | |{{u|LoquaxFR}}
| |
| − | |13097
| |
| − | |-
| |
| − | |2020-02
| |
| − | |{{u|WikiLucas00}}
| |
| − | |1205
| |
| − | |-
| |
| − | |2020-03
| |
| − | |{{u|Poslovitch}}
| |
| − | |3883
| |
| − | |-
| |
| − | |2020-04
| |
| − | |{{u|Vealhurl}}
| |
| − | |1597
| |
| − | |-
| |
| − | |2020-05
| |
| − | |{{u|Luilui6666}}
| |
| − | |3751
| |
| − | |-
| |
| − | |2020-06
| |
| − | |{{u|DenisdeShawi}}
| |
| − | |6782
| |
| − | |-
| |
| − | |2020-07
| |
| − | |{{u|Luilui6666}}
| |
| − | |1338
| |
| − | |-
| |
| − | |2020-08
| |
| − | |{{u|Titodutta}}
| |
| − | |14325
| |
| − | |-
| |
| − | |2020-09
| |
| − | |{{u|Titodutta}}
| |
| − | |9116
| |
| − | |-
| |
| − | |2020-10
| |
| − | |{{u|Titodutta}}
| |
| − | |10056
| |
| − | |-
| |
| − | |2020-11
| |
| − | |{{u|Titodutta}}
| |
| − | |4683
| |
| − | |-
| |
| − | |2020-12
| |
| − | |{{u|Titodutta}}
| |
| − | |9001
| |
| − | |-
| |
| − | |2021-01
| |
| − | |{{u|Tohaomg}}
| |
| − | |8494
| |
| − | |-
| |
| − | |2021-02
| |
| − | |{{u|Tohaomg}}
| |
| − | |9271
| |
| − | |-
| |
| − | |2021-03
| |
| − | |{{u|KlaudiuMihaila}}
| |
| − | |1948
| |
| − | |-
| |
| − | |2021-04
| |
| − | |{{u|Mecanautes}}
| |
| − | |878
| |
| − | |-
| |
| − | |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
| |
| − | |}
| |
| | | | |
| − | == 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>
| |