LinguaLibre
Difference between revisions of "Stats/Languages/scn"
< LinguaLibre:Stats
(Updating to match new version of source page) |
(Updating to match new version of source page) |
||
| (One intermediate revision by the same user not shown) | |||
| Line 2: | Line 2: | ||
{{LinguaLibre:Stats/Menu}} | {{LinguaLibre:Stats/Menu}} | ||
== Languages by number of recordings == | == Languages by number of recordings == | ||
| − | <query _pagination="10" lang=" Item (Language Qid)" langLabel=" Lingua" code=" Còdici ISO 639-3" | + | <query _pagination="10" lang=" Item (Language Qid)" langLabel=" Lingua" code=" Còdici ISO 639-3" numRecords=" Number of records" numSpeakers=" Number of speakers"> |
| − | SELECT ?lang ?langLabel ?code | + | SELECT ?lang ?langLabel ?code ?numRecords ?numSpeakers WHERE { |
| − | ?lang | + | { |
| − | + | SELECT ?lang (COUNT(?record) as ?numRecords) WHERE { | |
| − | + | ?record prop:P4 ?lang ; prop:P2 entity:Q2 | |
| − | + | } GROUP BY ?lang | |
| − | + | } | |
| − | ?lang | + | |
| + | { | ||
| + | SELECT ?lang (COUNT(DISTINCT ?recorder) as ?numSpeakers) WHERE { | ||
| + | ?record prop:P2 entity:Q2 ; | ||
| + | prop:P4 ?lang ; | ||
| + | prop:P5 ?recorder | ||
| + | } GROUP BY ?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> | ||
