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

SQL

SELECT
	recent_user_text AS 'Username',
	rev_min AS 'First edit',
	user_editcount AS 'Edit count',
	rev_max AS 'Last edit',
	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_text AS recent_user_text, COUNT(*) AS recent_count
    FROM logging_userindex
    WHERE log_type='patrol' AND log_timestamp >= 20150401000000 AND log_action='patrol'
    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='patrol' AND log_action='patrol'
    GROUP BY log_user_text
) log_minmax ON recent_user_text = log_user_text
LEFT JOIN
(
    SELECT
        rev_user_text,
        MIN(rev_timestamp) AS rev_min,
        MAX(rev_timestamp) AS rev_max
    FROM revision_userindex
    GROUP BY rev_user_text
) rev_minmax ON recent_user_text = rev_user_text
LEFT JOIN `user` ON recent_user = user_id
LEFT JOIN ipblocks_ipindex ON recnet_user = ipb_user
;
SQL

Checking query status...
