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 |