|
|
(15 intermediate revisions by 2 users not shown) |
Line 1: |
Line 1: |
− | <languages/> | + | __NOTOC__ |
− | <indicator name="stats"></indicator> | + | <languages/><indicator name="stats"></indicator>{{#SUBTITLE: <div class="mw-translate-fuzzy"> |
− | {{#SUBTITLE: | |
− |
| |
| লিঙ্গুয়ালিব্রে আলফা ২০১৮ সালের অগাস্ট মাসে প্রথম ঘোষিত হয়। ১ এপ্রিল ২০১৯ তারিখের হিসাবনুয়ায়ী (৮ মাস): ৪৬ টি ভাষায় ১ লক্ষ অডিও রেকর্ড করা হয়, thanks to 128 variously active speakers. In January 2020, more than 200,000 audios have already been recorded, in 82 languages and thanks to 268 different speakers. | | লিঙ্গুয়ালিব্রে আলফা ২০১৮ সালের অগাস্ট মাসে প্রথম ঘোষিত হয়। ১ এপ্রিল ২০১৯ তারিখের হিসাবনুয়ায়ী (৮ মাস): ৪৬ টি ভাষায় ১ লক্ষ অডিও রেকর্ড করা হয়, thanks to 128 variously active speakers. In January 2020, more than 200,000 audios have already been recorded, in 82 languages and thanks to 268 different speakers. |
− | }} | + | </div>}}{{LinguaLibre:Stats/Menu}} |
− | | |
| == বৈশ্বিক পরিসংখ্যান == | | == বৈশ্বিক পরিসংখ্যান == |
| <query records="Records" speakers="Speakers" languages="Languages"> | | <query records="Records" speakers="Speakers" languages="Languages"> |
Line 18: |
Line 15: |
| } | | } |
| </query> | | </query> |
− | == মাসিক পরিসংখ্যান ==
| |
− |
| |
− | <div class="mw-translate-fuzzy">
| |
− | <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>
| |
− | </div>
| |
− | 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>
| |
− | == বিভিন্ন ভাষায় রেকর্ডের সংখ্যা ==
| |
− |
| |
− | <!-- NEEDED IMPROVEMENT FOR READABILITY : -->
| |
− | <!-- * add column with language name in English, ex: French, Cantonese -->
| |
− | <!-- * add column with iso3 code, ex: fra, yue -->
| |
− | <div class="mw-translate-fuzzy">
| |
− | <!-- NEEDED IMPROVEMENT FOR READABILITY : -->
| |
− | <!-- * add column with language name in English, ex: French, Cantonese -->
| |
− | <!-- * add column with iso3 code, ex: fra, 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) = "en"). }
| |
− | }
| |
− | GROUP BY ?language ?languageLabel ?code
| |
− | ORDER BY DESC(?nb)
| |
− | </query>
| |
− | </div>
| |
− | 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) = "fr"). }
| |
− | }
| |
− | GROUP BY ?language ?languageLabel ?code
| |
− | ORDER BY DESC(?nb)
| |
− | </query>
| |
− | == সর্বোৎকৃষ্ট পাঠক/পাঠিকা ==
| |
− |
| |
− |
| |
− | <div class="mw-translate-fuzzy">
| |
− | <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>
| |
− | </div>
| |
− | 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>
| |
− |
| |
− | __NOTOC__
| |