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 | + | 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 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
Babel user information | ||||||
---|---|---|---|---|---|---|
| ||||||
Users by language |
Rewards |
---|
|