krenair@deployment-tin:~$ while read p; do echo $p; sql $p -e "select max(cuc_timestamp), count(*) from cu_changes"; done </srv/mediawiki-staging/dblists/all-labs.dblist
aawiki
max(cuc_timestamp)	count(*)
20120529203332	3
arwiki
max(cuc_timestamp)	count(*)
20120607134102	7
cawiki
max(cuc_timestamp)	count(*)
NULL	0
commonswiki
max(cuc_timestamp)	count(*)
20120613131336	149
deploymentwiki
max(cuc_timestamp)	count(*)
20120613160735	376
dewiki
max(cuc_timestamp)	count(*)
20120605131149	1166
en_rtlwiki
max(cuc_timestamp)	count(*)
NULL	0
enwiki
max(cuc_timestamp)	count(*)
20120718135609	320
enwikibooks
max(cuc_timestamp)	count(*)
20120613160350	949
enwikinews
max(cuc_timestamp)	count(*)
20120608135320	496
enwikiquote
max(cuc_timestamp)	count(*)
20120610142757	29
enwikisource
max(cuc_timestamp)	count(*)
20120608173349	328
enwikiversity
max(cuc_timestamp)	count(*)
20120610142746	222
enwikivoyage
max(cuc_timestamp)	count(*)
NULL	0
enwiktionary
max(cuc_timestamp)	count(*)
20120609081352	483
eowiki
max(cuc_timestamp)	count(*)
20120610182536	5
eswiki
max(cuc_timestamp)	count(*)
NULL	0
fawiki
max(cuc_timestamp)	count(*)
NULL	0
hewiki
max(cuc_timestamp)	count(*)
20120610182708	19
hiwiki
max(cuc_timestamp)	count(*)
NULL	0
jawiki
max(cuc_timestamp)	count(*)
NULL	0
kowiki
max(cuc_timestamp)	count(*)
NULL	0
loginwiki
max(cuc_timestamp)	count(*)
NULL	0
metawiki
max(cuc_timestamp)	count(*)
20120612074934	427
ruwiki
max(cuc_timestamp)	count(*)
NULL	0
simplewiki
max(cuc_timestamp)	count(*)
20120613161546	370
sqwiki
max(cuc_timestamp)	count(*)
20120610140956	666
testwiki
max(cuc_timestamp)	count(*)
20120531171740	52
ukwiki
max(cuc_timestamp)	count(*)
NULL	0
wikidatawiki
max(cuc_timestamp)	count(*)
NULL	0
zerowiki
max(cuc_timestamp)	count(*)
NULL	0
zhwiki
max(cuc_timestamp)	count(*)
NULL	0
krenair@deployment-tin:~$ while read p; do echo $p; sql $p -e "truncate cu_changes"; done </srv/mediawiki-staging/dblists/all-labs.dblist
aawiki
arwiki
cawiki
commonswiki
deploymentwiki
dewiki
en_rtlwiki
enwiki
enwikibooks
enwikinews
enwikiquote
enwikisource
enwikiversity
enwikivoyage
enwiktionary
eowiki
eswiki
fawiki
hewiki
hiwiki
jawiki
kowiki
loginwiki
metawiki
ruwiki
simplewiki
sqwiki
testwiki
ukwiki
wikidatawiki
zerowiki
zhwiki
krenair@deployment-tin:~$ while read p; do echo $p; sql $p -e "select max(cuc_timestamp), count(*) from cu_changes"; done </srv/mediawiki-staging/dblists/all-labs.dblist
aawiki
max(cuc_timestamp)	count(*)
NULL	0
arwiki
max(cuc_timestamp)	count(*)
NULL	0
cawiki
max(cuc_timestamp)	count(*)
NULL	0
commonswiki
max(cuc_timestamp)	count(*)
NULL	0
deploymentwiki
max(cuc_timestamp)	count(*)
NULL	0
dewiki
max(cuc_timestamp)	count(*)
NULL	0
en_rtlwiki
max(cuc_timestamp)	count(*)
NULL	0
enwiki
max(cuc_timestamp)	count(*)
NULL	0
enwikibooks
max(cuc_timestamp)	count(*)
NULL	0
enwikinews
max(cuc_timestamp)	count(*)
NULL	0
enwikiquote
max(cuc_timestamp)	count(*)
NULL	0
enwikisource
max(cuc_timestamp)	count(*)
NULL	0
enwikiversity
max(cuc_timestamp)	count(*)
NULL	0
enwikivoyage
max(cuc_timestamp)	count(*)
NULL	0
enwiktionary
max(cuc_timestamp)	count(*)
NULL	0
eowiki
max(cuc_timestamp)	count(*)
NULL	0
eswiki
max(cuc_timestamp)	count(*)
NULL	0
fawiki
max(cuc_timestamp)	count(*)
NULL	0
hewiki
max(cuc_timestamp)	count(*)
NULL	0
hiwiki
max(cuc_timestamp)	count(*)
NULL	0
jawiki
max(cuc_timestamp)	count(*)
NULL	0
kowiki
max(cuc_timestamp)	count(*)
NULL	0
loginwiki
max(cuc_timestamp)	count(*)
NULL	0
metawiki
max(cuc_timestamp)	count(*)
NULL	0
ruwiki
max(cuc_timestamp)	count(*)
NULL	0
simplewiki
max(cuc_timestamp)	count(*)
NULL	0
sqwiki
max(cuc_timestamp)	count(*)
NULL	0
testwiki
max(cuc_timestamp)	count(*)
NULL	0
ukwiki
max(cuc_timestamp)	count(*)
NULL	0
wikidatawiki
max(cuc_timestamp)	count(*)
NULL	0
zerowiki
max(cuc_timestamp)	count(*)
NULL	0
zhwiki
max(cuc_timestamp)	count(*)
NULL	0
krenair@deployment-tin:~$