Paste P7803

T208909 - Wikis by number of affected rows
ActivePublic

Authored by phuedx on Wed, Nov 14, 9:51 AM.
set mapred.job.queue.name=nice;
!set outputformat table
select
wiki_db as wiki,
count(distinct rev_page) as n
from
wmf_raw.mediawiki_revision
where
snapshot = '2018-09'
and rev_parent_id = 0
and rev_timestamp < '20050708000000'
and rev_timestamp > '20041011000000'
group by
wiki_db
order by
n desc
limit 1000
;
+-----------------------+---------+
| wiki | n |
+-----------------------+---------+
| bgwiktionary | 854560 |
| enwiki | 725565 |
| dewiki | 227603 |
| commonswiki | 159988 |
| frwiki | 129752 |
| jawiki | 110918 |
| nlwiki | 77196 |
| svwiki | 70249 |
| ptwiki | 61675 |
| plwiki | 53930 |
| enwiktionary | 52160 |
| zhwiki | 48817 |
| eswiki | 45654 |
| itwiki | 43402 |
| nowiki | 35375 |
| fiwiki | 32336 |
| ruwiki | 29494 |
| hewiki | 28822 |
| skwiki | 19284 |
| iowiktionary | 17701 |
| bgwiki | 17696 |
| dawiki | 17422 |
| slwiki | 17347 |
| itwiktionary | 17284 |
| kowiki | 16533 |
| nnwiki | 15896 |
| huwiki | 15135 |
| eowiki | 14956 |
| frwiktionary | 14663 |
| glwiktionary | 14084 |
| nlwiktionary | 13769 |
| cswiki | 13758 |
| cawiki | 13547 |
| ukwiki | 12389 |
| idwiki | 11560 |
| enwikinews | 11037 |
| plwiktionary | 9875 |
| metawiki | 8292 |
| enwikisource | 8123 |
| etwiki | 7903 |
| glwiki | 7892 |
| enwikibooks | 7775 |
| srwiki | 7697 |
| dewiktionary | 7638 |
| rowiki | 7353 |
| ltwiki | 6713 |
| scnwiktionary | 6347 |
| huwiktionary | 6161 |
| arwiki | 6101 |
| etwiktionary | 5839 |
| ptwiktionary | 5335 |
| viwiki | 5007 |
| lbwiki | 4966 |
| fiwiktionary | 4816 |
| kuwiktionary | 4683 |
| specieswiki | 4647 |
| dewikinews | 4634 |
| elwiki | 4523 |
| thwiki | 4520 |
| wawiki | 4470 |
| enwikiquote | 4435 |
| simplewiki | 4412 |
| iowiki | 4392 |
| iswiki | 4232 |
| enwikivoyage | 4046 |
| frwikisource | 4040 |
| trwiki | 3788 |
| hrwiki | 3561 |
| lawiktionary | 3523 |
| dewikiquote | 3408 |
| eswiktionary | 3350 |
| dewikibooks | 3068 |
| fawiki | 3038 |
| mswiki | 2998 |
| scnwiki | 2931 |
| lvwiki | 2896 |
| svwiktionary | 2870 |
| hiwiktionary | 2785 |
| jawiktionary | 2759 |
| sqwiki | 2709 |
| kawiki | 2662 |
| astwiki | 2655 |
| eswikibooks | 2635 |
| mrwiki | 2531 |
| be_x_oldwiki | 2377 |
| wawiktionary | 2358 |
| ttwiki | 2299 |
| afwiki | 2207 |
| mkwiki | 2171 |
| oswiki | 2170 |
| sourceswiki | 2169 |
| bswiki | 2043 |
| gawiki | 1952 |
| liwiki | 1922 |
| lawiki | 1911 |
| frwikibooks | 1882 |
| plwikiquote | 1837 |
| ndswiki | 1811 |
| knwiki | 1798 |
| rowikisource | 1771 |
+-----------------------+---------+
| wiki | n |
+-----------------------+---------+
| angwiktionary | 1726 |
| guwiktionary | 1692 |
| plwikinews | 1654 |
| eswikisource | 1576 |
| ruwiktionary | 1573 |
| ptwikinews | 1558 |
| jvwiki | 1543 |
| frwikinews | 1542 |
| zh_min_nanwiki | 1499 |
| angwiki | 1478 |
| kuwiki | 1413 |
| tlwiki | 1396 |
| fywiki | 1384 |
| ptwikiquote | 1321 |
| hiwiki | 1315 |
| eswikinews | 1309 |
| bgwikiquote | 1282 |
| eswikiquote | 1217 |
| gdwiki | 1199 |
| zhwiktionary | 1183 |
| dawiktionary | 1168 |
| nlwikibooks | 1149 |
| cowiktionary | 1110 |
| kowiktionary | 1108 |
| fowiki | 1101 |
| arwiktionary | 1067 |
| alswiki | 1064 |
| trwiktionary | 1043 |
| euwiki | 1021 |
| knwiktionary | 1018 |
| sewiki | 998 |
| tewiki | 981 |
| jawikiquote | 974 |
| srwiktionary | 972 |
| kawiktionary | 969 |
| sqwiktionary | 962 |
| rowikinews | 958 |
| itwikinews | 957 |
| swwiktionary | 949 |
| tawiki | 948 |
| cywiki | 941 |
| jawikibooks | 877 |
| itwikiquote | 852 |
| iawiki | 841 |
| mlwiki | 826 |
| hewikisource | 824 |
| scowiki | 810 |
| mtwiki | 774 |
| svwikinews | 759 |
| suwiki | 742 |
| brwiki | 737 |
| iawiktionary | 733 |
| ocwiki | 731 |
| cowiki | 728 |
| kowikibooks | 725 |
| dewikivoyage | 671 |
| miwiki | 662 |
| nowikiquote | 654 |
| guwiki | 644 |
| anwiki | 627 |
| zhwikisource | 594 |
| csbwiki | 591 |
| ptwikibooks | 572 |
| hewiktionary | 572 |
| bhwiki | 568 |
| plwikibooks | 563 |
| frwikivoyage | 549 |
| kwwiki | 547 |
| dawikibooks | 542 |
| cawiktionary | 531 |
| bnwiki | 531 |
| svwikibooks | 511 |
| hrwiktionary | 469 |
| hewikiquote | 461 |
| jawikisource | 438 |
| glwikiquote | 432 |
| nawiki | 431 |
| cswiktionary | 423 |
| nowiktionary | 415 |
| viwiktionary | 414 |
| sawikisource | 388 |
| thwiktionary | 382 |
| skwikibooks | 380 |
| zhwikiquote | 377 |
| frwikiquote | 368 |
| foundationwiki | 368 |
| cvwiki | 366 |
| glwikibooks | 365 |
| kawikiquote | 361 |
| dewikisource | 351 |
| itwikibooks | 343 |
| iewiki | 342 |
| hywiki | 325 |
| lawikisource | 324 |
| furwiki | 317 |
| bgwikibooks | 313 |
| fiwikibooks | 308 |
| nlwikimedia | 305 |
| yiwiki | 302 |
| hewikibooks | 292 |
+-----------------------+---------+
| wiki | n |
+-----------------------+---------+
| iewiktionary | 280 |
| svwikisource | 275 |
| enwikiversity | 275 |
| shwiki | 274 |
| zhwikibooks | 271 |
| jbowiki | 250 |
| nowikibooks | 247 |
| mediawikiwiki | 246 |
| frwikiversity | 243 |
| htwiki | 233 |
| viwikibooks | 224 |
| elwiktionary | 224 |
| ruwikibooks | 221 |
| fawikiquote | 209 |
| ruwikisource | 207 |
| ukwikinews | 202 |
| quwiki | 198 |
| bmwiki | 198 |
| itwikisource | 190 |
| cswikiquote | 190 |
| idwikiquote | 188 |
| svwikiquote | 187 |
| hywikibooks | 181 |
| nlwikiquote | 176 |
| ukwiktionary | 173 |
| newiki | 171 |
| lawikiquote | 169 |
| cebwiki | 168 |
| eowikibooks | 167 |
| urwiki | 165 |
| eowiktionary | 164 |
| sawiki | 158 |
| scwiki | 158 |
| rmwiki | 156 |
| rowiktionary | 155 |
| mnwiki | 151 |
| tpiwiki | 148 |
| bswiktionary | 144 |
| etwikibooks | 141 |
| arwikisource | 136 |
| bgwikinews | 134 |
| incubatorwiki | 134 |
| nlwikisource | 131 |
| lnwiki | 131 |
| ruwikiquote | 131 |
| nahwiki | 131 |
| dawikisource | 130 |
| rowikibooks | 130 |
| fiu_vrowiki | 127 |
| arwikibooks | 122 |
| iawikibooks | 121 |
| hawwiki | 118 |
| azwiki | 118 |
| svwikivoyage | 116 |
| mgwiki | 115 |
| slwikibooks | 114 |
| srwikinews | 113 |
| fiwikiquote | 112 |
| arzwiki | 107 |
| iuwiki | 107 |
| test2wiki | 105 |
| dvwiki | 104 |
| fawiktionary | 103 |
| ocwiktionary | 103 |
| bswikiquote | 103 |
| srwikibooks | 99 |
| hywiktionary | 99 |
| arwikiquote | 93 |
| ptwikisource | 91 |
| hrwikibooks | 91 |
| maiwiki | 89 |
| iswiktionary | 89 |
| mgwiktionary | 86 |
| suwiktionary | 85 |
| smwiki | 84 |
| elwikisource | 83 |
| bawiki | 83 |
| thwikibooks | 83 |
| tawiktionary | 82 |
| tlwikibooks | 80 |
| vowiki | 80 |
| betawikiversity | 79 |
| lbwiktionary | 78 |
| cswikibooks | 78 |
| bnwikibooks | 75 |
| zh_min_nanwiktionary | 74 |
| nnwiktionary | 73 |
| srwikisource | 70 |
| huwikiquote | 69 |
| gomwiki | 69 |
| sdwiki | 68 |
| towiki | 66 |
| avwiki | 64 |
| cywiktionary | 63 |
| amwiki | 63 |
| rowikiquote | 63 |
| kywiki | 61 |
| eswikiversity | 61 |
| sswiki | 60 |
| ruwikimedia | 60 |
+-----------------------+---------+
| wiki | n |
+-----------------------+---------+
| swwiki | 60 |
| dewikiversity | 59 |
| yowiki | 58 |
| cawikibooks | 57 |
| huwikibooks | 57 |
| itwikivoyage | 56 |
| idwiktionary | 56 |
| sswiktionary | 55 |
| ltwikibooks | 54 |
| elwikiquote | 54 |
| anwiktionary | 54 |
| simplewiktionary | 53 |
| kowikiquote | 52 |
| vowiktionary | 50 |
| urwikiquote | 50 |
| kshwiki | 47 |
| mrwiktionary | 45 |
| roa_rupwiki | 45 |
| eowikiquote | 44 |
| chrwiki | 44 |
| sawiktionary | 43 |
| nawiktionary | 43 |
| newiktionary | 42 |
| itwikiversity | 42 |
| bowiki | 41 |
| thwikiquote | 41 |
| dawikiquote | 40 |
| igwiki | 40 |
| slwiktionary | 40 |
| hifwiki | 40 |
| eowikisource | 39 |
| kowikisource | 39 |
| gotwiki | 38 |
| fywiktionary | 38 |
| trwikiquote | 38 |
| tkwiki | 38 |
| uzwiki | 37 |
| ltwikiquote | 37 |
| kkwiktionary | 37 |
| csbwiktionary | 36 |
| tumwiki | 35 |
| gvwiki | 35 |
| xhwiki | 34 |
| mrwikibooks | 34 |
| elwikiversity | 34 |
| tlwiktionary | 33 |
| nnwikiquote | 33 |
| pawiki | 33 |
| kswiki | 33 |
| testwiki | 33 |
| mlwiktionary | 32 |
| sdwiktionary | 32 |
| astwiktionary | 32 |
| miwiktionary | 31 |
| abwiki | 31 |
| kmwiki | 31 |
| kkwiki | 31 |
| skwiktionary | 31 |
| idwikibooks | 30 |
| pamwiki | 30 |
| pswiki | 29 |
| cawikinews | 28 |
| tetwiki | 28 |
| afwiktionary | 28 |
| klwiki | 27 |
| cywikibooks | 27 |
| svwikiversity | 27 |
| fawikibooks | 27 |
| ltwiktionary | 27 |
| tywiki | 26 |
| glwikisource | 26 |
| tgwiki | 26 |
| arwikiversity | 26 |
| elwikibooks | 24 |
| knwikisource | 24 |
| wowiki | 24 |
| tewiktionary | 23 |
| ruwikiversity | 23 |
| cawikiquote | 21 |
| mkwiktionary | 21 |
| urwiktionary | 21 |
| yiwiktionary | 21 |
| ttwikibooks | 21 |
| guwikiquote | 21 |
| biwiki | 21 |
| trwikibooks | 20 |
| ffwiki | 19 |
| afwikibooks | 19 |
| amwiktionary | 19 |
| cewiki | 18 |
| srwikiquote | 18 |
| skwikiquote | 18 |
| iswikiquote | 18 |
| piwiki | 17 |
| kswiktionary | 17 |
| zhwikivoyage | 16 |
| lowiki | 16 |
| aywiki | 16 |
| sowiki | 16 |
| aswiki | 15 |
+-----------------------+---------+
| wiki | n |
+-----------------------+---------+
| liwiktionary | 15 |
| mywiki | 15 |
| slwikiquote | 15 |
| fowiktionary | 15 |
| tcywiki | 14 |
| zuwiki | 14 |
| gnwiki | 14 |
| wikidatawiki | 14 |
| quwiktionary | 14 |
| orwiki | 14 |
| stqwiki | 14 |
| guwikisource | 13 |
| mhrwiki | 13 |
| mrwikisource | 13 |
| mlwikibooks | 13 |
| crwiki | 13 |
| kuwikibooks | 13 |
| viwikiquote | 13 |
| zawiki | 12 |
| stwiktionary | 12 |
| ptwikiversity | 12 |
| chywiki | 11 |
| kvwiki | 11 |
| tpiwiktionary | 11 |
| smwiktionary | 11 |
| gawiktionary | 11 |
| outreachwiki | 11 |
| nvwiki | 11 |
| hewikivoyage | 11 |
| knwikiquote | 10 |
| tawikisource | 10 |
| stwiki | 10 |
| fjwiki | 10 |
| nostalgiawiki | 10 |
| lgwiki | 10 |
| rowikivoyage | 10 |
| ttwiktionary | 10 |
| ckbwiki | 9 |
| fiwikisource | 9 |
| hiwikibooks | 9 |
| ugwiki | 9 |
| dzwiki | 9 |
| nowikisource | 9 |
| iswikibooks | 8 |
| tnwiki | 8 |
| lawikibooks | 8 |
| arcwiki | 8 |
| brwiktionary | 8 |
| hiwikiquote | 8 |
| kgwiki | 8 |
| mswiktionary | 8 |
| jvwiktionary | 8 |
| cswikiversity | 8 |
| bewikisource | 8 |
| mtwiktionary | 8 |
| siwiki | 8 |
| cowikimedia | 7 |
| hewikinews | 7 |
| mlwikisource | 7 |
| mgwikibooks | 7 |
| bnwiktionary | 7 |
| tiwiki | 7 |
| hywikiquote | 7 |
| omwiki | 7 |
| fiwikiversity | 7 |
| eswikivoyage | 7 |
| ukwikisource | 7 |
| chwiki | 6 |
| ukwikibooks | 6 |
| euwiktionary | 6 |
| akwiki | 6 |
| pflwiki | 6 |
| nywiki | 6 |
| hiwikiversity | 6 |
| hawiki | 6 |
| kiwiki | 6 |
| sgwiki | 6 |
| dvwiktionary | 6 |
| gnwiktionary | 6 |
| brwikimedia | 6 |
| pswiktionary | 5 |
| rwwiki | 5 |
| mrwikiquote | 5 |
| lnwiktionary | 5 |
| twwiki | 5 |
| mswikibooks | 5 |
| vewiki | 5 |
| tswiki | 4 |
| nahwiktionary | 4 |
| sahwikisource | 4 |
| ikwiki | 4 |
| hrwikiquote | 4 |
| snwiki | 4 |
| rnwiki | 4 |
| lvwiktionary | 4 |
| eewiki | 4 |
| cywikisource | 4 |
| tnwiktionary | 3 |
| wuuwiki | 3 |
| afwikiquote | 3 |
+-----------------------+---------+
| wiki | n |
+-----------------------+---------+
| hrwikisource | 3 |
| orwiktionary | 3 |
| cswikisource | 3 |
| shwiktionary | 2 |
| tewikisource | 2 |
| pawiktionary | 2 |
| ukwikiquote | 2 |
| aywiktionary | 2 |
| omwiktionary | 2 |
| jbowiktionary | 2 |
| ndswiktionary | 2 |
| viwikisource | 2 |
| chrwiktionary | 2 |
| tewikiquote | 2 |
| nowikimedia | 2 |
| mlwikiquote | 2 |
| uzwiktionary | 2 |
| iuwiktionary | 2 |
| etwikiquote | 2 |
| brwikisource | 2 |
| azwiktionary | 2 |
| wikimania2015wiki | 2 |
| plwikisource | 2 |
| mnwiktionary | 1 |
| sowiktionary | 1 |
| tiwiktionary | 1 |
| wowikiquote | 1 |
| fawikivoyage | 1 |
| uzwikiquote | 1 |
| liwikibooks | 1 |
| bswikibooks | 1 |
| mwlwiki | 1 |
| sgwiktionary | 1 |
| sqwikiquote | 1 |
| hawiktionary | 1 |
| tswiktionary | 1 |
| euwikiquote | 1 |
| fawikisource | 1 |
| mywiktionary | 1 |
| azwikibooks | 1 |
| ruwikinews | 1 |
| bewikiquote | 1 |
| newikibooks | 1 |
| siwiktionary | 1 |
| kkwikibooks | 1 |
| bewiktionary | 1 |
| wowiktionary | 1 |
| tawikibooks | 1 |
| tawikiquote | 1 |
| etwikisource | 1 |
| acewiki | 1 |
| pawikibooks | 1 |
| frrwiki | 1 |
| zuwiktionary | 1 |
| kywiktionary | 1 |
| urwikibooks | 1 |
| uawikimedia | 1 |
| gdwiktionary | 1 |
| mkwikibooks | 1 |
| klwiktionary | 1 |
| azwikiquote | 1 |
| lmowiki | 1 |
| fywikibooks | 1 |
| fjwiktionary | 1 |
| pnbwiki | 1 |
| ugwiktionary | 1 |
| szlwiki | 1 |
| kmwiktionary | 1 |
| suwikiquote | 1 |
| pcdwiki | 1 |
| lowiktionary | 1 |
| sewikimedia | 1 |
| vecwikisource | 1 |
| kywikiquote | 1 |
| gvwiktionary | 1 |
| kuwikiquote | 1 |
| tgwiktionary | 1 |
| roa_rupwiktionary | 1 |
| euwikibooks | 1 |
| wikimania2016wiki | 1 |
| lezwiki | 1 |
| cvwikibooks | 1 |
| tkwiktionary | 1 |
| rwwiktionary | 1 |
| kwwiktionary | 1 |
+-----------------------+---------+