|
|
| 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__ |