Untitled query #24557

SQL

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

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

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

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

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

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

Checking query status...
