legoktm@terbium:~$ foreachwikiindblist /srv/mediawiki/large.dblist sql.php /home/legoktm/echo-alert.sql --slave=any
-----------------------------------------------------------------
arwiki
-----------------------------------------------------------------
arwiki:  stdClass Object
arwiki:  (
arwiki:      [count(*)] => 59
arwiki:  )
-----------------------------------------------------------------
cawiki
-----------------------------------------------------------------
cawiki:  stdClass Object
cawiki:  (
cawiki:      [count(*)] => 7
cawiki:  )
-----------------------------------------------------------------
cebwiki
-----------------------------------------------------------------
cebwiki:  stdClass Object
cebwiki:  (
cebwiki:      [count(*)] => 1
cebwiki:  )
-----------------------------------------------------------------
commonswiki
-----------------------------------------------------------------
commonswiki:  stdClass Object
commonswiki:  (
commonswiki:      [count(*)] => 191
commonswiki:  )
-----------------------------------------------------------------
dewiki
-----------------------------------------------------------------
dewiki:  stdClass Object
dewiki:  (
dewiki:      [count(*)] => 350
dewiki:  )
-----------------------------------------------------------------
enwiki
-----------------------------------------------------------------
enwiki:  stdClass Object
enwiki:  (
enwiki:      [count(*)] => 3646
enwiki:  )
-----------------------------------------------------------------
enwikinews
-----------------------------------------------------------------
enwikinews:  stdClass Object
enwikinews:  (
enwikinews:      [count(*)] => 10
enwikinews:  )
-----------------------------------------------------------------
enwikisource
-----------------------------------------------------------------
enwikisource:  stdClass Object
enwikisource:  (
enwikisource:      [count(*)] => 13
enwikisource:  )
-----------------------------------------------------------------
enwiktionary
-----------------------------------------------------------------
enwiktionary:  stdClass Object
enwiktionary:  (
enwiktionary:      [count(*)] => 30
enwiktionary:  )
-----------------------------------------------------------------
eswiki
-----------------------------------------------------------------
eswiki:  stdClass Object
eswiki:  (
eswiki:      [count(*)] => 168
eswiki:  )
-----------------------------------------------------------------
fawiki
-----------------------------------------------------------------
fawiki:  stdClass Object
fawiki:  (
fawiki:      [count(*)] => 27
fawiki:  )
-----------------------------------------------------------------
frwiki
-----------------------------------------------------------------
frwiki:  stdClass Object
frwiki:  (
frwiki:      [count(*)] => 132
frwiki:  )
-----------------------------------------------------------------
frwikisource
-----------------------------------------------------------------
frwikisource:  stdClass Object
frwikisource:  (
frwikisource:      [count(*)] => 4
frwikisource:  )
-----------------------------------------------------------------
frwiktionary
-----------------------------------------------------------------
frwiktionary:  stdClass Object
frwiktionary:  (
frwiktionary:      [count(*)] => 4
frwiktionary:  )
-----------------------------------------------------------------
idwiki
-----------------------------------------------------------------
idwiki:  stdClass Object
idwiki:  (
idwiki:      [count(*)] => 23
idwiki:  )
-----------------------------------------------------------------
incubatorwiki
-----------------------------------------------------------------
incubatorwiki:  stdClass Object
incubatorwiki:  (
incubatorwiki:      [count(*)] => 5
incubatorwiki:  )
-----------------------------------------------------------------
itwiki
-----------------------------------------------------------------
itwiki:  stdClass Object
itwiki:  (
itwiki:      [count(*)] => 113
itwiki:  )
-----------------------------------------------------------------
jawiki
-----------------------------------------------------------------
jawiki:  stdClass Object
jawiki:  (
jawiki:      [count(*)] => 459
jawiki:  )
-----------------------------------------------------------------
kowiki
-----------------------------------------------------------------
kowiki:  stdClass Object
kowiki:  (
kowiki:      [count(*)] => 95
kowiki:  )
-----------------------------------------------------------------
metawiki
-----------------------------------------------------------------
metawiki:  stdClass Object
metawiki:  (
metawiki:      [count(*)] => 76
metawiki:  )
-----------------------------------------------------------------
mgwiktionary
-----------------------------------------------------------------
mgwiktionary:  stdClass Object
mgwiktionary:  (
mgwiktionary:      [count(*)] => 0
mgwiktionary:  )
-----------------------------------------------------------------
mkwiki
-----------------------------------------------------------------
mkwiki:  stdClass Object
mkwiki:  (
mkwiki:      [count(*)] => 0
mkwiki:  )
-----------------------------------------------------------------
nlwiki
-----------------------------------------------------------------
nlwiki:  stdClass Object
nlwiki:  (
nlwiki:      [count(*)] => 70
nlwiki:  )
-----------------------------------------------------------------
nowiki
-----------------------------------------------------------------
nowiki:  stdClass Object
nowiki:  (
nowiki:      [count(*)] => 9
nowiki:  )
-----------------------------------------------------------------
plwiki
-----------------------------------------------------------------
plwiki:  stdClass Object
plwiki:  (
plwiki:      [count(*)] => 41
plwiki:  )
-----------------------------------------------------------------
ptwiki
-----------------------------------------------------------------
ptwiki:  stdClass Object
ptwiki:  (
ptwiki:      [count(*)] => 102
ptwiki:  )
-----------------------------------------------------------------
rowiki
-----------------------------------------------------------------
rowiki:  stdClass Object
rowiki:  (
rowiki:      [count(*)] => 15
rowiki:  )
-----------------------------------------------------------------
ruwiki
-----------------------------------------------------------------
ruwiki:  stdClass Object
ruwiki:  (
ruwiki:      [count(*)] => 227
ruwiki:  )
-----------------------------------------------------------------
shwiki
-----------------------------------------------------------------
shwiki:  stdClass Object
shwiki:  (
shwiki:      [count(*)] => 0
shwiki:  )
-----------------------------------------------------------------
srwiki
-----------------------------------------------------------------
srwiki:  stdClass Object
srwiki:  (
srwiki:      [count(*)] => 9
srwiki:  )
-----------------------------------------------------------------
svwiki
-----------------------------------------------------------------
svwiki:  stdClass Object
svwiki:  (
svwiki:      [count(*)] => 24
svwiki:  )
-----------------------------------------------------------------
trwiki
-----------------------------------------------------------------
trwiki:  stdClass Object
trwiki:  (
trwiki:      [count(*)] => 54
trwiki:  )
-----------------------------------------------------------------
ukwiki
-----------------------------------------------------------------
ukwiki:  stdClass Object
ukwiki:  (
ukwiki:      [count(*)] => 19
ukwiki:  )
-----------------------------------------------------------------
viwiki
-----------------------------------------------------------------
viwiki:  stdClass Object
viwiki:  (
viwiki:      [count(*)] => 11
viwiki:  )
-----------------------------------------------------------------
warwiki
-----------------------------------------------------------------
warwiki:  stdClass Object
warwiki:  (
warwiki:      [count(*)] => 0
warwiki:  )
-----------------------------------------------------------------
wikidatawiki
-----------------------------------------------------------------
wikidatawiki:  stdClass Object
wikidatawiki:  (
wikidatawiki:      [count(*)] => 48
wikidatawiki:  )
-----------------------------------------------------------------
zhwiki
-----------------------------------------------------------------
zhwiki:  stdClass Object
zhwiki:  (
zhwiki:      [count(*)] => 199
zhwiki:  )
-----------------------------------------------------------------
zhwiktionary
-----------------------------------------------------------------
zhwiktionary:  stdClass Object
zhwiktionary:  (
zhwiktionary:      [count(*)] => 2
zhwiktionary:  )
legoktm@terbium:~$ cat echo-alert.sql 
select count(*) from user_properties where up_property ='echo-show-alert' and up_value=0;