Untitled query #2767

SQL

use enwiki_p;
SELECT
    DATABASE() AS wiki,
    SUM(revisions) AS revisions
FROM (
    SELECT
        COUNT(*) AS revisions
    FROM revision_userindex
    INNER JOIN user_groups ON
        ug_user = rev_user AND
        ug_group = "bot"
    WHERE
        rev_timestamp BETWEEN "20150201" AND "20150301" AND
        rev_user > 0
    UNION ALL
    SELECT
        COUNT(*) AS revisions
    FROM archive_userindex
    INNER JOIN user_groups ON
        ug_user = ar_user AND
        ug_group = "bot"
    WHERE
        ar_timestamp BETWEEN "20150201" AND "20150301" AND
        ar_user > 0
) AS bot_user_revisions;
/*use dewiki_p;
SELECT
    DATABASE() AS wiki,
    SUM(revisions) AS revisions
FROM (
    SELECT
        COUNT(*) AS revisions
    FROM revision_userindex
    INNER JOIN user_groups ON
        ug_user = rev_user AND
        ug_group = "bot"
    WHERE
        rev_timestamp BETWEEN "20150201" AND "20150301" AND
        rev_user > 0
    UNION ALL
    SELECT
        COUNT(*) AS revisions
    FROM archive_userindex
    INNER JOIN user_groups ON
        ug_user = ar_user AND
        ug_group = "bot"
    WHERE
        ar_timestamp BETWEEN "20150201" AND "20150301" AND
        ar_user > 0
) AS bot_user_revisions;
use commonswiki_p;
SELECT
    DATABASE() AS wiki,
    SUM(revisions) AS revisions
FROM (
    SELECT
        COUNT(*) AS revisions
    FROM revision_userindex
    INNER JOIN user_groups ON
        ug_user = rev_user AND
        ug_group = "bot"
    WHERE
        rev_timestamp BETWEEN "20150201" AND "20150301" AND
        rev_user > 0
    UNION ALL
    SELECT
        COUNT(*) AS revisions
    FROM archive_userindex
    INNER JOIN user_groups ON
        ug_user = ar_user AND
        ug_group = "bot"
    WHERE
        ar_timestamp BETWEEN "20150201" AND "20150301" AND
        ar_user > 0
) AS bot_user_revisions;
use ptwiki_p;
SELECT
    DATABASE() AS wiki,
    SUM(revisions) AS revisions
FROM (
    SELECT
        COUNT(*) AS revisions
    FROM revision_userindex
    INNER JOIN user_groups ON
        ug_user = rev_user AND
        ug_group = "bot"
    WHERE
        rev_timestamp BETWEEN "20150201" AND "20150301" AND
        rev_user > 0
    UNION ALL
    SELECT
        COUNT(*) AS revisions
    FROM archive_userindex
    INNER JOIN user_groups ON
        ug_user = ar_user AND
        ug_group = "bot"
    WHERE
        ar_timestamp BETWEEN "20150201" AND "20150301" AND
        ar_user > 0
) AS bot_user_revisions;
use wikidata_p;
SELECT
    DATABASE() AS wiki,
    SUM(revisions) AS revisions
FROM (
    SELECT
        COUNT(*) AS revisions
    FROM revision_userindex
    INNER JOIN user_groups ON
        ug_user = rev_user AND
        ug_group = "bot"
    WHERE
        rev_timestamp BETWEEN "20150201" AND "20150301" AND
        rev_user > 0
    UNION ALL
    SELECT
        COUNT(*) AS revisions
    FROM archive_userindex
    INNER JOIN user_groups ON
        ug_user = ar_user AND
        ug_group = "bot"
    WHERE
        ar_timestamp BETWEEN "20150201" AND "20150301" AND
        ar_user > 0
) AS bot_user_revisions;*/
SQL

Checking query status...
