#/curations and last curation since 2016-11-01

Number of curation logs (since 2016-11-01), date of most recent curation log, and current admin status for all users with at least one curation on enwiki since 2016-11-01.

SQL

SELECT
	l.log_user,
	CONCAT('[[User:', user_name, '|', user_name, ']]') AS 'Username',
	log_count AS 'Number of curations',
    DATE_FORMAT(log_max, '%Y-%m-%d') AS 'Last curation',
	COALESCE(ug_user, '') AS 'Admin'
FROM
(
	SELECT
		log_user,
		COUNT(*) AS log_count,
		MAX(log_timestamp) AS log_max
	FROM logging_userindex
	WHERE
		log_type='pagetriage-curation'
		AND log_deleted = 0
		AND log_timestamp >= 20161101000000
	GROUP BY log_user
) l
LEFT JOIN `user` ON l.log_user = user_id
LEFT JOIN
(
	SELECT ug_user
	FROM user_groups
	WHERE ug_group = 'sysop'
) ug ON l.log_user = ug_user;

SQL

Checking query status...