#/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
	user_name AS 'Username',
	user_registration AS 'Registration',
	user_editcount AS 'Edit count',
	recent_count AS 'Number of patrols (in time range)',
	log_min AS 'First patrol (ever)',
	log_max	AS 'Last patrol',
	ipb_expiry AS 'Block expiry',
	ipb_reason AS 'Block reason'
FROM
(
	SELECT log_user AS recent_user, COUNT(*) AS recent_count
	FROM logging_userindex
	WHERE log_type='patrol' AND log_timestamp >= 20160401000000 AND log_action='patrol'
	GROUP BY log_user
) log_recent
LEFT JOIN
(
	SELECT
		log_user,
		MIN(log_timestamp) AS log_min,
		MAX(log_timestamp) AS log_max
	FROM logging_userindex
	WHERE log_type='patrol' AND log_action='patrol'
	GROUP BY log_user
) log_minmax ON recent_user = log_user
INNER JOIN `user` ON recent_user = user_id
LEFT JOIN ipblocks_ipindex ON recent_user = ipb_user
;

SQL

Checking query status...