Enwiki New Page Reviewer stats

SQL

-- For https://en.wikipedia.org/wiki/Wikipedia:Request_a_query#Stats_Table_required
USE enwiki_p;
SELECT
	user_id,
	user_name,
    -- DATE(MAX(rights_log.log_timestamp)) AS promotion_date,
    COUNT(curation_log.log_id) AS number_of_curations,
    DATE(MAX(curation_log.log_timestamp)) AS date_of_last_curation,
    -- DATE(MAX(rev_timestamp)) AS date_of_last_edit,
    ug_group AS user_group
FROM user
    INNER JOIN user_groups ON user_id = ug_user
	-- INNER JOIN revision ON user_id = rev_id
	-- LEFT JOIN logging AS rights_log ON user_id = rights_log.log_user
        -- Promotion to new page patroller
        -- AND rights_log.log_type = 'rights'
        -- AND rights_log.log_timestamp > 20161000000000
        -- AND rights_log.log_params LIKE '%newgroups%"patroller"%'
        -- AND rights_log.log_params NOT LIKE '%"patroller"%"patroller"%'
	LEFT JOIN logging AS curation_log ON user_id = curation_log.log_user
WHERE
	-- New page patrollers or sysops
    (ug_group = 'patroller' OR ug_group = 'sysop')
    -- Page curations only
    AND curation_log.log_type = 'pagetriage-curation'
LIMIT 1
;
SQL

Checking query status...
