Untitled query #18136

SQL

USE cswiki_p;
    SET @n = '5'; # <<edits threshold, default 5>>
    SET @u = '30'; # <<activity unit in days, default 30>>
    SET @T = '20170420000000'; # <<end date passed in, or each date between start and end if timeseries>>

    SELECT user_name FROM user WHERE user_id IN (

     SELECT user_id
       FROM (/* Get revisions to content pages that are still visible */
             SELECT user_id,
                    SUM(rev_id IS NOT NULL) AS revisions
               FROM user
                        INNER JOIN
                    logging     ON log_user = user_id
                        LEFT JOIN
                    revision    ON rev_user = user_id
              WHERE log_type = 'newusers'
                AND log_action = 'create'
                AND user_registration BETWEEN (@T - interval @u day) AND @T
                AND rev_timestamp BETWEEN (@T - interval @u day) AND @T
              GROUP BY user_id

              UNION ALL

             /* Get revisions to content pages that have been archived */
             SELECT user_id,
                    /* Note that ar_rev_id is sometimes set to NULL :( */
                    SUM(ar_id IS NOT NULL) AS revisions
               FROM user
                        INNER JOIN
                    logging     ON log_user = user_id
                        LEFT JOIN
                    archive     ON ar_user = user_id
              WHERE log_type = 'newusers'
                AND log_action = 'create'
                AND user_registration BETWEEN (@T - interval @u day) AND @T
                AND ar_timestamp BETWEEN (@T - interval @u day) AND @T
              GROUP BY user_id
            ) AS user_content_revision_count
      GROUP BY user_id
     HAVING SUM(revisions) >= @n

    );
SQL

Checking query status...
