User:Akkakk/issues/deprecated-languages/stat
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 |