Home
Phabricator
Search
Log In
Paste
P7803
T208909  Wikis by number of affected rows
Active
Public
Actions
Authored by
phuedx
on Wed, Nov 14, 9:51 AM.
Edit Paste
Archive Paste
View Raw File
Subscribe
Mute Notifications
Award Token
Flag For Later
Tags
None
Subscribers
None
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
=
'201809'
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

+
++
phuedx
created this paste.
Wed, Nov 14, 9:51 AM
phuedx
mentioned this in
T208909: [Bug] Update old nonuniformly distributed page_random values
.
Wed, Nov 14, 9:57 AM
Log In to Comment