User
Difference between revisions of "Titodutta/প্রশ্ন"
< User:Titodutta
(→কত্ত ভাষা: ++) |
(+) |
||
| (5 intermediate revisions by the same user not shown) | |||
| Line 2: | Line 2: | ||
== কত্ত ভাষা == | == কত্ত ভাষা == | ||
| − | <query _pagination="10" language="Item (Language Qid)" code="Code ISO 639-3" nb="Number of records"> | + | <query _pagination="10-" language="Item (Language Qid)" code="Code ISO 639-3" nb="Number of records"> |
select ?language ?languageLabel ?code (COUNT(DISTINCT ?record) as ?nb) | select ?language ?languageLabel ?code (COUNT(DISTINCT ?record) as ?nb) | ||
where { | where { | ||
| Line 8: | Line 8: | ||
?record prop:P4 ?language . | ?record prop:P4 ?language . | ||
OPTIONAL { ?language prop:P13 ?code } | OPTIONAL { ?language prop:P13 ?code } | ||
| − | OPTIONAL { ?language rdfs:label ?languageLabel . FILTER (lang(?languageLabel) = "bn | + | OPTIONAL { ?language rdfs:label ?languageLabel . FILTER (lang(?languageLabel) = "bn"). } |
} | } | ||
GROUP BY ?language ?languageLabel ?code | GROUP BY ?language ?languageLabel ?code | ||
| + | ORDER BY DESC(?nb) | ||
| + | </query> | ||
| + | |||
| + | == আরেক == | ||
| + | <query yearmonth="Date" records="New records" speakers="New speakers" languages="New 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> | ||
| + | |||
| + | <query _pagination="5" locutor="Item (locutor Qid)" locutorLabel="Speaker" nb="Number of records" languages="Spoken languages"> | ||
| + | SELECT ?locutor ?locutorLabel ?nb WHERE { | ||
| + | { | ||
| + | SELECT ?locutor (COUNT(?record) as ?nb) | ||
| + | WHERE { | ||
| + | ?record prop:P2 entity:Q2 . | ||
| + | ?record prop:P4 entity:Q21. | ||
| + | ?record prop:P5 ?locutor . | ||
| + | } | ||
| + | GROUP BY ?locutor ?locutorLabel | ||
| + | ORDER BY DESC(?nb) | ||
| + | LIMIT 50 | ||
| + | } | ||
| + | SERVICE wikibase:label { | ||
| + | bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . | ||
| + | ?locutor rdfs:label ?locutorLabel . | ||
| + | } | ||
| + | } | ||
| + | ORDER BY DESC(?nb) | ||
| + | </query> | ||
| + | |||
| + | == The most prolific speakers for the current month == | ||
| + | |||
| + | <query _pagination="10" locutor="Item (locutor Qid)" locutorLabel="Speaker" nb="Number of records for the current month"> | ||
| + | SELECT ?locutor ?locutorLabel ?nb WHERE { | ||
| + | { | ||
| + | SELECT ?locutor (COUNT(?record) as ?nb) | ||
| + | WHERE { | ||
| + | ?record prop:P2 entity:Q2 . # Q2: record, P2: instance of. | ||
| + | ?record prop:P5 ?locutor . # Property:P5: speaker | ||
| + | ?record prop:P6 ?date . | ||
| + | FILTER ( YEAR(?date) = YEAR(NOW()) && MONTH(?date) = MONTH(NOW()) ) | ||
| + | } | ||
| + | GROUP BY ?locutor ?locutorLabel | ||
| + | ORDER BY DESC(?nb) | ||
| + | LIMIT 50 | ||
| + | } | ||
| + | SERVICE wikibase:label { | ||
| + | bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . | ||
| + | ?locutor rdfs:label ?locutorLabel . | ||
| + | } | ||
| + | } | ||
ORDER BY DESC(?nb) | ORDER BY DESC(?nb) | ||
</query> | </query> | ||
Latest revision as of 21:15, 24 July 2021
Query মানে প্রশ্ন হবে কিনা, সে কথা যাক, এই পাতাটি আমার উপপাতা, এর নাম প্রশ্নই থাক