Active Page curation users

Last run 25 May 2017

First, last, and number of article namespace curation logs of users with any curation logs since 2017-01-01

SQL

SELECT
    recent_user_text AS 'Username',
    recent_count AS 'Number of patrols (in time range)',
    log_min AS 'First patrol (ever)',
    log_max AS 'Last patrol'
FROM
(
    SELECT log_user_text AS recent_user_text, COUNT(*) AS recent_count
    FROM logging_userindex
    WHERE log_type='pagetriage-curation' AND log_timestamp >= 20170101000000
    AND log_namespace = 0
    GROUP BY log_user_text
) log_recent
LEFT JOIN
(
    SELECT
        log_user_text,
        MIN(log_timestamp) AS log_min,
        MAX(log_timestamp) AS log_max
    FROM logging_userindex
    WHERE log_type='pagetriage-curation'
    AND log_namespace = 0
    GROUP BY log_user_text
) loxg_minmax ON recent_user_text = log_user_text
;

SQL

Checking query status...