|
|
| Line 18: |
Line 18: |
| | } | | } |
| | </query> | | </query> |
| − | == Activité mensuelle ==
| |
| | | | |
| − | <query yearmonth="Date" records="Nouveaux enregistrements" speakers="Locuteurs actifs" languages="Langues actives">
| + | 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>
| |
| − | == Nombre d'enregistrements par langue ==
| |
| − | | |
| − | <query _pagination="10" language="Élément (identifiant de la langue)" code="code ISO 639-3" nb="Nombre d'enregistrements">
| |
| − | 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) = "fr"). }
| |
| − | }
| |
| − | GROUP BY ?language ?languageLabel ?code
| |
| − | ORDER BY DESC(?nb)
| |
| − | </query><!-- Just insert corresponding language code instead of "en" -->
| |
| − | | |
| − | == Locuteurs les plus prolifiques ==
| |
| − | | |
| − | <query _pagination="10" locutor="Élément (identifiant du locuteur)" locutorLabel="Locuteur" nb="Nombre d'enregistrements">
| |
| − | 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>
| |
| − | | |
| − | == Locuteurs les plus prolifiques pour le mois en cours ==
| |
| − | | |
| − | <query _pagination="10" locutor="Élément (Qid du locuteur)" locutorLabel="Locuteur" nb="Nombre d'enregistrements pour le mois en cours">
| |
| − | 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__ |