Untitled query #14789

SQL

use knwiki_p;
SET @n = 100; /* edits threshold */
SET @u = 180; /* activity unit in days */
SET @T = "20161028"; /* to replace with dynamic value */


SELECT
    user, revisions
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
      join page
      on page_id = rev_page
    WHERE
        rev_user != 0
    AND
        rev_timestamp BETWEEN DATE_FORMAT(DATE_SUB(@T, INTERVAL @u DAY), "%Y%m%d%H%i%S") AND @T
    and
    page_namespace = 0
    GROUP BY user
    ) AS user_content_revision_count


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

Checking query status...
