All promotions to usergroup Patroller on enwiki

SQL

SELECT username
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
SELECT username
FROM
(
	SELECT ug_user, ug_group
	FROM user_groups
	WHERE ug_group = 'patroller'
)
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_uiser = user_id;

SQL

Checking query status...