User

Difference between revisions of "Titodutta/প্রশ্ন"

< User:Titodutta

(++)
(+)
 
(One intermediate revision by the same user not shown)
Line 32: Line 32:
 
</query>
 
</query>
  
<query _pagination="10" locutor="Item (locutor Qid)" locutorLabel="Speaker" nb="Number of records" languages="Spoken languages"></translate>
+
<query _pagination="5" locutor="Item (locutor Qid)" locutorLabel="Speaker" nb="Number of records" languages="Spoken languages">
 
SELECT ?locutor ?locutorLabel ?nb WHERE {
 
SELECT ?locutor ?locutorLabel ?nb WHERE {
 
   {
 
   {
Line 40: Line 40:
 
         ?record prop:P4 entity:Q21.
 
         ?record prop:P4 entity:Q21.
 
         ?record prop:P5 ?locutor .
 
         ?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
 
     GROUP BY ?locutor ?locutorLabel

Latest revision as of 21:15, 24 July 2021

Query মানে প্রশ্ন হবে কিনা, সে কথা যাক, এই পাতাটি আমার উপপাতা, এর নাম প্রশ্নই থাক

কত্ত ভাষা

... Loading ...

আরেক

... Loading ...
... Loading ...

The most prolific speakers for the current month

... Loading ...