Open main menu

User:Akkakk/issues/link without label/stat

select count(*), lang_wd, lang_db from wb_items_per_site join s51880_akkakkbot.languages on lang_db = ips_site_id and ips_site_page not like "%, %" and ips_site_page not like "% (%)" and not exists (select term_language from wb_terms where ips_item_id = term_entity_id and lang_wd = term_language and term_type = "label") group by lang_wd, lang_db order by count(*) desc;

1 1526 zh zhwiki
2 1136 uk ukwiki
3 1071 ru ruwiki
4 851 pt ptwiki
5 690 ur urwiki
6 561 tr trwiki
7 471 ro rowiki
8 405 it itwiki
9 398 sv svwiki
10 384 nan zh_min_nanwiki
11 335 vi viwiki
12 301 th thwiki
13 176 sr srwiki
14 172 sco scowiki
15 157 yue zh_yuewiki
16 148 sh shwiki
17 139 sl slwiki
18 131 sw swwiki
19 124 ta tawiki
20 113 sk skwiki
21 93 fr frwiki
22 83 vep vepwiki
23 76 tet tetwiki
24 74 rup roa_rupwiki
25 65 sah sahwiki
26 58 tl tlwiki
27 50 tt ttwiki
28 49 sq sqwiki
29 47 nl nlwiki
30 38 ps pswiki
31 38 pl plwiki
32 38 es eswiki
33 37 ja jawiki
34 36 yi yiwiki
35 35 udm udmwiki
36 33 ko kowiki
37 29 tg tgwiki
38 29 la lawiki
39 28 nb nowiki
40 27 bg bgwiki
41 26 ba bawiki
42 25 te tewiki
43 24 ca cawiki
44 24 id idwiki
45 24 kk kkwiki
46 24 hsb hsbwiki
47 23 en enwiki
48 22 de dewiki
49 22 xmf xmfwiki
50 19 uz uzwiki
51 17 be bewiki
52 17 hy hywiki
53 16 tyv tyvwiki
54 15 fi fiwiki
55 15 pnb pnbwiki
56 15 tk tkwiki
57 14 pms pmswiki
58 14 wuu wuuwiki
59 14 be-tarask be_x_oldwiki
60 14 da dawiki
61 13 ar arwiki
62 13 ka kawiki
63 12 cs cswiki
64 10 az azwiki
65 10 he hewiki
66 9 eo eowiki
67 9 lv lvwiki
68 9 mrj mrjwiki
69 8 eu euwiki
70 8 ne newiki
71 8 lzh zh_classicalwiki
72 7 en simplewiki
73 7 xh xhwiki
74 7 si siwiki
75 7 war warwiki
76 6 fa fawiki
77 6 et etwiki
78 6 zea zeawiki
79 6 el elwiki
80 6 an anwiki
81 5 wa wawiki
82 5 vo vowiki
83 5 stq stqwiki
84 5 tn tnwiki
85 4 gsw alswiki
86 4 my mywiki
87 4 so sowiki
88 4 fo fowiki
89 4 bs bswiki
90 4 sa sawiki
91 4 vec vecwiki
92 3 vls vlswiki
93 3 ms mswiki
94 3 hi hiwiki
95 3 pa pawiki
96 3 cv cvwiki
97 3 scn scnwiki
98 3 nn nnwiki
99 3 oc ocwiki
100 3 hr hrwiki
101 3 br brwiki
102 3 hu huwiki
103 3 ceb cebwiki
104 3 bar barwiki
105 3 bh bhwiki
106 3 pnt pntwiki
107 3 qu quwiki
108 3 sc scwiki
109 2 ml mlwiki
110 2 gl glwiki
111 2 yo yowiki
112 2 io iowiki
113 2 xal xalwiki
114 2 su suwiki
115 2 rue ruewiki
116 1 af afwiki
117 1 ga gawiki
118 1 sgs bat_smgwiki
119 1 bn bnwiki
120 1 ht htwiki
121 1 ts tswiki
122 1 min minwiki
123 1 sd sdwiki
124 1 mn mnwiki
125 1 fy fywiki
126 1 gd gdwiki
127 1 gu guwiki
128 1 pfl pflwiki
129 1 cy cywiki
130 1 jv jvwiki
131 1 ug ugwiki
132 1 mk mkwiki
133 1 gan ganwiki
134 1 glk glkwiki
135 1 nov novwiki
136 1 pap papwiki
137 1 szl szlwiki
138 1 eml emlwiki
139 1 ku kuwiki
140 1 mg mgwiki