Difference between revisions of "Stats/bn"

Revision as of 21:46, 10 October 2020

Other languages:

Bahasa Indonesia • ‎Bahasa Melayu • ‎Bali • ‎Bikol Central • ‎Deutsch • ‎English • ‎Esperanto • ‎Igbo • ‎Toki Pona • ‎Türkçe • ‎asturianu • ‎brezhoneg • ‎català • ‎español • ‎français • ‎galego • ‎lumbaart • ‎occitan • ‎polski • ‎română • ‎sicilianu • ‎svenska • ‎Ελληνικά • ‎башҡортса • ‎македонски • ‎русский • ‎українська • ‎עברית • ‎বাংলা • ‎తెలుగు • ‎中文 • ‎日本語 • ‎ꯃꯤꯇꯩ ꯂꯣꯟ

বৈশ্বিক পরিসংখ্যান

... Loading ...

মাসিক পরিসংখ্যান

... Loading ...

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>

বিভিন্ন ভাষায় রেকর্ডের সংখ্যা

... Loading ...

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>

সর্বোৎকৃষ্ট পাঠক/পাঠিকা

... Loading ...

   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>

@@ Line 7: / Line 7: @@
 == বৈশ্বিক পরিসংখ্যান ==
-<div class="mw-translate-fuzzy">
 <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>
-</div>
 SELECT
 (COUNT(DISTINCT ?record) AS ?records)