User

Difference between revisions of "Lepticed7"

(Created page with "<query _pagination="10" locutor="Élément (Qid du locuteur ou de la locutrice)" locutorLabel="Locuteur ou locutrice" nb="Nombre d'enregistrements" languages="Langues parlées...")
 
 
(7 intermediate revisions by 3 users not shown)
Line 1: Line 1:
 
<query _pagination="10" locutor="Élément (Qid du locuteur ou de la locutrice)" locutorLabel="Locuteur ou locutrice" nb="Nombre d'enregistrements" languages="Langues parlées">
 
<query _pagination="10" locutor="Élément (Qid du locuteur ou de la locutrice)" locutorLabel="Locuteur ou locutrice" nb="Nombre d'enregistrements" languages="Langues parlées">
     select ?language ?languageLabel ?code (COUNT(DISTINCT ?record) as ?nb)
+
     select ?languageLabel (COUNT(DISTINCT ?record) as ?nb)
 
where {
 
where {
 
   ?record prop:P2 entity:Q2 .
 
   ?record prop:P2 entity:Q2 .
 
   ?record prop:P4 ?language .
 
   ?record prop:P4 ?language .
 
   ?record prop:P5 entity:Q51319 .
 
   ?record prop:P5 entity:Q51319 .
  OPTIONAL { ?language prop:P13 ?code }
 
 
   OPTIONAL { ?language rdfs:label ?languageLabel . FILTER (lang(?languageLabel) = "fr"). }
 
   OPTIONAL { ?language rdfs:label ?languageLabel . FILTER (lang(?languageLabel) = "fr"). }
 
}
 
}
Line 11: Line 10:
 
ORDER BY DESC(?nb)
 
ORDER BY DESC(?nb)
 
</query>
 
</query>
 +
 +
<query _pagination="10" 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:P5 ?locutor .
 +
    }
 +
    GROUP BY ?locutor ?locutorLabel
 +
    ORDER BY DESC(?nb)
 +
    LIMIT 10
 +
  }
 +
  SERVICE wikibase:label {
 +
    bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
 +
    ?locutor rdfs:label ?locutorLabel .
 +
  }
 +
}
 +
ORDER BY DESC(?nb)
 +
</query>
 +
{{#babel:records-fra|records-epo|records-eng}}
 +
{{Userboxtop|Rewards}}
 +
{{Speaker of the month|11/2018|361}}
 +
{{Speaker of the month|12/2018|4423}}
 +
{{Speaker of the month|03/2019|5898}}
 +
{{Userboxbottom}}

Latest revision as of 10:20, 30 November 2023

... Loading ...
... Loading ...
Babel user information
fra
epo
eng
Users by language
Rewards
SPEAKER OF THE MONTH - 11/2018


SPEAKER OF THE MONTH - 12/2018


SPEAKER OF THE MONTH - 03/2019