Editors with more 300 edits

SQL

use ptwiki_p;
SET @n = 100; /* edits threshold */

SELECT
    user
FROM (
    /* Get revisions to content pages that are still visible */
    SELECT
        rev_user_text as user,
        SUM(rev_id IS NOT NULL) AS revisions
    FROM
        revision
    WHERE
        rev_user != 0
    AND
        rev_timestamp BETWEEN 20161027000000 and 20160927000000
    GROUP BY user

    UNION ALL

    /* Get revisions to content pages that have been archived */
    SELECT
        ar_user as user,
        SUM(ar_id IS NOT NULL) AS revisions
    FROM
        archive
    WHERE
        ar_user != 0
    AND
        ar_timestamp BETWEEN 20161027000000 and 20161020000000
    and
        ar_namespace = 0
    GROUP BY
        user
    ) AS user_content_revision_count

GROUP BY
    user
HAVING
    SUM(revisions) >= @n;
SQL

Checking query status...
