User:Akkakk/issues/deprecated-languages/stat

From Wikidata
Jump to navigation Jump to search

select count(*), term_language, term_type from wb_terms where term_entity_type = "item" and (term_language = "als" or term_language = "de-formal" or term_language = "crh" or term_language = "no" or term_language = "simple" or term_language = "bat-smg" or term_language = "be-x-old" or term_language = "fiu-vro" or term_language = "roa-rup" or term_language = "zh-classical" or term_language = "zh-min-nan" or term_language = "zh-yue" or term_language = "nl-informal") group by term_language, term_type order by term_language, term_type;

1 3 als alias
2 1 als description
3 336 als label
4 2 be-x-old alias
5 258 be-x-old description
6 1164 be-x-old label
7 3 de-formal alias
8 1 fiu-vro alias
9 1 fiu-vro label
10 76 no description
11 1791 no label
12 20 simple alias
13 5302 simple description
14 25026 simple label
15 1 zh-min-nan label