LinguaLibre
Difference between revisions of "Stats/Languages/ru"
< LinguaLibre:Stats
(Updating to match new version of source page) |
|||
(4 intermediate revisions by one other user not shown) | |||
Line 1: | Line 1: | ||
<languages/> | <languages/> | ||
{{LinguaLibre:Stats/Menu}} | {{LinguaLibre:Stats/Menu}} | ||
− | == | + | == Языки по числу говорящих == |
− | <query _pagination="10" lang=" | + | <query _pagination="10" lang=" Объект (Qid языка)" langLabel=" Язык" code=" Код ISO 639-3" numRecords=" Количество записей" numSpeakers=" Количество говорящих"> |
− | SELECT ?lang ?langLabel ?code ? | + | SELECT ?lang ?langLabel ?code ?numRecords ?numSpeakers WHERE { |
{ | { | ||
− | SELECT ?lang (COUNT(?record) as ? | + | SELECT ?lang (COUNT(?record) as ?numRecords) WHERE { |
?record prop:P4 ?lang ; prop:P2 entity:Q2 | ?record prop:P4 ?lang ; prop:P2 entity:Q2 | ||
} GROUP BY ?lang | } GROUP BY ?lang | ||
} | } | ||
− | + | { | |
− | + | SELECT ?lang (COUNT(DISTINCT ?recorder) as ?numSpeakers) WHERE { | |
− | + | ?record prop:P2 entity:Q2 ; | |
− | + | prop:P4 ?lang ; | |
− | + | prop:P5 ?recorder | |
− | + | } GROUP BY ?lang | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | SELECT ?lang | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
} | } | ||
− | ?lang prop:P2 entity:Q4 | + | ?lang prop:P2 entity:Q4 |
OPTIONAL { ?lang prop:P13 ?code } | OPTIONAL { ?lang prop:P13 ?code } | ||
− | + | ||
SERVICE wikibase:label { | SERVICE wikibase:label { | ||
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . | bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . | ||
?lang rdfs:label ?langLabel . | ?lang rdfs:label ?langLabel . | ||
} | } | ||
− | } | + | } ORDER BY DESC(?numRecords) |
− | ORDER BY DESC(? | ||
</query> | </query> | ||