Monthly bot edits by namespace (German, Portuguese, Spanish, French, Chinese, Japanese)

SQL

use dewiki_p;
SELECT LEFT(rev_timestamp, 6) AS month, page_namespace, COUNT(*) AS n
FROM revision_userindex
INNER JOIN u2041__botvbot_p.crosswiki_unified_bot ON rev_user_text = username
INNER JOIN page ON rev_page = page_id
GROUP BY 1, 2;
use ptwiki_p;
SELECT LEFT(rev_timestamp, 6) AS month, page_namespace, COUNT(*) AS n
FROM revision_userindex
INNER JOIN u2041__botvbot_p.crosswiki_unified_bot ON rev_user_text = username
INNER JOIN page ON rev_page = page_id
GROUP BY 1, 2;
use eswiki_p;
SELECT LEFT(rev_timestamp, 6) AS month, page_namespace, COUNT(*) AS n
FROM revision_userindex
INNER JOIN u2041__botvbot_p.crosswiki_unified_bot ON rev_user_text = username
INNER JOIN page ON rev_page = page_id
GROUP BY 1, 2;
use frwiki_p;
SELECT LEFT(rev_timestamp, 6) AS month, page_namespace, COUNT(*) AS n
FROM revision_userindex
INNER JOIN u2041__botvbot_p.crosswiki_unified_bot ON rev_user_text = username
INNER JOIN page ON rev_page = page_id
GROUP BY 1, 2;
use zhwiki_p;
SELECT LEFT(rev_timestamp, 6) AS month, page_namespace, COUNT(*) AS n
FROM revision_userindex
INNER JOIN u2041__botvbot_p.crosswiki_unified_bot ON rev_user_text = username
INNER JOIN page ON rev_page = page_id
GROUP BY 1, 2;
use jawiki_p;
SELECT LEFT(rev_timestamp, 6) AS month, page_namespace, COUNT(*) AS n
FROM revision_userindex
INNER JOIN u2041__botvbot_p.crosswiki_unified_bot ON rev_user_text = username
INNER JOIN page ON rev_page = page_id
GROUP BY 1, 2;
SQL

Checking query status...
