Untitled query #43760

SQL

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

    /* Results in a set of "new editors" */
     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
                        LEFT JOIN
                    revision_compat    ON rev_user = user_id
              WHERE rev_timestamp BETWEEN DATE_FORMAT(@T - INTERVAL @u DAY, '%%Y%%m%%d%%H%%i%00') AND @T
              GROUP BY user_id, user_name, user_registration

              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
                        LEFT JOIN
                    archive_compat     ON ar_user = user_id
              WHERE ar_timestamp BETWEEN DATE_FORMAT(@T - INTERVAL @u DAY, '%%Y%%m%%d%%H%%i%00') AND @T
              GROUP BY user_id
            ) AS user_content_revision_count
      GROUP BY user_id
     HAVING SUM(revisions) >= @n;
SQL

Checking query status...
