User
Difference between revisions of "Titodutta/প্রশ্ন"
< User:Titodutta
(++) |
(+) |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 30: | Line 30: | ||
GROUP BY ?yearmonth | GROUP BY ?yearmonth | ||
ORDER 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) | ||
</query> | </query> | ||
Latest revision as of 21:15, 24 July 2021
Query মানে প্রশ্ন হবে কিনা, সে কথা যাক, এই পাতাটি আমার উপপাতা, এর নাম প্রশ্নই থাক