|
|
| (9 intermediate revisions by 2 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}}
| |
| − | |{{formatnum:1140}}
| |
| − | |-
| |
| − | |2018-07
| |
| − | |{{u|Davidgrosclaude}}
| |
| − | |{{formatnum:11068}}
| |
| − | |-
| |
| − | |2018-08
| |
| − | |{{u|Davidgrosclaude}}
| |
| − | |{{formatnum:8067}}
| |
| − | |-
| |
| − | |2018-09
| |
| − | |{{u|Davidgrosclaude}}
| |
| − | |{{formatnum:4963}}
| |
| − | |-
| |
| − | |2018-10
| |
| − | |{{u|Xabier Cañas}}
| |
| − | |{{formatnum:2540}}
| |
| − | |-
| |
| − | |2018-11
| |
| − | |{{u|Lepticed7}}
| |
| − | |361
| |
| − | |-
| |
| − | |2018-12
| |
| − | |{{u|Lepticed7}}
| |
| − | |{{formatnum:4423}}
| |
| − | |-
| |
| − | |2019-01
| |
| − | |{{u|Robin van der Vliet}}
| |
| − | |{{formatnum:2148}}
| |
| − | |-
| |
| − | |2019-02
| |
| − | |{{u|Lyokoï}}
| |
| − | |{{formatnum:2914}}
| |
| − | |-
| |
| − | |2019-03
| |
| − | |{{u|Lepticed7}}
| |
| − | |{{formatnum:5898}}
| |
| − | |-
| |
| − | |2019-04
| |
| − | |{{u|WikiLucas00}}
| |
| − | |{{formatnum:4328}}
| |
| − | |-
| |
| − | |2019-05
| |
| − | |{{u|Sebastian Wallroth}}
| |
| − | |{{formatnum:7424}}
| |
| − | |-
| |
| − | |2019-06
| |
| − | |{{u|WikiLucas00}}
| |
| − | |{{formatnum:8100}}
| |
| − | |-
| |
| − | |2019-07
| |
| − | |{{u|WikiLucas00}}
| |
| − | |{{formatnum:5288}}
| |
| − | |-
| |
| − | |2019-08
| |
| − | |{{u|WikiLucas00}}
| |
| − | |{{formatnum:4537}}
| |
| − | |-
| |
| − | |2019-09
| |
| − | |{{u|Tatiana Kerbush}}
| |
| − | |{{formatnum:1758}}
| |
| − | |-
| |
| − | |2019-10
| |
| − | |{{u|WikiLucas00}}
| |
| − | |{{formatnum:3130}}
| |
| − | |-
| |
| − | |2019-11
| |
| − | |{{u|Spotless Mind1988}}
| |
| − | |722
| |
| − | |-
| |
| − | |2019-12
| |
| − | |{{u|LoquaxFR}}
| |
| − | |{{formatnum:12027}}
| |
| − | |-
| |
| − | |2020-01
| |
| − | |{{u|LoquaxFR}}
| |
| − | |{{formatnum:13097}}
| |
| − | |-
| |
| − | |2020-02
| |
| − | |{{u|WikiLucas00}}
| |
| − | |{{formatnum:1205}}
| |
| − | |-
| |
| − | |2020-03
| |
| − | |{{u|Poslovitch}}
| |
| − | |{{formatnum:3883}}
| |
| − | |-
| |
| − | |2020-04
| |
| − | |{{u|Vealhurl}}
| |
| − | |{{formatnum:1597}}
| |
| − | |-
| |
| − | |2020-05
| |
| − | |{{u|Luilui6666}}
| |
| − | |{{formatnum:3751}}
| |
| − | |-
| |
| − | |2020-06
| |
| − | |{{u|DenisdeShawi}}
| |
| − | |{{formatnum:6782}}
| |
| − | |-
| |
| − | |2020-07
| |
| − | |{{u|Luilui6666}}
| |
| − | |{{formatnum:1338}}
| |
| − | |-
| |
| − | |2020-08
| |
| − | |{{u|Titodutta}}
| |
| − | |{{formatnum:14325}}
| |
| − | |-
| |
| − | |2020-09
| |
| − | |{{u|Titodutta}}
| |
| − | |{{formatnum:9116}}
| |
| − | |-
| |
| − | |2020-10
| |
| − | |{{u|Titodutta}}
| |
| − | |{{formatnum:10056}}
| |
| − | |-
| |
| − | |2020-11
| |
| − | |{{u|Titodutta}}
| |
| − | |{{formatnum:4683}}
| |
| − | |-
| |
| − | |2020-12
| |
| − | |{{u|Titodutta}}
| |
| − | |{{formatnum:9001}}
| |
| − | |-
| |
| − | |2021-01
| |
| − | |{{u|Tohaomg}}
| |
| − | |{{formatnum:8494}}
| |
| − | |-
| |
| − | |2021-02
| |
| − | |{{u|Tohaomg}}
| |
| − | |{{formatnum:9271}}
| |
| − | |-
| |
| − | |2021-03
| |
| − | |{{u|KlaudiuMihaila}}
| |
| − | |{{formatnum:1948}}
| |
| − | |-
| |
| − | |2021-04
| |
| − | |{{u|Mecanautes}}
| |
| − | |878
| |
| − | |-
| |
| − | |2021-05
| |
| − | |{{u|KlaudiuMihaila}}
| |
| − | |{{formatnum:7496}}
| |
| − | |-
| |
| − | |2021-06
| |
| − | |{{u|Lyokoï}}
| |
| − | |{{formatnum:7554}}
| |
| − | |-
| |
| − | |2021-07
| |
| − | |{{u|Psubhashish}}
| |
| − | |{{formatnum:5960}}
| |
| − | |-
| |
| − | |2021-08
| |
| − | |{{u|Psubhashish}}
| |
| − | |{{formatnum:8381}}
| |
| − | |-
| |
| − | |2021-09
| |
| − | |{{u|Olaf}}
| |
| − | |{{formatnum:8444}}
| |
| − | |-
| |
| − | |2021-10
| |
| − | |{{u|Psubhashish}}
| |
| − | |{{formatnum:5464}}
| |
| − | |-
| |
| − | |2021-11
| |
| − | |{{u|Psubhashish}}
| |
| − | |{{formatnum:5536}}
| |
| − | |-
| |
| − | |2021-12
| |
| − | |{{u|Olaf}}
| |
| − | |{{formatnum:10690}}
| |
| − | |-
| |
| − | |2022-01
| |
| − | |{{u|Psubhashish}}
| |
| − | |{{formatnum:7259}}
| |
| − | |-
| |
| − | |2022-02
| |
| − | |{{u|Jest Spoczko}}
| |
| − | |{{formatnum:1307}}
| |
| − | |-
| |
| − | |2022-03
| |
| − | |{{u|Olaf}}
| |
| − | |{{formatnum:1568}}
| |
| − | |-
| |
| − | |2022-04
| |
| − | |{{u|Olaf}}
| |
| − | |{{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}}
| |
| − | |}
| |
| | | | |
| − | == 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>
| |