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       |
+-----------------------+---------+