中国語版は意外と頑張ってます

SQL

select "itwiki" as wikiname, count(*) as registered_edits
from itwiki_p.revision
where rev_user != 0;

select "itwiki" as wikiname, count(*) as non_registered_edits
from itwiki_p.revision
where rev_user = 0;

select "eswiki" as wikiname, count(*) as registered_edits
from eswiki_p.revision
where rev_user != 0;

select "eswiki" as wikiname, count(*) as non_registered_edits
from eswiki_p.revision
where rev_user = 0;

select "plwiki" as wikiname, count(*) as registered_edits
from plwiki_p.revision
where rev_user != 0;

select "plwiki" as wikiname, count(*) as non_registered_edits
from plwiki_p.revision
where rev_user = 0;

select "jawiki" as wikiname, count(*) as registered_edits
from jawiki_p.revision
where rev_user != 0;

select "jawiki" as wikiname, count(*) as non_registered_edits
from jawiki_p.revision
where rev_user = 0;

select "zhwiki" as wikiname, count(*) as registered_edits
from zhwiki_p.revision
where rev_user != 0;

select "zhwiki" as wikiname, count(*) as non_registered_edits
from zhwiki_p.revision
where rev_user = 0;
SQL

Checking query status...
