Number of zero namespace articles created, bytes added, edits by Radhatanaya

SQL

use knwiki_p;
SET @log = IFNULL(TRUNCATE(LOG(1024, @bytediff), 0),0);
select count(p.page_id) from revision r, page p where r.rev_parent_id = 0 and p.page_namespace = 0 and p.page_is_redirect = 0 and r.rev_page = p.page_id and r.rev_user_text = 'Radhatanaya';
select CONCAT(ROUND(sum(r.rev_len) / POW(1024, @log), 2), ' ', ELT(@log + 1, 'Bytes', 'KB', 'MB', 'GB', 'TB', 'PB', 'EB', 'ZB', 'YB', 'BB')) from revision r, page p where p.page_namespace = 0 and p.page_is_redirect = 0 and r.rev_page = p.page_id and r.rev_user_text = 'Radhatanaya';
select count(r.rev_id) from revision r, page p where p.page_namespace = 0 and p.page_is_redirect = 0 and r.rev_page = p.page_id and r.rev_user_text = 'Radhatanaya';
select count(r.rev_id) from revision r, page p where r.rev_page = p.page_id and r.rev_user_text = 'Radhatanaya';

use commonswiki_p;
select count(p.page_id) from revision r, page p where r.rev_parent_id = 0 and p.page_namespace = 6 and p.page_is_redirect = 0 and r.rev_page = p.page_id and r.rev_user_text = 'Radhatanaya';
SQL

Checking query status...
