LinguaLibre

Difference between revisions of "Stats"

(Page créée avec « == Number of records per languages == <query> select ?language (if( ?language = entity:Q4, '???', ?languageLabel ) as ?name) (COUNT(?record) as ?nb) where {... »)
 
Line 13: Line 13:
 
         }
 
         }
 
     }
 
     }
     GROUP BY ?language ?languageLabel ?patate
+
     GROUP BY ?language ?languageLabel
 
     ORDER BY DESC(?nb)
 
     ORDER BY DESC(?nb)
 
</query>
 
</query>
Line 33: Line 33:
 
     }
 
     }
 
     GROUP BY ?transcription
 
     GROUP BY ?transcription
 +
    ORDER BY DESC(?nb)
 +
    LIMIT 10
 +
</query>
 +
 +
== 10 most prolific locutors ==
 +
<query>
 +
    select ?locutor ?locutorLabel (COUNT(?record) as ?nb)
 +
    where {
 +
        ?record prop:P2 entity:Q2 .
 +
        ?record prop:P5 ?locutor .
 +
        ?record prop:P4 ?lang .
 +
        #extra:{"type": "wikibase-item", "filter":"Q4", "label": "P4", "multiple": true} ?record prop:P4 entity:[EXTRA] .
 +
 +
      BIND( IF( isBLANK(?lang), entity:Q4, ?lang ) as ?language ).
 +
     
 +
        SERVICE wikibase:label {
 +
            bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
 +
        }
 +
    }
 +
    GROUP BY ?locutor ?locutorLabel
 
     ORDER BY DESC(?nb)
 
     ORDER BY DESC(?nb)
 
     LIMIT 10
 
     LIMIT 10
 
</query>
 
</query>

Revision as of 15:42, 11 April 2018

Number of records per languages

... Loading ...

10 most recorded words

... Loading ...

10 most prolific locutors

... Loading ...