|
|
Line 18: |
Line 18: |
| } | | } |
| </query> | | </query> |
− | == Monthly activity ==
| |
| | | |
− | <query yearmonth="Date" records="New records" speakers="Active speakers" languages="Active languages">
| + | Subpages: |
− | SELECT
| + | * [[LinguaLibre:Stats/Users]] |
− | ?yearmonth
| + | * [[LinguaLibre:Stats/Languages]] |
− | (COUNT(DISTINCT ?record) AS ?records)
| |
− | (COUNT(DISTINCT ?speaker) AS ?speakers)
| |
− | (COUNT(DISTINCT ?language) AS ?languages)
| |
− | WHERE {
| |
− | ?record prop:P2 entity:Q2 .
| |
− | ?record prop:P6 ?date .
| |
− | ?record prop:P5 ?speaker .
| |
− | ?record prop:P4 ?language .
| |
− | BIND( SUBSTR(str(?date), 0, 8) as ?yearmonth )
| |
− | }
| |
− | GROUP BY ?yearmonth
| |
− | ORDER BY ?yearmonth
| |
− | </query>
| |
− | == Number of records per languages ==
| |
− | | |
− | <query _pagination="10" language="Item (Language Qid)" code="ISO 639-3 code" nb="Number of records">
| |
− | select ?language ?languageLabel ?code (COUNT(DISTINCT ?record) as ?nb)
| |
− | where {
| |
− | ?record prop:P2 entity:Q2 .
| |
− | ?record prop:P4 ?language .
| |
− | OPTIONAL { ?language prop:P13 ?code }
| |
− | OPTIONAL { ?language rdfs:label ?languageLabel . FILTER (lang(?languageLabel) = "en"). }
| |
− | }
| |
− | GROUP BY ?language ?languageLabel ?code
| |
− | ORDER BY DESC(?nb)
| |
− | </query><!-- Just insert corresponding language code instead of "en" -->
| |
− | | |
− | == The most prolific speakers ==
| |
− | | |
− | <query _pagination="10" locutor="Item (locutor Qid)" locutorLabel="Speaker" nb="Number of records">
| |
− | SELECT ?locutor ?locutorLabel ?nb WHERE {
| |
− | {
| |
− | SELECT ?locutor (COUNT(?record) as ?nb)
| |
− | WHERE {
| |
− | ?record prop:P2 entity:Q2 . # Q2: record, P2: instance of.
| |
− | ?record prop:P5 ?locutor . # Property:P5: speaker
| |
− | }
| |
− | GROUP BY ?locutor ?locutorLabel
| |
− | ORDER BY DESC(?nb)
| |
− | LIMIT 50
| |
− | }
| |
− | SERVICE wikibase:label {
| |
− | bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
| |
− | ?locutor rdfs:label ?locutorLabel .
| |
− | }
| |
− | }
| |
− | ORDER BY DESC(?nb)
| |
− | </query>
| |
− | | |
− | == The most prolific speakers for the current month ==
| |
− | | |
− | <query _pagination="10" locutor="Item (locutor Qid)" locutorLabel="Speaker" nb="Number of records for the current month">
| |
− | SELECT ?locutor ?locutorLabel ?nb WHERE {
| |
− | {
| |
− | SELECT ?locutor (COUNT(?record) as ?nb)
| |
− | WHERE {
| |
− | ?record prop:P2 entity:Q2 . # Q2: record, P2: instance of.
| |
− | ?record prop:P5 ?locutor . # Property:P5: speaker
| |
− | ?record prop:P6 ?date .
| |
− | FILTER ( YEAR(?date) = YEAR(NOW()) && MONTH(?date) = MONTH(NOW()) )
| |
− | }
| |
− | GROUP BY ?locutor ?locutorLabel
| |
− | ORDER BY DESC(?nb)
| |
− | LIMIT 50
| |
− | }
| |
− | SERVICE wikibase:label {
| |
− | bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
| |
− | ?locutor rdfs:label ?locutorLabel .
| |
− | }
| |
− | }
| |
− | ORDER BY DESC(?nb)
| |
− | </query>
| |
| | | |
| __NOTOC__ | | __NOTOC__ |