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