User

Difference between revisions of "Titodutta/sandbox1"

< User:Titodutta

(test)
(update)
Tag: Replaced
Line 1: Line 1:
<languages/>
+
চইচই
<indicator name="stats"></indicator>
+
চওড়া
{{#SUBTITLE:
+
চওড়াই
<translate>
+
চক
<!--T:13-->
+
চকখিড়
LinguaLibre Alpha release was announced on August 2018. By April 2019, 100,000 audios in 46 languages were available thanks to 128 variously active speakers. In January 2020, 200,000 audios in 82 languages thanks to 268 different speakers. In September 2020, the platform reached 300,000 recordings in 91 languages (357 speakers).
+
চকচক
</translate>
+
চকচেক
}}
+
চকবি⁄
 
+
চকমক
<translate>
+
চকমকািন
== Global stats == <!--T:4-->
+
চকমিক
 
+
চকমেক
<!--T:5-->
+
চকিমলােনা
<query records="Records" speakers="Speakers" languages="Languages">
+
চকরাবকরা
SELECT
+
চকা
(COUNT(DISTINCT ?record) AS ?records)
 
(COUNT(DISTINCT ?speaker) AS ?speakers)
 
(COUNT(DISTINCT ?language) AS ?languages)
 
WHERE {
 
  ?record prop:P2 entity:Q2 .
 
  ?record prop:P5 ?speaker .
 
  ?record prop:P4 ?language .
 
}
 
</query>
 
 
 
== Monthly activity == <!--T:25-->
 
 
 
<!--T:26-->
 
<query yearmonth="Date" records="New records" speakers="Active speakers" languages="Active languages">
 
SELECT
 
?yearmonth
 
(COUNT(DISTINCT ?record) AS ?records)
 
(COUNT(DISTINCT ?speaker) AS ?speakers)
 
(COUNT(DISTINCT ?language) AS ?languages)
 
WHERE {
 
  ?record prop:P2 entity:Q2 .
 
  ?record prop:P6 ?date .
 
  ?record prop:P5 ?speaker .
 
  ?record prop:P4 ?language .
 
  BIND( SUBSTR(str(?date), 0, 8) as ?yearmonth )
 
}
 
GROUP BY ?yearmonth
 
ORDER BY ?yearmonth
 
</query>
 
 
 
== Number of records per languages == <!--T:1-->
 
 
 
<!--T:6-->
 
<!-- NEEDED IMPROVEMENT FOR READABILITY : -->
 
<!-- * add column with language name in English, ex: bn,enench, Cantonese -->
 
<!-- * add column with iso3 code, ex: bn,ena, yue -->
 
<query _pagination="10" language="Item (Language Qid)" code="ISO 639-3 code" nb="Number of records">
 
select ?language ?languageLabel ?code (COUNT(DISTINCT ?record) as ?nb)
 
where {
 
  ?record prop:P2 entity:Q2 .
 
  ?record prop:P4 ?language .
 
  OPTIONAL { ?language prop:P13 ?code }
 
  OPTIONAL { ?language rdfs:label ?languageLabel . FILTER (lang(?languageLabel) = "bn"). }
 
}
 
GROUP BY ?language ?languageLabel ?code
 
ORDER BY DESC(?nb)
 
</query>
 
 
 
== The most prolific speakers == <!--T:2-->
 
 
 
<!--T:8-->
 
<query _pagination="10" locutor="Item (locutor Qid)" locutorLabel="Speaker" nb="Number of records" languages="Spoken languages">
 
    select ?locutor ?locutorLabel (COUNT(?record) as ?nb)
 
    where {
 
        ?record prop:P2 entity:Q2 .
 
        ?record prop:P5 ?locutor .
 
        ?record prop:P4 ?lang .
 
        #extra:{"type": "wikibase-item", "filter":"Q4", "label": "P4", "multiple": true} ?record prop:P4 entity:[EXTRA] .
 
        SERVICE wikibase:label {
 
            bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
 
            ?locutor rdfs:label ?locutorLabel .
 
        }
 
    }
 
    GROUP BY ?locutor ?locutorLabel
 
    ORDER BY DESC(?nb)
 
    LIMIT 50
 
</query>
 
 
 
</translate>
 
__NOTOC__
 

Revision as of 19:24, 8 October 2020

চইচই চওড়া চওড়াই চক চকখিড় চকচক চকচেক চকবি⁄ চকমক চকমকািন চকমিক চকমেক চকিমলােনা চকরাবকরা চকা