All promotions to usergroup Patroller on enwiki

SQL

SELECT user_name
FROM
(
	SELECT DISTINCT log_user
	FROM logging_userindex
	WHERE
		log_type='pagetriage-curation'
		AND log_deleted = 0
		AND log_timestamp >= 20161101000000
) l1 LEFT JOIN `user` ON l1.log_user = user_id
UNION DISTINCT
SELECT user_name
FROM
(
	SELECT ug_user, ug_group
	FROM user_groups
	WHERE ug_group = 'patroller'
) ug
LEFT JOIN
(
	SELECT DISTINCT log_user
	FROM logging_userindex
	WHERE
		log_type='pagetriage-curation'
		AND log_deleted = 0
		AND log_timestamp >= 20161101000000
) l2 ON l2.log_user = ug_user
LEFT JOIN `user` ON ug_user = user_id
WHERE l2.log_user IS NULL;

SQL

Checking query status...