User
Difference between revisions of "Titodutta/প্রশ্ন"
< User:Titodutta
(→কত্ত ভাষা: ++) |
(+) |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 11: | Line 11: | ||
} | } | ||
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 মানে প্রশ্ন হবে কিনা, সে কথা যাক, এই পাতাটি আমার উপপাতা, এর নাম প্রশ্নই থাক