LinguaLibre
Difference between revisions of "Stats/Languages/de"
< LinguaLibre:Stats
(Created page with "Sprecher") |
Ameisenigel (talk | contribs) (Created page with "== Siehe auch ==") |
||
(18 intermediate revisions by 3 users not shown) | |||
Line 1: | Line 1: | ||
<languages/> | <languages/> | ||
+ | {{LinguaLibre:Stats/Menu}} | ||
+ | == Sprachen nach Anzahl der Aufnahmen == | ||
+ | <query _pagination="10" lang=" Datenobjekt (Sprach-QID)" langLabel=" Sprache" code=" ISO 639-3 Code" nb=" Anzahl der Aufnahmen"> | ||
+ | SELECT ?lang ?langLabel ?code ?nb WHERE { | ||
+ | { | ||
+ | SELECT ?lang (COUNT(?record) as ?nb) WHERE { | ||
+ | ?record prop:P4 ?lang ; prop:P2 entity:Q2 | ||
+ | } GROUP BY ?lang | ||
+ | } | ||
+ | |||
+ | ?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(?nb) |
− | |||
− | ORDER BY DESC(?nb) | ||
</query> | </query> | ||
− | == | + | == Sprachen nach Anzahl der Sprecher == |
− | <query _pagination="10" lang=" | + | <query _pagination="10" lang=" Datenobjekt (Sprach-QID)" langLabel=" Sprache" code=" ISO 639-3 Code" nb=" Anzahl der Sprecher"> |
− | SELECT ?lang ?langLabel ?code ( | + | SELECT ?lang ?langLabel ?code (COUNT(?recorder) as ?nb) WHERE { |
− | ?lang prop:P2 entity: | + | |
− | + | { | |
+ | SELECT ?lang ?recorder WHERE { | ||
+ | ?record prop:P2 entity:Q2 ; | ||
+ | prop:P4 ?lang ; | ||
+ | prop:P5 ?recorder | ||
+ | } GROUP BY ?lang ?recorder | ||
+ | } | ||
+ | |||
+ | ?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 . | ||
} | } | ||
− | } | + | } GROUP BY ?lang ?langLabel ?code |
− | GROUP BY ?lang ?langLabel ?code | ||
ORDER BY DESC(?nb) | ORDER BY DESC(?nb) | ||
</query> | </query> | ||
+ | |||
+ | == Siehe auch == | ||
+ | * [[LinguaLibre:List of languages]] | ||
+ | |||
+ | [[Category:Lingua Libre:DataViz{{#translation:}}]] |
Latest revision as of 19:38, 8 September 2023
Sprachen nach Anzahl der Aufnahmen