Page MenuHomePhabricator
Paste P15671

Count links to Reuters website domain across all wikis
ActivePublic

Authored by Nemo_bis on Sun, May 2, 7:23 AM.
nemobis@tools-sgebastion-07:~$ echo "SELECT dbname FROM wiki WHERE size > 1 AND is_closed = 0;" | sql meta_p | tail -n +2 | for dbname in $(cat); do links=`echo 'SELECT COUNT(*) as links from externallinks JOIN page on el_from = page_id and page_namespace = 0 and ( el_index LIKE "http://com.reuters%" OR el_index LIKE "https://com.reuters%");' | sql ${dbname} | tail -n 1` ; echo -e "${dbname}\t${links}" ; sleep 0.1s; done | tee /dev/stderr | cut -f2 | paste -sd+ | bc
abwiki 0
acewiki 1
afwiki 279
afwiktionary 0
alswiki 9
amwiki 9
angwiki 2
anwiki 10
arwiki 11628
arwikibooks 0
arwikinews 339
arwikiquote 3
arwikisource 0
arwikiversity 3
arwiktionary 2
arzwiki 205
astwiki 714
astwiktionary 0
aswiki 65
azbwiki 147
azwiki 685
azwikisource 0
azwiktionary 0
barwiki 8
bat_smgwiki 0
bawiki 62
bclwiki 31
betawikiversity 1
bewiki 520
bewikisource 0
be_x_oldwiki 106
bgwiki 581
bgwikiquote 0
bgwiktionary 0
bhwiki 23
bjnwiki 4
bnwiki 1082
bnwikisource 0
bnwiktionary 0
bowiki 0
bpywiki 0
brwiki 14
brwikisource 0
brwiktionary 0
bswiki 239
bswiktionary 0
bugwiki 0
cawiki 2282
cawikinews 37
cawikiquote 1
cawikisource 0
cawiktionary 0
cdowiki 1
cebwiki 17
cewiki 8
chrwiktionary 0
ckbwiki 168
commonswiki 1
cowiki 1
cowiktionary 0
crhwiki 2
cswiki 1407
cswikinews 129
cswikiquote 4
cswikisource 0
cswikiversity 0
cswiktionary 0
cvwiki 15
cywiki 137
cywiktionary 0
dawiki 889
dawikisource 0
dawiktionary 0
dewiki 6771
dewikibooks 0
dewikinews 1047
dewikiquote 6
dewikisource 0
dewikiversity 1
dewikivoyage 0
dewiktionary 6
diqwiki 8
dsbwiki 0
dtywiki 8
dvwiki 0
elwiki 4456
elwikinews 31
elwikisource 0
elwiktionary 0
emlwiki 0
enwiki 84075
enwikibooks 192
enwikinews 2480
enwikiquote 225
enwikisource 21
enwikiversity 82
enwikivoyage 1
enwiktionary 53
eowiki 194
eowiktionary 0
eswiki 8358
eswikibooks 0
eswikinews 828
eswikiquote 7
eswikisource 0
eswikiversity 0
eswiktionary 1
etwiki 3629
etwikisource 0
etwiktionary 0
euwiki 154
euwiktionary 0
fawiki 2816
fawikibooks 0
fawikinews 11
fawikiquote 11
fawikisource 0
fawikivoyage 0
fawiktionary 0
fiu_vrowiki 0
fiwiki 1921
fiwikibooks 0
fiwikisource 0
fiwiktionary 0
fjwiktionary 0
fowiki 46
frrwiki 0
frwiki 11235
frwikibooks 0
frwikinews 566
frwikiquote 8
frwikisource 0
frwikiversity 0
frwikivoyage 0
frwiktionary 10
fywiki 5
fywiktionary 0
ganwiki 0
gawiki 20
gdwiki 5
glkwiki 0
glwiki 489
glwiktionary 0
guwiki 161
guwikisource 0
gvwiki 1
hakwiki 0
hewiki 1665
hewikibooks 0
hewikiquote 0
hewikisource 0
hewikivoyage 2
hewiktionary 0
hifwiki 1
hiwiki 699
hiwiktionary 0
hrwiki 528
hrwikisource 0
hrwiktionary 0
hsbwiki 0
htwiki 27
huwiki 2183
huwikibooks 0
huwikisource 0
huwiktionary 0
hywiki 1463
hywikisource 0
hywiktionary 0
iawiki 6
idwiki 3351
idwikibooks 1
idwikimedia 0
idwikisource 0
idwiktionary 0
ilowiki 18
incubatorwiki 56
iowiki 48
iowiktionary 0
iswiki 78
iswiktionary 0
itwiki 4545
itwikibooks 1
itwikinews 140
itwikiquote 11
itwikisource 1
itwikiversity 0
itwikivoyage 0
itwiktionary 0
jawiki 11986
jawikibooks 0
jawikinews 119
jawikisource 1
jawiktionary 1
jvwiki 104
jvwiktionary 0
kabwiki 2
kawiki 583
kawiktionary 0
kkwiki 141
kmwiki 40
kmwiktionary 0
knwiki 328
knwikisource 0
knwiktionary 0
kowiki 1754
kowikisource 0
kowiktionary 0
krcwiki 2
kshwiki 2
kuwiki 40
kuwiktionary 0
kvwiki 0
kywiki 17
kywiktionary 0
ladwiki 5
lawiki 95
lawikisource 0
lawiktionary 0
lbewiki 0
lbwiki 15
lbwiktionary 0
lezwiki 3
lijwiki 0
liwiki 39
liwiktionary 0
lmowiki 8
lowiki 19
lowiktionary 0
ltwiki 254
ltwiktionary 0
lvwiki 244
lvwiktionary 0
maiwiki 14
map_bmswiki 1
mediawikiwiki 0
metawiki 52
mgwiki 14
mgwiktionary 0
mhrwiki 0
minwiki 29
miwiki 0
mkwiki 553
mlwiki 356
mlwikisource 0
mlwiktionary 0
mnwiki 57
mnwiktionary 0
mrjwiki 1
mrwiki 69
mrwikisource 0
mswiki 1718
mtwiki 18
myvwiki 0
mywiki 202
mywiktionary 0
mznwiki 42
nahwiki 0
napwiki 1
ndswiki 14
ndswiktionary 0
nds_nlwiki 4
newiki 150
newiktionary 0
newwiki 1
nlwiki 1577
nlwikibooks 1
nlwikinews 113
nlwikisource 0
nlwikivoyage 0
nlwiktionary 0
nnwiki 179
nnwiktionary 0
nostalgiawiki 0
nowiki 1208
nowikisource 0
nowiktionary 0
nvwiki 0
ocwiki 19
ocwiktionary 0
orwiki 54
orwiktionary 0
oswiki 5
outreachwiki 2
pamwiki 20
pawiki 198
pawikisource 0
pawiktionary 0
plwiki 4092
plwikibooks 0
plwikinews 102
plwikiquote 7
plwikisource 0
plwiktionary 3
pmswiki 1
pnbwiki 381
pnbwiktionary 0
pswiki 15
pswiktionary 0
ptwiki 6072
ptwikibooks 1
ptwikinews 739
ptwikiquote 10
ptwikisource 0
ptwikiversity 4
ptwiktionary 0
quwiki 1
roa_tarawiki 0
rowiki 1267
rowikisource 0
rowiktionary 0
ruewiki 4
ruwiki 7376
ruwikibooks 0
ruwikinews 403
ruwikiquote 3
ruwikisource 0
ruwikiversity 0
ruwikivoyage 0
ruwiktionary 0
sahwiki 7
sawiki 11
sawikisource 0
sawiktionary 0
scnwiki 2
scnwiktionary 0
scowiki 187
scwiki 11
sdwiki 33
sewiki 2
sewikimedia 0
shwiki 431
shwiktionary 0
simplewiki 1081
simplewiktionary 0
siwiki 96
skwiki 244
skwiktionary 0
slwiki 423
slwikisource 0
slwiktionary 0
snwiki 1
sourceswiki 0
sowiki 37
specieswiki 0
sqwiki 314
sqwiktionary 0
srwiki 1128
srwikinews 11
srwikisource 0
srwiktionary 0
stqwiki 0
suwiki 48
svwiki 1525
svwikisource 0
svwikivoyage 0
svwiktionary 1
swwiki 113
swwiktionary 0
szlwiki 3
tawiki 951
tawikinews 225
tawikisource 0
tawiktionary 0
test2wiki 23
testwiki 239
testwikidatawiki 0
tewiki 341
tewikisource 0
tewiktionary 0
tgwiki 52
tgwiktionary 0
thwiki 1544
thwikibooks 0
thwikisource 0
thwiktionary 0
tkwiki 2
tlwiki 303
tlwiktionary 0
trwiki 2353
trwikiquote 0
trwikisource 0
trwiktionary 0
ttwiki 36
udmwiki 1
ugwiki 0
ukwiki 2878
ukwikiquote 2
ukwikisource 0
ukwiktionary 0
urwiki 673
urwiktionary 0
uzwiki 191
uzwiktionary 0
vecwiki 10
vecwikisource 0
vepwiki 1
viwiki 3955
viwikisource 0
viwiktionary 0
vlswiki 3
vowiki 1
vowiktionary 0
warwiki 24
wawiki 0
wawiktionary 0
wikidatawiki 613
wuuwiki 27
xalwiki 0
xmfwiki 26
yiwiki 22
yowiki 53
zhwiki 7671
zhwikibooks 3
zhwikinews 11611
zhwikiquote 5
zhwikisource 2
zhwikivoyage 1
zhwiktionary 1
zh_classicalwiki 4
zh_min_nanwiki 13
zh_min_nanwiktionary 0
zh_yuewiki 141
249299