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...") |
|||
| 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"). } | ||
} | } | ||
GROUP BY ?language ?languageLabel ?code | GROUP BY ?language ?languageLabel ?code | ||
ORDER BY DESC(?nb) | ORDER BY DESC(?nb) | ||
| + | </query> | ||
| + | |||
| + | <query _pagination="10" locutor="Item (locutor Qid)" locutorLabel="Speaker" nb="Number of records" languages="Spoken languages"></translate> | ||
| + | select ?locutorLabel (COUNT(?record) as ?nb) | ||
| + | where { | ||
| + | ?record prop:P2 entity:Q2 . | ||
| + | ?record prop:P5 ?locutor . | ||
| + | ?record prop:P4 ?lang . | ||
| + | #extra:{"type": "wikibase-item", "filter":"Q4", "label": "P4", "multiple": true} ?record prop:P4 entity:[EXTRA] . | ||
| + | SERVICE wikibase:label { | ||
| + | bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . | ||
| + | ?locutor rdfs:label ?locutorLabel . | ||
| + | } | ||
| + | } | ||
| + | GROUP BY ?locutor ?locutorLabel | ||
| + | ORDER BY DESC(?nb) | ||
| + | LIMIT 3 | ||
</query> | </query> | ||