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>>

    SELECT CAST(user_name AS CHAR(10000) CHARACTER SET utf8) FROM user WHERE user_id IN (

    /* 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%i00') AND @T
              GROUP BY user_id, user_name, user_registration
            ) AS user_content_revision_count
      GROUP BY user_id
     HAVING SUM(revisions) >= @n

    );
SQL

Checking query status...
